Experience: 10+ Years
Role: Informatica BA/Developer
Responsibilities:
· 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 9.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.
· Proficiency in Informatica Power Center 9.x or higher preferably in an Unix(AIX/SUN) environment with AS400/Oracle source and targets.
· Experience working on Informatica Metadata Manager 9.x or higher
· Must have experience in Oracle 11g or higher (SQL*Plus, PL/SQL)/Experience in Unix Shell Scripting (AIX/SUN/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