Etl Test Engineer- Azure

Job Summary

We are looking for an experienced ETL Test Engineer / Data QA Engineer with strong expertise in ETL testing and Azure cloud-based data platforms. The candidate should have hands-on experience in validating data pipelines, data transformations, data migration, and data quality across Azure-based environments.

Mandatory Skills

• 613 years of experience in ETL/Data Testing.
• Strong hands-on experience in ETL Testing.
• Good experience with Azure data services and Azure-based ETL pipelines.
• Strong SQL skills for data validation and reconciliation.
• Experience in source-to-target data validation.
• Experience testing data transformation, data mapping, and data migration.
• Good understanding of Azure Data Factory (ADF).
• Experience validating ETL/ELT pipelines.
• Strong understanding of Data Warehousing concepts.
• Experience in defect tracking and Agile/Scrum methodologies.

Key Responsibilities

• Analyze ETL requirements, source-to-target mappings, and functional specifications.
• Design and execute ETL test scenarios, test cases, and test scripts.
• Validate data extraction from source systems and loading into target systems.
• Perform source-to-target data validation using SQL.
• Validate data transformations, business rules, joins, aggregations, filters, and calculations.
• Test Azure Data Factory pipelines, datasets, triggers, activities, and data flows.
• Validate data movement between Azure services and other source/target systems.
• Perform data reconciliation and completeness checks.
• Identify data quality issues such as duplicates, missing records, truncation, incorrect mappings, and data type mismatches.
• Validate incremental and full-load processes.
• Perform ETL regression, integration, functional, and data migration testing.
• Analyze pipeline failures and work with developers/data engineers to resolve defects.
• Create and maintain test evidence and defect reports.
• Participate in Agile ceremonies including sprint planning, refinement, daily stand-ups, and retrospectives.
• Support UAT and production validation activities.