Description

Validate data integrity and workflow execution within large-scale data warehousing systems.

You will own the release pipeline, execute Informatica workflows, and perform root cause analysis on job failures. You will debug and troubleshoot Control-M scheduled jobs to resolve execution errors. You will develop and maintain test artifacts including Test Plans, Test Strategies, RTM, Defect Reports, and Test Closure documents. You will collaborate with Business users and UAT teams to demonstrate test scenarios. You will manage and delegate daily tasks to offshore team members.

Responsibilities

• Execute Informatica workflows and perform root cause analysis on job failures.
• Debug and troubleshoot Control-M scheduled jobs to resolve execution errors.
• Develop and maintain test artifacts including Test Plans, Test Strategies, RTM, and Defect Reports.
• Collaborate with Business users and UAT teams to demonstrate test scenarios.
• Manage and delegate daily tasks to offshore team members.

Required Skills

• 5-10 years of experience in Data, ETL, and Data Warehouse testing.
• Advanced SQL skills with proven experience writing complex PL/SQL scripts.
• Hands-on experience with Control-M or similar scheduling tools.
• Deep understanding of SQL Server and managing SQL objects.
• Experience with Informatica or similar ETL tools.
• Strong knowledge of end-to-end data warehousing, from data modeling to reporting.
• Ability to analyze large datasets and perform data modeling.
• Experience working within Agile projects.

Preferred Skills

• Knowledge or experience with IDQ and Tableau.

Key Skills

Education

Any Graduate