Description

Lead the migration of ETL workloads from Informatica PowerCenter to IDMC/IICS.

Responsibilities

• Execute end-to-end migrations from PowerCenter to IDMC/IICS environments.
• Develop mappings, reports, source/target definitions, workflows, and session transformations.
• Create and maintain Unix shell scripts and Oracle SQL code components.
• Schedule and monitor job workflows using Control M.
• Analyze failures, update defect management tools, and perform performance tuning.

Required Skills

• 14+ years of experience in ETL development.
• Deep expertise in Informatica PowerCenter and Informatica Cloud (IDMC/IICS).
• Proficiency in Oracle SQL and general database concepts.
• Strong Unix shell scripting skills.
• Hands-on experience with Data Warehousing and Control M scheduling.
• Practical understanding of Secure Agent architecture and local system connectivity.
• Experience with SDLC and Agile development methodologies.

Preferred Skills

• Proven ability in technical troubleshooting and analytical problem-solving.

Key Skills

Education

Any Gradute