Automation Test Lead - Cloud ETL, DW Automation
HCL Tech
1 day ago
On-site
Test Lead
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.