Senior Test Lead

6 - 10 years

Bengaluru

Posted:15 hours ago

Job Description

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

Skills Required

ETL Data Warehouse ETL Testing SQL Reconciliation Data Validation Test Design Defect Management Test Scenarios Test Cases ETL Pipelines Business Rules

Learn the skills this job asks for

See your skill gap for QA / Test Engineer →

Free courses, interview questions and practice for each skill.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
HCLTech logo
HCLTech

Information Technology Services

New Delhi

RecommendedJobs for You

Infinite Computer Solutions Ltd. logo

Senior Test Lead

Infinite Computer Solutions Ltd.

Pune

Infinite Computer Solutions Ltd. logo

Senior Test Lead

Infinite Computer Solutions Ltd.

Pune