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**). ---

Job profile for which I was to be interviewed was for Big Data Engineer. First Round - Online coding round - 10 MCQs of Big Data and 1 code data structure analytics problem solving question which was to be written in any language. I wrote the code in python and they selected me for 2nd round to be conducted in Banglore (Just FYI my current location at that time was Pune). No travel and accommodation allowance was provided to me for to and from Banglore, which I felt really unprofessional. 2nd round - This was supposed to be a technical round on Big data. But they never asked me single question on big data or any related technologies like hadoop/spark or AWS cloud on which I had expertise as per my resume. All they were concerned about was JAVA professional expertise. I clearly mentioned them that I worked on JAVA 2 years back and now I work purely on python but could catch up if opportunity is provided. Although I answered most of the internal JAVA questions but they were too much adamant on making me write JAVA code on eclipse even though they were aware that I attempted the coding exam in python. Clearly I couldn't pass through the interview but the unprofessional work of the recruitment team to blindly select the candidates which do not match your job requirement and call them to other city really dissapointed me.