Software Engineer - ETL & Data Warehousing

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

Job summary

UARROW PTE. LTD. in Singapore seeks an experienced Software Engineer with strong ETL, data integration, and data warehousing skills to design, develop, test, deploy and support data-processing solutions for enterprise banking applications.

You will work with IBM DataStage, Informatica, Oracle PL/SQL and CI/CD tooling to deliver reliable data processing. Banking regulatory knowledge (LCR, ALM, IRRBB) and Moody's RCO/RAY/RFO familiarity are advantageous.

Qualifications

• Degree in Computer Science, Information Technology, Computer Engineering or related field.
• Strong experience in software development, ETL and data integration.
• Hands-on experience with IBM DataStage and/or Informatica.
• Strong knowledge of SQL and Oracle PL/SQL.
• Experience with UNIX/Linux and Shell Scripting.
• Experience with Control-M or enterprise job scheduling tools.
• 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 and coding standards.
• Support banking applications and investigate technical issues related to data and processing.
• 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 technical 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

UNIX/Linux

Shell scripting

CI/CD

SQL

Oracle PL/SQL

Banking domain knowledge

Moody's RCO/RAY/RFO

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

IBM DataStage

Informatica

Control-M

Jenkins

Git

UNIX/Shell

Job description

Job Summary

We are seeking an experienced Software Engineer with strong expertise in ETL development, data integration, data warehousing and banking applications . The role involves designing, developing, testing, deploying and supporting software solutions for enterprise data-processing and banking applications. The successful candidate will work with IBM DataStage, Informatica, Oracle PL/SQL, SQL, UNIX/Shell Scripting, Control-M and CI/CD tools to develop and maintain reliable data-processing solutions. Experience with Moody's RCO, RAY and RFO and banking regulatory processes such as LCR, ALM and IRRBB will support the delivery of banking technology solutions.

Key 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 and coding standards.
• Support banking applications and investigate technical issues related to data and processing.
• 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 technical issues.
• Support CI/CD activities using Jenkins, Git and Bitbucket .
• Analyze large datasets and support data-driven business and reporting requirements.

Requirements

• Degree in Computer Science, Information Technology, Computer Engineering or related field.
• Strong experience in software development, ETL and data integration.
• Hands-on experience with IBM DataStage and/or Informatica .
• Strong knowledge of SQL and Oracle PL/SQL .
• Experience with UNIX/Linux and Shell Scripting .
• Experience with Control-M or enterprise job scheduling tools.
• 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.
• Strong analytical, troubleshooting and problem-solving skills.