Description

You will validate end-to-end data warehousing systems and manage data quality across large datasets.

Responsibilities

• Execute Informatica workflows and perform root cause analysis on job failures.
• Develop testing artifacts including Test Plans, Test Strategies, RTM, Defect Reports, and Test Closure documents.
• Manage and troubleshoot Control-M scheduled jobs and workflows.
• Write and execute complex SQL and PL/SQL scripts to validate data modeling and reporting.
• Collaborate with Business users, UAT teams, and offshore developers to demonstrate test scenarios and delegate daily tasks.

Required Skills

• 5 to 10 years of experience in Data, ETL, and Data Warehouse testing.
• Advanced SQL skills with proven experience in complex PL/SQL coding.
• Strong expertise in SQL Server and managing SQL objects.
• Hands-on experience with Control-M or similar scheduling tools.
• Experience with Informatica Powercenter or other ETL tools.
• Background in data modeling and analyzing large datasets.
• Experience working within Agile project environments.
• Ability to manage scope, seek clarifications, and escalate technical delays.

Preferred Skills

• Experience with IDQ, Tableau, or Banking/Financial domains.

Key Skills

Education

Any Graduate