ETL QA Engineer
Posted 1
view
Summary
Validates data pipelines, ETL processes, and data warehouse loads for Blackbuck Insights: writing test cases, running complex SQL for source-to-target data validation and reconciliation, testing batch jobs and SCD loads, and managing defects in Jira. 5-7 years of ETL/Data QA experience required.
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.
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 SDLC and STLC.
- Experience with defect-management and test-management tools such as Jira, ALM, or similar.
- Strong analytical and problem-solving skills.
Good to Have
- Experience with ETL tools such as Informatics, SSIS, DataStage, or Azure Data Factory.
- Experience with cloud data platforms such as Snowflake, AWS, or Azure.
- Knowledge of Python or another scripting language for test automation.
- Experience with CI/CD and automated testing frameworks.
- Exposure to data-quality and data-governance concepts.
- Experience testing APIs or downstream reporting/BI systems.
Experience
5-7 years of experience in ETL Testing, Data Warehouse Testing, Data QA, or a related role.
Education
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
Key Competencies
- Strong SQL and data-analysis skills
- ETL