ETL Data Automation Tester

Hexaware Technologies; Pune District, Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Hexaware Technologies is seeking ETL / Data Automation Engineers to develop and maintain automated test frameworks using Python and PyTest, and to perform end-to-end ETL testing across source, staging, and target systems.

The role involves creating and executing data validation scripts with SQL and Pandas, ensuring data quality by validating accuracy, completeness, and consistency, and designing test cases for data transformations and pipelines.

Responsibilities

• Develop and maintain automated test frameworks using Python and PyTest
• Perform end-to-end ETL testing across source, staging, and target systems
• Create and execute data validation scripts using SQL and Pandas
• Ensure data quality by validating accuracy, completeness, and consistency
• Design and execute test cases for data transformations and data pipelines
• Identify, analyze, and resolve data discrepancies and defects
• Collaborate with data engineers to understand ETL workflows and business logic
• Automate regression and validation test suites for data pipelines
• Contribute to improving QA processes, automation coverage, and overall testing efficiency

Job description

ETL / Data Automation Engineers Key Responsibilities:

• Develop and maintain automated test frameworks using Python and PyTest
• Perform end-to-end ETL testing across source, staging, and target systems
• Create and execute data validation scripts using SQL and Pandas
• Ensure data quality by validating accuracy, completeness, and consistency
• Design and execute test cases for data transformations and data pipelines
• Identify, analyze, and resolve data discrepancies and defects
• Collaborate with data engineers to understand ETL workflows and business logic
• Automate regression and validation test suites for data pipelines
• Contribute to improving QA processes, automation coverage, and overall testing efficiency