IN_Sr Associate – Senior Data Engineer / ETL QA Engineer – D&A– Advisory – Gurgaon

Job Description & Summary:

We are seeking an experienced Senior Data Engineer / ETL QA Engineer with strong hands-on expertise in Snowflake, SQL, AWS/GCP, ETL testing, data warehousing, data analysis, Python, Microsoft Fabric, and Azure Data Factory. The role requires the ability to design, develop, validate, optimize, and support scalable data pipelines and backend data solutions while ensuring high-quality, reliable, and secure data delivery for the US Healthcare domain.

Responsibilities:

Data Engineering & Integration: Design, develop, and optimize scalable backend data solutions and ETL/ELT pipelines using Snowflake, SQL, AWS/GCP, Python, Microsoft Fabric, and Azure Data Factory.

ETL Testing & Data Validation: Perform end-to-end ETL testing, data analysis, validation, reconciliation, and defect analysis across data warehouse environments using complex SQL queries.

Snowflake & Cloud Development: Build and support Snowflake-based solutions, including performance tuning, workload optimization, and integration with AWS services such as CloudWatch, Lambda, Glue, and EMR clusters.

ETL Process Ownership: Demonstrate end-to-end understanding of ETL processes, complex job flows, data flows, day-to-day loads, and operational dependencies across the project.

Issue Analysis & Production Support: Analyze daily load issues, job failures, defects, and escalations; take corrective actions and document complex issues for resolution and future reference.

Testing Methodology & Defect Management: Apply strong testing methodology, use defect tracking tools effectively, and ensure data quality, accuracy, completeness, and reliability across the data lifecycle.

Agile Collaboration: Work in an agile delivery model with data engineers, QA teams, business analysts, and stakeholders; demonstrate strong strategic thinking, problem-solving, communication, and analytical skills.

Healthcare Domain Alignment: Apply working knowledge of US Healthcare data, workflows, and reporting needs to support testing, analysis, and data platform modernization initiatives.

Mandatory skill sets:

• 5+ years of hands-on experience in ETL testing, data warehousing, data analysis, and SQL-based validation

• Strong expertise in Snowflake, SQL, Unix, complex query writing, and Snowflake performance tuning

• Hands-on cloud experience with AWS/GCP, including AWS services such as CloudWatch, Lambda, Glue, and EMR clusters

• Working knowledge of Python, Microsoft Fabric, Azure Data Factory, and modern ETL/ELT frameworks

Preferred skill sets:

• Strong understanding of US Healthcare data, defect tracking tools, agile methodology, AEDL dashboard setup exposure, and production support processes

Years of experience required:

5 to 8 years

Why Join Us?

• Work on a high-impact data transformation and AI readiness program

• Exposure to modern data stack (Snowflake + Salesforce ecosystem)

• Opportunity to shape enterprise-wide data integration architecture

Education qualification:

BE, B.Tech, ME, M,Tech, MBA, MCA (60% above)