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
Solid 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.
#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-

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