Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mapping
Responsible for build 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
Job 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 Power Center 10.x or higher preferably in an Unix(AIX/LINUX) environment with AS400/Oracle source and targets.
Experience working on Informatica Metadata Manager 10.x or higher
Must have experience in Oracle 11g or higher (SQL.Plus, PL/SQL)/Experience in Unix Shell Scripting (AIX/Linux)
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