Screening call followed by interview Teams. Interview went for 40 mins. Started with asking my skill and tech stack then current project responsibilities. questions asked on
I have worked extensively with **reporting and ETL tools** across different environments. My experience includes working with:
* **dbt (Data Build Tool):** Mainly for transformation-focused ELT processes on cloud data warehouses.
* **Metallion:** To optimize platforms like **Snowflake, Redshift, and BigQuery**.
* **Informatica PowerCenter:** For **advanced data governance** and handling very large datasets in enterprise data warehouses.
To optimize ETL/ELT processes, I have implemented various techniques, ensuring better performance and governance.
---
### Example Project: Ford Motors (Data Assessment & Migration)
One of the major projects I worked on was with **Ford Motors**, where I was responsible for **data assessment, migration planning, and ETL pipeline development**.
**Scope & Responsibilities:**
* Analyzed the **SQL Server database schema** and identified critical tables for migration.
* Performed **data assessment and migration planning** to move data from SQL Server to Snowflake.
* Developed **Azure Data Factory (ADF) pipelines** for batch and streaming data processing.
* Handled **deployment, optimization, and version control** for ETL pipelines.
* Managed **end-to-end lifecycle**: development, testing, and production deployments.
**Key Achievements:**
* Successfully migrated **50 TB of data** from SQL Server to Snowflake.
* Achieved **30% cost reduction** in storage and compute by optimizing ELT processes.
* Improved **query performance by 40%** through optimized **star schema modeling**.
---
### Technical Strengths
* Strong experience integrating and implementing ETL on cloud platforms using **SQL and Snowflake**.
* Set up **GCP and Snowflake environments** to handle extraction, transformation, and loading of data.
* Automated ETL processes using **GCP Cloud Functions**, scheduling, and monitoring.
* Advanced SQL skills (self-rated **4 out of 5**).
---
