Senior Automation Test Lead - ETL, DW Automation (India)

Senior Automation Test Lead - ETL, DW Automation (India)

15 Aug
|
HCLTech
|
India

15 Aug

HCLTech

India

Madurai, Tamil Nadu
Job Summary

We are seeking an experienced Senior QA Engineer to lead quality assurance efforts across our Data & Analytics ecosystem. This role will be responsible for validating end-to-end data pipelines, data platforms, APIs, and analytics solutions through a combination of manual and automated testing practices. The ideal candidate will have solid expertise in SQL, API testing, Python-based automation, and data validation methodologies, with a proven ability to ensure data accuracy, integrity, and reliability across complex enterprise environments.

The successful candidate will be a proactive quality champion who can identify risks early, perform root cause analysis, establish testing best practices, and leverage emerging technologies—including AI-assisted testing capabilities—to improve efficiency and test coverage at scale. Familiarity with Master Data Management (MDM) concepts and modern test automation tools such as Playwright is highly desirable.

Key Responsibilities

Data Testing & Validation

Validate end-to-end data ingestion, transformation, and data warehouse processing across batch and streaming workloads
Design and execute functional test cases such as accuracy, completeness, consistency, and reconciliation for ETL/ELT data flows
Perform testing across various data architectures, including Data Warehouses, Data Lakes, and Medallion Architectures

QA Strategy & Test Planning

Develop comprehensive QA strategies aligned with project objectives and release timelines
Identify and define appropriate testing approaches, including functional, integration, regression, system, performance, API, and user acceptance testing
Create detailed test plans, test scenarios, test cases, and traceability matrices
Establish quality gates and testing standards across Data & Analytics initiatives

Automation Testing

Design, develop,



and maintain automated test frameworks for data validation and application testing
Build reusable automation solutions to reduce manual testing efforts and improve coverage
Support regression testing and continuous quality validation across environments

API Testing

Perform functional and integration testing of REST APIs using Postman and similar tools
Validate API request/response structures, data integrity, error handling, authentication, and performance
Automate API test execution and reporting where applicable

Performance & Load Testing

Design and execute performance, load, and stress testing activities for data pipelines and applications
Analyze system behavior under varying workloads and identify bottlenecks
Validate scalability, stability, and responsiveness of solutions under production-like loads

Data Analysis & SQL Validation

Develop complex SQL queries to validate source-to-target data movement and transformations
Perform root cause analysis for data quality and testing issues
Analyze large data sets to identify anomalies, inconsistencies, and performance concerns
Support troubleshooting and defect resolution activities

Documentation & Quality Governance

Maintain comprehensive testing documentation, test plans, execution reports, and defect logs
Establish and promote QA best practices, testing standards, and governance processes
Collaborate with cross-functional teams to drive continuous improvement in quality processes

Skill Requirements




8+ years of experience in Quality Assurance in Data & Analytics initiatives
Strong expertise in SQL and Python for test automation, data validation, and quality engineering use cases
Hands-on experience in API Testing using Postman or similar tools, including REST API validation, automation, authentication, and integration testing
Experience designing and executing functional, integration, regression, system, UAT, and end-to-end testing
Hands-on experience building and maintaining test automation frameworks for data and application testing
Experience with performance, load, and stress testing methodologies and tools
Exposure to AI-driven testing frameworks, generative AI, AI-assisted test automation, or intelligent quality engineering solutions
Familiarity with Master Data Management concepts, data stewardship, and data governance practices
Experience testing modern cloud data platforms such as Snowflake, Microsoft Fabric, Azure Data Factory, Synapse, Databricks, or similar
Understanding of dimensional modeling, CDC, incremental processing, and enterprise data integration patterns
Familiarity with CI/CD tools and version control platforms such as Azure DevOps, GitHub, or similar
Strong analytical and problem-solving skills with the ability to investigate complex data and application issues
Excellent communication, collaboration, and stakeholder management skills
Good to Have
Experience with Playwright for web application test automation

Working knowledge of Java for automation framework development and test scripting

Other Requirements
Corporate office environment – fast-paced
Operate with minimal supervision
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

📌 Senior Automation Test Lead - ETL, DW Automation (India)
🏢 HCLTech
📍 India

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 automation test lead - etl, dw automation (india) / india