Oracle EBS Developer

AURUS CONSULTING PTE. LTD.; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

AURUS CONSULTING PTE. LTD. in Singapore is seeking a senior ETL/Data Integration Specialist to join our systems development initiatives.

You will design and implement INFORMATICA Power Centre mappings, write robust PL/SQL routines, and ensure quality ETL code adheres to SDLC standards while supporting SIT/UAT defects. You'll perform systems and data analysis, build shell scripts and stored procedures, and collaborate across Unix/Linux environments to maintain reliable data pipelines and

Qualifications

• Must have hands-on experience in ETL development and data integration.
• Strong knowledge of SDLC processes and change management.
• Experience with INFORMATICA Power Centre mappings and workflows.
• Ability to develop and test ETL components and troubleshoot defects.

Responsibilities

• Design and implement INFORMATICA Power Centre mappings and workflows.
• Build quality ETL code and perform unit testing.
• Troubleshoot SIT/UAT defects and support production deployment.
• Perform systems/data analysis to support data integration on heterogeneous platforms.

Skills

ETL development

Data analysis

SDLC adherence

Unit testing

Troubleshooting

Education

Bachelor's degree in computer science or related field

Tools

Oracle

SQL Server

Informatica PowerCentre

OBIEE

SAS Analytics

Unix/Linux

Shell scripting

Job description

As part of System Development Life Cycle (SDLC), Gathering requirements, Development, Testing, Implementation and post production support using below technologies,

Knowledge Required

• Must Have Database: Oracle, SQL Server
• Programming Language: Oracle PL/SQL
• Data Integration Tool: INFORMATICA Power Centre
• Reporting Tool: OBIEE
• Analytics Tool: SAS Analytics
• To build Quality ETL code, perform unit testing and trouble shoot any SIT, UAT defects.
• Ensure ETL code follows standards and adheres to SDLC process & Job scheduling.
• Perform systems/data analysis to implement INFORMATICA power centre mappings and workflows, shell scripts and stored procedures. -Follow change management process for testing & support production implementation.

Technical Skills & Experience:

1. More than 8 years and above related work experiences.
2. Bachelor's degree in computer science, engineering or similar domain
3. Familiarity with heterogeneous technology platforms such as Unix/Linux...