Oracle Data Integrator Systems Analyst

JONDAVIDSON PTE. LTD.; Singapore; On-site; SGD 70,000 - 90,000; Full time

Job summary

A leading technology firm in Singapore is seeking an experienced professional to install and maintain Informatica PowerCenter software. You will translate requirements, develop job schedules, ensure data integrity during testing, and support production activities. Proficiency in Informatica PowerCenter, Unix Shell Scripting, and Oracle PL/SQL is required.

Qualifications

• Proficiency in Informatica PowerCenter 10.x or higher, preferably in a Unix (Linux/AIX) environment.
• Experience in Oracle 19c or higher (SQL*Plus, PL/SQL).
• Experience in analyzing and producing technical mapping design specifications.

Responsibilities

• Install, configure and maintain Informatica PowerCenter software.
• Translate requirements including source to target mapping.
• Develop job schedules to integrate upstream and downstream systems.

Skills

Informatica PowerCenter

Unix Shell Scripting

Oracle PL/SQL

Job description

> Install, configure and maintaining Informatica PowerCenter software
> translate requirements high and low leve including source to target mapping
> develop job schedules to integrate the upstream and downstream systems
> Ensure data accuracy/integrity during testing
> Accountable for on-time delivery of all documentation, design, build, testing, and deployment according to the work breakdown structures
> Support production activities, including production migrations, continuity testing, environment migration activities

Requirements:

a. Proficiency in Informatica PowerCenter 10.x or higher preferably in a Unix (Linux/AIX) environment with AS400/Oracle sources and targets.
b. Must have experience in Oracle 19c or higher (SQL*Plus, PL/SQL)/Experience in Unix Shell Scripting (Linux/AIX)

c. Experience in analyzing and producing technical mapping design specifications.