Description

You will build and maintain data integration pipelines using Informatica PowerCenter. You own the end-to-end development of source-to-target mappings and dimensional models.

Responsibilities

• Develop and maintain complex data integration processes using Informatica PowerCenter.
• Build source-to-target mappings and implement Slowly Changing Dimension (SCD) logic for dimensional models.
• Write and manage Unix scripts to support data extraction and transformation requirements.
• Orchestrate data workflows and manage scheduling using Control-M.
• Analyze project scope and escalate technical blockers or delays to leads.

Required Skills

• 5+ years of hands-on experience with Informatica PowerCenter.
• Advanced Oracle SQL and complex PL/SQL coding skills.
• Practical experience writing and debugging Unix shell scripts.
• Strong understanding of data warehousing concepts and dimensional modeling.
• Experience with Control-M or equivalent enterprise scheduling tools.
• Any graduate degree.

Preferred Skills

• Experience with Informatica MDM.
• Exposure to IDMC (Informatica Cloud).

Key Skills

Education

Any graduate