About

Abin Alex

Abin Alex

Data Engineering Manager & Data Architect

15+ years turning messy data into reliable pipelines, dashboards, and decisions, currently exploring where agentic AI meets data engineering.

15+
Years Experience
50+
ELT Pipelines Built
3
Active Certifications

My Journey

Now
Leading Data & Analytics for a large enterprise
Owning the ETL platform, architecting Snowflake + Matillion pipelines integrating multiple SaaS platforms, mentoring engineers on best practices.
Earlier
Managed teams & client engagements in analytics consulting
Led a dbt-based data transformation project for a Gates Foundation-funded education initiative, and modernized Tableau/Power BI reporting for global enterprises.
Where it started
BI analyst & technology analyst
Built dashboards in Tableau, Alteryx, and QlikView, and worked on SAP-based reporting and automation, right after a B.Tech in Computer Science Engineering.

Skills & Certifications

Snowflake Matillion Tableau dbt Python Microsoft Fabric AWS Data Warehousing Data Modelling SQL
✓
SnowPro Core Certified
Expires Aug 2027
✓
Microsoft Certified: Fabric Data Engineer
Expires Jul 2027
✓
Tableau Desktop Qualified Associate
Since 2016

Beyond Work

You'll usually find me playing badminton, painting, or sketching, activities that keeps me motivated. I'm also spending time exploring Indian equity markets on the side, which occasionally sneaks into my writing here too.

Let's connect

Comments

Post a Comment

Popular posts from this blog

How to fetch data from SnowFlake using Excel VBA?

Image
The easiest way to fetch data from databases to Excel is using the Get Data option available under the Data Tab, Excel creates a query using the ODBC connection and fetches the data without the hassle of coding. But coding makes the process more flexible and is very dynamic. Here goes the details... 1) Download and install the snowflake ODBC driver either 32 or 64 bit depending on your MS Office Installation & OS from the SnowFlake portal, available under the Help menu. 2) Create a DSN with the correct connection properties. 3) Add the below reference if required in the visual basic editor and also change the DSN name in the VBA code. VBA Code...  '----------------------------------------------------------------------------------------------------------------------------------------- Sub VBA_SnowFlake_Connect() Dim sSQLQry As String Dim ReturnArray Dim Conn As ADODB.Connection Dim rs As ADODB.Recordset Dim DBPath As String, sconne...
Read more

How to clear Tableau Desktop Qualified Associate Exam (TDQA 10).

Preparation Time : Minimum 4 weeks for candidates with no prior Tableau experience. Tableau DQA is a 2 hours exam which consists of 36 questions, both theoretical and practical. All questions must be answered to complete the test(there is no negative marks) and 75 % score is needed to pass the test. Questions are either multiple-choice, multiple-answer, or True /False. TDQA10 . Total Time 2 hrs. Total Questions 36 Marks distribution 2,3&4 Total Points 100 Passing Points 75 Category Points Mod 1 - Data Connections 22 Mod 2 - Organizing and Simplifying Data 10 Mod 3 - Field and Chart Types 16 Mod 4 - Calculations 18 Mod 5 - Mapping 8 Mod 6 - Analytics 15 Mod 7 - Dashboards 11 Total 100 TDQA Preparation Materials Watch all the Tableau...
Read more

Web Scraping and Automatic data refresh using Google Sheets and Tableau Public

Image
Recently I have figured out how to do web scraping using google sheets and to automatically refresh a dashboard on tableau public. So here it is…just sharing what I have learned. Tools I have used Tableau Public Desktop. Google Sheets. At first, you have to find out the live data source and import that data to google sheets. In my case, I have fetched the live air pollution data from  https://data.gov.in/catalog/real-time-air-quality-index  and next step is to import that data to google sheets. Input is an XML file and was available using API and I have got the access by registering and generating an API key. Next step open your google sheets and import the data using IMPORTXML function available in google sheets.   Format : IMPORTXML("URL","XPath") URL : link to your data source XPath : used to navigate through elements and attribute in XML ( https://www.w3schools.com/xml/xpath_intro.asp ). Same way there are different functions ...
Read more