ETL QA Engineer
blackbuck insights · Bengaluru · onsite · Posted 37d ago
Undisclosed5–7 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Summary
Responsibilities
Requirements
Good to Have
Experience
Education
Key Competencies
Job Type
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
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.
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 modeling, 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 degree in Computer Science, Information Technology, Engineering, or a related field.
Key Competencies
- Strong SQL and data-analysis skills
- ETL
Job Type
Full time
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
data qualityDatastageData Warehouse TestingDefect managementPythonSQLData WarehousingInformation TechnologyData ValidationETL Testing
About Blackbuck Insights
blackbuck insights
IT Services & Consulting
350
employees
2016
10 years old
Bengaluru/Bangalore, Karnataka
India
₹16.2L PA avg
Avg at Blackbuck Insights
About
BBI is a multi-national IT consulting services provider in the new-generation digital technology ecosystem.
Industries
IT Services & ConsultingMedia & Entertainment / Publishing
Employee ratings
10 reviews
3.8/ 5
Culture
3.3
Career growth
3.0
Work-life
4.6
Employees rate it well for
Work-Life Balance40Skill Development38
Find them on