Work Location: Central
Contract Type: 12 months contract
No of resources needed: 4
Role: System Analyst
Job Level: Preferably 6 to 9 years of relevant experience (L3)
Key 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
Job Objectives
The main objective is to analyze, develop, enhance, debug, support, maintain, test informatica application.
The primary work comprises of requirement analysis, mapping design, technical specification, programming, code review, job scheduling, perform unit test and SIT, support UAT, deploy to production, post implementation support, and technical documentation.
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
Key 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