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 solid 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.

Requirements
- Strong hands-on experience in ETL/Data Warehouse Testing.
- Excellent knowledge of SQL and relational databases.
- Understanding of ETL concepts and data warehouse architecture.
- Experience with source-to-target mapping and data reconciliation.
- Knowledge of dimensional modelling, fact and dimension tables.
- Understanding of SCD Types 1 and 2.
- Experience testing batch jobs and data pipelines.
- Good understanding of SDL

📌 ETL QA Engineer (Bengaluru)
🏢 Blackbuck Insights
📍 Bengaluru