Senior ETL Tester

Job Title: Sr. ETL Test Engineer

Experience Required: Minimum 8 years

Location: Gurgaon/ Noida (WFO)

About the Role

We are seeking an experienced ETL Test Engineer with strong expertise in cloud-based ETL tools, Azure ecosystem, and advanced SQL skills. The ideal candidate will have a proven track record in validating complex data pipelines, ensuring data integrity, and collaborating with cross-functional teams in an Agile environment.

Key Responsibilities

• Design, develop, and execute ETL test plans, test cases, and test scripts for cloud-based data pipelines.
• Perform data validation, transformation, and reconciliation between source and target systems.
• Work extensively with Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, and related Azure services.
• Develop and run complex SQL queries for data extraction, analysis, and validation.
• Collaborate with developers, business analysts, and product owners to clarify requirements and ensure comprehensive test coverage.
• Perform regression, functional, and performance testing of ETL processes.
• Identify defects, log them, and work with development teams to ensure timely resolution.
• Participate in Agile ceremonies (daily stand-ups, sprint planning, retrospectives) and contribute to continuous improvement.
• Ensure adherence to data quality and compliance standards.

Required Skills & Experience

• 5+ years of experience in ETL testing, preferably with cloud-based ETL tools.
• Strong hands-on experience with Azure Data Factory, Azure Synapse Analytics, and Azure SQL.
• Advanced SQL query writing and performance tuning skills.
• Strong understanding of data warehousing concepts, data models, and data governance.
• Experience with Agile methodologies and working in a Scrum team.
• Excellent communication and stakeholder management skills.
• Strong problem-solving skills and attention to detail.

Preferred Skills

• Experience with Python, PySpark, or automation frameworks for ETL testing.
• Exposure to CI/CD pipelines in Azure DevOps or similar tools.
• Knowledge of data security, compliance, and privacy regulations.

Job Type: Full-time

Pay: ₹1,200,000.00 - ₹1,500,000.00 per year

Work Location: In person