Role Summary:

We are seeking a highly skilled and detail-oriented ETL Senior Tester to join our growing data team. The successful candidate will be responsible for validating the accuracy, completeness, and integrity of data as it flows through our enterprise-grade Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes and data pipelines. This role is crucial for ensuring the reliability of our data for analytics, reporting, and critical business operations.
The ETL Tester will play a key role in designing and executing comprehensive test plans, scenarios, and cases for complex data transformations, data migrations, and data warehousing solutions. They will collaborate closely with data engineers, developers, business analysts, and other stakeholders to ensure that our data solutions meet business requirements

Essential Responsibilities

· Test Strategy & Planning: Analyze business, functional, and technical requirements to identify testable scenarios and clarify ambiguities in user stories and specifications. Design comprehensive test plans, test scenarios,



and test cases for ETL workflows, data platforms, and reporting solutions.
· ETL Testing Execution: Execute manual and automated testing for ETL processes, data transformations, data validation, and data pipelines.
· Data Validation & Integrity: Perform thorough data validation, data comparison, and backend testing to ensure the accuracy of data transformations and mappings. Validate data mapping, transformations, aggregations, and business rules across source systems, staging layers, data warehouses, and reporting layers. Conduct data integrity checks, reconciliations, and consistency validations using advanced SQL and other data validation techniques.
· SQL Proficiency: Write and execute complex SQL queries for data validation, reconciliation, integrity checks, and to verify data transformations and business rules.
· Defect Management: Identify, log, track, and manage defects using tools

📌 Software Tester (Chennai)
🏢 enGen Global
📍 Chennai