Description

You will design, build, and optimize Informatica PowerCenter mappings to support technical delivery and data architecture implementation.

This role is on-site.

Responsibilities

• Develop Informatica mappings, debugging queries on sources and targets, and resolve production issues.
• Translate user requirements into architecture frameworks and implement new systems.
• Write complex SQL procedures and packages using Oracle PL/SQL.
• Ensure complete technical documentation exists for all projects and processes.
• Support automated building, testing (SIT & UAT), and deployment at scale.

Required Skills

• 2-4 years ETL experience with SAS.
• Strong SQL skills and experience with Relational Database Management Systems (Oracle, DB2, SQL Server).
• Experience designing and implementing Informatica 10.1 PowerCenter mappings.
• Knowledge of Informatica Advanced Techniques: Dynamic Caching, Memory Management, and Parallel Processing.
• Ability to script macros in MS Excel.
• Experience working in Agile teams with Jira and Bitbucket.

Preferred Skills

• Scala development skills.
• Knowledge of Informatica server and application administration.
• Understanding of parameter file concepts for solution design.

Key Skills

Education

Bachelor's degree