21 Nov
|
HCLTech
|
Bengaluru
Job Summary
Band: E2.2
Experience: 6–10 years
Role: Senior ETL / Data Warehouse Test Engineer
Primary Skills: ETL Testing, Data Warehouse Testing, SQL, Source-to-Target Validation, Data Reconciliation, BI Testing
We are looking for an experienced ETL / Data Warehouse Test Engineer with robust expertise in validating enterprise data pipelines, data warehouse solutions, ETL processes and BI/reporting applications. The candidate will be responsible for end-to-end data validation, source-to-target reconciliation, test design and execution, defect management, and ensuring data accuracy and quality across complex data platforms.
Key Responsibilities
Analyse business and technical requirements, identify ambiguities, and define comprehensive ETL/Data Warehouse test scenarios.Design, develop and execute test cases for ETL pipelines, data warehouses and BI/reporting solutions.Validate Source-to-Target Mapping (STM), transformation rules, business rules and data mappings.Perform end-to-end data validation, reconciliation, completeness, integrity and data-quality checks.Write complex SQL queries involving joins, subqueries, aggregations and validations for backend testing.Validate ETL jobs, batch processing, data loads, incremental loads and error/reject handling.Validate BI reports and dashboards against underlying warehouse/source data.Prepare and maintain appropriate test data and mock datasets, including large-volume datasets.Perform requirement reviews, test estimation, risk assessment, defect analysis and root-cause investigation.Manage test cases, defects and testing progress using Jira,
with documentation maintained in Confluence where applicable.Participate in Agile activities including sprint planning, backlog refinement, daily Scrum and release planning.Work closely with developers, data engineers, business analysts, product owners and business stakeholders throughout the delivery lifecycle.Support continuous testing and quality-engineering practices within Agile/DevOps delivery models.
Skill Requirements
6–10 years of experience in Software Testing / Quality AssuranceStrong hands-on experience in ETL and Data Warehouse TestingAdvanced SQL and database validation skillsSource-to-Target Mapping validationData reconciliation and data-quality validationGood understanding of ETL architecture and testing methodologiesExperience with databases such as Oracle, SQL Server, PostgreSQL, MySQL or TeradataWorking knowledge of Unix/LinuxBI/reporting validation experienceJira and Agile/Scrum experienceStrong requirement analysis and test estimation capabilities
Must Have Skill
Data Warehouse Systems,Databases,Extract Transform Load (ETL) Automation,Linux,Teradata
Good to Have Skill
Oracle DataStage
Other Requirements
Experience with Informatica, DataStage, Talend, SSIS, Ab Initio or Azure Data FactoryExposure to AWS, Microsoft Azure or Google Cloud data platformsBig Data testing exposureUnderstanding of DevOps and continuous-testing practicesConfluence experience
Strong analytical and problem-solving skillsExcellent attention to data accuracy and qualityStrong written and verbal communicationCustomer-facing and stakeholder-management capabilityAbility to work independently within distributed Agile teamsAbility to manage multiple priorities and proactively identify quality risks
📌 Senior Test Lead (Bengaluru)
🏢 HCLTech
📍 Bengaluru