x
Get our mobile app
Fast & easy access to Jobstore
Use App
Congratulations!
You just received a job recommendation!
check it out now
Browse Jobs
Companies
Campus Hiring
Download App
Jobs in Singapore   »   Jobs in Singapore   »   Customer Service Job   »   Informatica Power Centre ETL - Systems Analyst
 banner picture 1  banner picture 2  banner picture 3

Informatica Power Centre ETL - Systems Analyst

D L Resources Pte Ltd

D L Resources Pte Ltd company logo
Job Description & Requirements
  • To analyze, develop, enhance, debug, support, maintain and test Informatica application.
  • 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

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 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

Sharing is Caring

Know others who would be interested in this job?