Job Title : ETL Test Engineer
Experience Required : Minimum 5 years
Location : Gurgoan
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.(ref : hirist.tech)