Data Integration Engineer - ETL & Data Warehouse

Unison Consulting Pte. Ltd.; Singapore; On-site; SGD 90,000 - 135,000; Full time

Job summary

Unison Consulting Pte. Ltd. in Singapore is seeking an experienced Software Engineer with strong ETL, data integration and data warehousing skills to design, develop, test, deploy and support enterprise data-processing and banking applications.

The candidate will work with IBM DataStage, Informatica, Oracle PL/SQL, UNIX/Shell scripting, Control-M and CI/CD tools to deliver reliable data-processing solutions and support Moody’s RCO, RAY and RFO regulatory processes.

Qualifications

• Degree in Computer Science or related field.
• Hands-on experience with ETL and data integration.
• Experience with IBM DataStage and/or Informatica.
• Strong SQL knowledge (Oracle PL/SQL).
• Experience with UNIX/Linux and Shell scripting.
• Experience with enterprise job scheduling tools like Control-M.
• Experience with Jenkins, Git and CI/CD.
• Banking domain experience is preferred.
• Experience with Moody’s RCO, RAY or RFO is an advantage.
• Knowledge of LCR, ALM or IRRBB is an advantage.

Responsibilities

• Design, develop and maintain software solutions for data integration and processing.
• Develop ETL workflows using IBM DataStage and Informatica.
• Develop SQL and PL/SQL programs for data processing and database integration.
• Develop UNIX/Shell scripts for automation and data processing.
• Configure and automate job scheduling using Control-M.
• Perform software testing, troubleshooting, debugging and performance tuning.
• Prepare technical design documents and unit test cases.
• Deploy software and ETL components across development, testing and production environments.
• Review code and ensure compliance with development standards.
• Support banking applications and investigate data/processing issues.
• Provide technical support for Moody’s RCO, RAY and RFO applications.
• Support data-processing requirements related to banking risk and regulatory processes.
• Collaborate with testing, BI and business teams to resolve issues.
• Support CI/CD activities using Jenkins, Git and Bitbucket.
• Analyze large datasets and support data-driven business and reporting requirements.

Skills

ETL development

Data integration

Data warehousing

Banking apps

Software engineering

Problem solving

Education

Bachelor's degree in CS/IT/Engineering

Tools

IBM DataStage

Informatica

Oracle PL/SQL

UNIX/Linux

Shell scripting

Control-M

Jenkins

Git

CI/CD

Job description

Unison Consulting Pte. Ltd. in Singapore is seeking an experienced Software Engineer with strong ETL, data integration and data warehousing skills to design, develop, test, deploy and support enterprise data-processing and banking applications.

The candidate will work with IBM DataStage, Informatica, Oracle PL/SQL, UNIX/Shell scripting, Control-M and CI/CD tools to deliver reliable data-processing solutions and support Moody’s RCO, RAY and RFO regulatory processes.