Description

You will manage ETL solution design, development, and application support within an Informatica PowerCenter environment.

Responsibilities

• Design ETL solutions via source-to-target mapping and design documents following performance best practices.
• Develop Informatica PowerCenter mappings, sessions, workflows, mapplets, and worklets.
• Write and optimize SQL and PL/SQL scripts for database code development and data reconciliation.
• Provide L1/L2 support for Informatica job failures and manage code deployment from lower environments to production.
• Execute UAT/test activities and perform error handling to ensure data integrity.

Required Skills

• 6+ years of experience in Informatica PowerCenter development and production support.
• Strong expertise in ETL design and Informatica PowerCenter mapping.
• Proficiency in Oracle Database and SQL/PLSQL scripting.
• Experience with enterprise job scheduling and monitoring tools.
• Proven ability to optimize mapping and workflow performance to meet execution windows.
• Experience in requirement gathering and collaborating with architects on ETL designs.
• Ability to mentor junior support resources and communicate with senior stakeholders.
• Any Graduate degree.

Preferred Skills

• Experience using Control-M scheduler tool.

Key Skills

Education

Any Graduate