ETL Tester - Data Quality - Data Quality

Key Responsibilities :

- Design, develop, and execute comprehensive test plans, test cases, and test scenarios for data warehouse and ETL applications.

- Perform Data Quality Testing to validate data accuracy, completeness, consistency, and integrity across source and target systems.

- Validate ETL processes by performing source-to-target mapping, transformation testing, reconciliation, and data migration testing.

- Develop and execute complex SQL queries for data verification, root-cause analysis, and test result validation.

- Perform Database Testing to validate schema changes, data loads, stored procedures, views, and database objects.

- Design and maintain automated test suites using QuerySurge to improve test coverage, efficiency, and regression testing capabilities.

- Validate data pipelines, transformations, and reporting layers within Snowflake environments.

- Test and verify ETL workflows developed using IBM DataStage, ensuring business rules and transformation logic are correctly implemented.

- Identify, document, track, and retest defects, collaborating closely with developers, data engineers, business analysts, and stakeholders.

- Participate in Agile ceremonies, including sprint planning, backlog refinement, daily stand-ups, and retrospectives.

- Prepare test execution reports, quality metrics, and status updates for project stakeholders.

- Drive test automation initiatives and continuously improve testing processes and standards.

Required Skills :

- Hands on experience in Data Quality Engineering, ETL Testing, and Database Testing.

- Strong hands-on experience with SQL, including complex joins, subqueries, aggregations, data comparison, and performance validation.

- Expertise in ETL Testing with strong understanding of data transformation, data migration, reconciliation, and source-to-target validation.

- Experience in Database Testing across relational database platforms.

- Hands-on experience with QuerySurge for automated data validation and ETL testing.

- Strong knowledge of Snowflake architecture, SQL development, data loading, and validation techniques.

- Experience testing ETL processes developed using IBM DataStage.

- Good understanding of Data Warehousing, dimensional modeling, facts, dimensions, and data marts.

- Experience with defect management and test management tools such as Jira, Azure DevOps, or equivalent.

- Strong analytical, problem-solving, and debugging skills.

- Excellent communication and stakeholder management skills.

Preferred :

- Prior experience in the Insurance domain or financial services testing.

(ref:hirist.tech)