ETL QA Engineer

Blackbuck Insights; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Blackbuck Insights in Bengaluru is seeking an experienced ETL QA Engineer to validate data pipelines, ETL processes, and data warehouse loads. You will ensure data quality across source-to-target mappings and support defect management.

The role requires strong SQL skills, hands-on ETL testing, and familiarity with SDLC/ STLC. You will collaborate with data engineers, BI teams, and analysts to deliver reliable data products.

Qualifications

• 5-7 years of experience in ETL Testing and Data QA.
• Strong SQL and relational database knowledge.
• Experience with data warehouses and ETL validation.

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

Skills

ETL Testing

SQL

Data Validation

Source-to-Target Mapping

Data Reconciliation

Dimensional Modelling

SCD Type 1/2

SDLC/STLC

Jira

ALM

Education

Bachelor's degree in CS/IT/Engineering

Tools

Jira

ALM

Job description

BBI is a global data engineering consulting firm that empowers clients to effectively scale and modernize. We combine engineering fundamentals and innovative tools to execute business-critical, end-to-end projects on-time and on-budget. We offer expert services across Data Integration, Data Modernization, Data Migration, Data Architecture, Platform Support, and Application Services. Our goal is to provide business value in the most effective way for our clients so clients can focus on growth.

Job Description

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