ETL QA Engineer

We are looking for an experienced ETL QA Engineer / Data QA Engineer responsible for validating data pipelines, ETL processes, data transformations, and data warehouse solutions. The ideal candidate should have strong SQL skills and hands-on experience with ETL testing, data validation, and defect management.

Key Responsibilities

• Analyse business and technical requirements and prepare test scenarios and test cases.
  
• Perform ETL testing for data extraction, transformation, and loading processes.
  
• Validate source-to-target data mappings and transformation rules.
  
• Perform data validation using complex SQL queries.
  
• Verify data completeness, accuracy, consistency, and integrity across source and target systems.
  
• Test data pipelines, batch jobs, interfaces, and data warehouse loads.
  
• Perform data reconciliation between source systems, staging areas, and target databases.
  
• Validate incremental loads, full loads, historical data, and slowly changing dimensions (SCD).
  
• Test error handling, duplicate records, null values, boundary conditions, and data-quality rules.
  
• Execute regression, integration, system, and end-to-end testing.
  
• Identify, document, track, and retest defects using tools such as Jira or similar defect-management systems.
  
• Work closely with developers, ETL developers, business analysts, and data engineers to resolve data-related issues.
  
• Participate in test planning, estimation, execution, and reporting.
  
• Contribute to automation of repetitive data-validation and regression test scenarios where applicable.