Key Requirements
• Minimum 6-8 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
• Should be independent, quick learner and team player
• Able to work independently with minimum guidance
• Have good communication skills (to work with various levels)
Key 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