Description

Key Skills: ETL, Abinitio, SQL, Shell Scripting, Oracle DB, Teradata Dba

Roles and Responsibilities:

• Establish and implement a consistent ETL testing methodology across data integration platforms.
• Design, develop, and execute comprehensive ETL test cases using Ab Initio components.
• Validate source-to-target data mapping and transformation logic; prepare complex test data to support defined scenarios.
• Develop and maintain regression test beds, schedule test cycles, and ensure regression scripts are automation-ready.
• Perform manual and automated ETL testing, including UAT and end-to-end testing; track, analyze, and communicate defects and results.

Skills Required:

• 8.5 - 11 years of experience in Ab Initio ETL testing, preferably in healthcare or PBM domain.
• ETL testing with strong hands-on experience validating end-to-end data pipelines.
• Ab Initio testing experience, including building and executing test cases for Ab Initio workflows.
• SQL for data validation and query optimization during testing.
• Unix shell scripting and database validation experience to support test execution and troubleshooting.

Good to Have:

• Oracle DB experience for data validation and troubleshooting.
• Shell scripting experience for test data preparation and automation support.
• Teradata DBA experience for working with Teradata environments during testing.

Education: B.Tech, BCA, M.B.A., M. Tech, M.Sc., or MCA (or equivalent technical/business experience)

Key Skills

Education

Any Graduate