[AIT] Informatica System Analyst (MAX 3752)

Location: Singapore
Job type: Contract
Contact email: careersrise@bcg.com
Job ref: MAX 3752
Published: about 1 month ago
Startdate: 26 January 2024 - 26 January 2024

​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