Automation Test Lead - Cloud ETL, DW Automation
India
Apply now
Job Description
Automation Test Lead - Cloud ETL, DW Automation
Chennai, Tamil Nadu

Job Summary

  • Strong understanding of ETL concepts: Extract, Transform, Load and data flow from source → staging → target systems 
  • Knowledge of full load, incremental load, and historical load validation 
  • Ability to validate data inflow and outflow across upstream and downstream systems
  • Strong SQL skills to Write complex queries (joins, subqueries, aggregates) and Compare source vs target datasets
  • Hands-on experience with databases PostgreSQL , Oracle , Data warehouse tables
  • Experience validating flat files: CSV ,XML,Control files,Checksum / record count validations
  • Ability to Analyze requirements and mapping documents
  • Prepare ETL test cases based on acceptance criteria
  • ETL automation exposure

Key Responsibilities

  • Strong understanding of ETL concepts: Extract, Transform, Load and data flow from source → staging → target systems 
  • Knowledge of full load, incremental load, and historical load validation 
  • Ability to validate data inflow and outflow across upstream and downstream systems
  • Strong SQL skills to Write complex queries (joins, subqueries, aggregates) and Compare source vs target datasets
  • Hands-on experience with databases PostgreSQL , Oracle , Data warehouse tables
  • Experience validating flat files: CSV ,XML,Control files,Checksum / record count validations
  • Ability to Analyze requirements and mapping documents
  • Prepare ETL test cases based on acceptance criteria
  • ETL automation exposure

Skill Requirements

  • Strong understanding of ETL concepts: Extract, Transform, Load and data flow from source → staging → target systems 
  • Knowledge of full load, incremental load, and historical load validation 
  • Ability to validate data inflow and outflow across upstream and downstream systems
  • Strong SQL skills to Write complex queries (joins, subqueries, aggregates) and Compare source vs target datasets
  • Hands-on experience with databases PostgreSQL , Oracle , Data warehouse tables
  • Experience validating flat files: CSV ,XML,Control files,Checksum / record count validations
  • Ability to Analyze requirements and mapping documents
  • Prepare ETL test cases based on acceptance criteria
  • ETL automation exposure

Other Requirements

1.Relevant certifications in Cloud Testing or ETL/DW Automation are a plus.
Apply now
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 223,000 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 June 2026 totaled $14.8 billion.