Senior Project Lead
India
Job Description
Senior Project Lead
Bengaluru, Karnataka

Job Summary

Expected Joining / Allocation: Within June 2026

We are seeking a highly skilled Senior ETL / Big Data Test Engineer with strong expertise in data validation, ETL testing, and automation. The candidate will be responsible for end-to-end testing across complex data pipelines, ensuring data integrity, quality, and seamless integration across multiple systems.

The ideal candidate should have a mix of functional testing, automation, SQL expertise, and stakeholder management, with exposure to modern tools and technologies in the data and cloud ecosystem.

Key Responsibilities

🔹 ETL & Data Testing

 

Perform end-to-end ETL testing across data pipelines, ensuring data accuracy, completeness, and consistency

Validate data extraction, transformation, and loading processes for complex data workflows

Conduct data reconciliation and cross-system validation

 

🔹 Test Design & Execution

Analyse business requirements and convert them into test scenarios and test cases

Design risk-based, comprehensive test strategies aligned with acceptance criteria

Lead functional, integration, and regression testing cycles

Ensure optimal test coverage across releases

 

🔹 Automation & Tools

Develop and maintain ETL automation frameworks using Python, PySpark, and Pandas

Build reusable data validation scripts and utilities

Contribute to automation strategy to improve efficiency and reduce manual effort

 

🔹 SQL & Data Validation

Perform complex SQL queries for backend validation and data analysis

Validate:

 

Data transformations

Aggregations

Joins

Business rules

Conduct deep defect analysis for data-related issues

 

🔹 BI & Reporting Validation

Perform BI report testing to validate dashboards, reports, and KPIs 

Ensure data consistency between source systems and reporting layers

 

🔹 Integration & API Testing

Validate data flow across integrated systems

Perform API testing using tools like Postman (preferred)

 

🔹 Defect Management

Own complete defect lifecycle management:

Identification

Logging

Prioritization

Tracking

Closure

Collaborate with dev/integration teams to resolve issues

 

🔹 Test Tracking & Reporting

Track and report test progress, coverage, and quality metrics

Provide clear status updates including:

Risks

Dependencies

Blockers

 

🔹 Stakeholder Collaboration

Work closely with:

Developers

Business Analysts

Product Owners

Business users

Ensure alignment on quality goals and delivery timelines

Skill Requirements

🔹 ETL & Data Testing

 

Perform end-to-end ETL testing across data pipelines, ensuring data accuracy, completeness, and consistency

Validate data extraction, transformation, and loading processes for complex data workflows

Conduct data reconciliation and cross-system validation

 

🔹 Test Design & Execution

Analyse business requirements and convert them into test scenarios and test cases

Design risk-based, comprehensive test strategies aligned with acceptance criteria

Lead functional, integration, and regression testing cycles

Ensure optimal test coverage across releases

 

🔹 Automation & Tools

Develop and maintain ETL automation frameworks using Python, PySpark, and Pandas

Build reusable data validation scripts and utilities

Contribute to automation strategy to improve efficiency and reduce manual effort

 

🔹 SQL & Data Validation

Perform complex SQL queries for backend validation and data analysis

Validate:

 

Data transformations

Aggregations

Joins

Business rules

Conduct deep defect analysis for data-related issues

 

🔹 BI & Reporting Validation

Perform BI report testing to validate dashboards, reports, and KPIs 

Ensure data consistency between source systems and reporting layers

 

🔹 Integration & API Testing

Validate data flow across integrated systems

Perform API testing using tools like Postman (preferred)

 

🔹 Defect Management

Own complete defect lifecycle management:

Identification

Logging

Prioritization

Tracking

Closure

Collaborate with dev/integration teams to resolve issues

 

🔹 Test Tracking & Reporting

Track and report test progress, coverage, and quality metrics

Provide clear status updates including:

Risks

Dependencies

Blockers

 

🔹 Stakeholder Collaboration

Work closely with:

Developers

Business Analysts

Product Owners

Business users

Ensure alignment on quality goals and delivery timelines

Other Requirements

null
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.

23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.