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
