Responsibilities
· Responsible for installing, configuring, testing and maintaining Informatica PowerCenter software
· Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mapping
· Responsible for building of data mappings, sessions and workflows to meet requirements (Informatica 10.x or higher)
· Responsible for development of job schedules that integrate the upstream and downstream systems (e.g. Control-M)
· Responsible for unit testing, debugging, and performance testing, with key focus on data accuracy and integrity
· Accountable for on-time delivery of all documentation, design, build, testing, and deployment according to the work breakdown structures
· Work with production support teams as required to support production activities, including production migrations, continuity testing, environment migration activities
· Must have impeccable written and oral communication skills down to the mapping documentation level
· Ensure that documentation is captured, maintained, understood by and available to business and/or IT partners
Escalate critical technical issues and potential problems as needed to the Project Manager to address any related issues in advance of deadlines
Requirements
· Should be independent, quick learner and team player
· Able to work independently with minimum guidance
· Have good communication skills (to work with various levels)
· Minimum 4 years or above with the relevant experience
· Proficiency in Informatica PowerCenter 10.x or higher preferably in a Unix (Linux/AIX) environment with AS400/Oracle sources and targets.
· Must have experience in Oracle 19c or higher (SQL*Plus, PL/SQL)/Experience in Unix Shell Scripting (Linux/AIX)
· Experience Job scheduling tools like Control-M
· Good to have experience in Change Control Management tools & Visio
· Have experience on all stages of Software Development Life Cycle (SDLC)
· Able to do requirement gathering, impact analysis, ETL mapping, build, unit testing, support SIT/UAT/Production
Able to organize and prioritize assignments in a fast-paced and deadline-oriented environment
Key Domain/ Technical Skills
· Proficiency in Informatica PowerCenter version 10.x or higher
· Experience in setting up, upgrading and troubleshooting Informatica PowerCenter infra
Experience in analyzing and producing technical mapping design specifications