Senior Test Lead (Bengaluru)

Senior Test Lead (Bengaluru)

21 Nov
|
HCLTech
|
Bengaluru

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 strong 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

Robust 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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior test lead (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: senior test lead (bengaluru) / bengaluru