Description

Manage application support and maintenance for ETL solutions, designing and developing Informatica PowerCenter mappings, workflows, and optimizations.

This role is on-site.

Responsibilities

• Design ETL solutions using source-to-target mapping and design documents, adhering to performance best practices.
• Develop Informatica PowerCenter mappings, sessions, workflows, mapplets, and worklets.
• Write and optimize SQL and PL/SQL code for database developments.
• Provide L1/L2 support for Informatica job failures and manage production deployments.
• Liaise with architects and stakeholders to gather requirements and propose technical designs.

Required Skills

• 6+ years of experience in ETL Informatica PowerCenter development and production support.
• Strong expertise in Informatica PowerCenter mapping and workflow design.
• Proficiency with Oracle Database.
• Advanced SQL and PL/SQL scripting skills.
• Experience with enterprise job scheduler and monitoring tools.
• Proven ability to optimize mapping and workflow performance for execution windows.
• Experience with error handling, testing, and UAT support.

Preferred Skills

• Experience using Control-M scheduler tool.

Key Skills

Education

Any Graduate