ETL & Data Warehouse Engineer - Banking Data Solutions

RISKDATA CONSULTING PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

RISKDATA CONSULTING PTE. LTD. seeks an experienced Software Engineer with strong ETL, data integration and data warehousing skills to support banking applications.

You will design, develop, test, deploy and support enterprise data-processing solutions using IBM DataStage, Informatica, Oracle SQL, UNIX and CI/CD tools, including Moody's RCO, RAY and RFO applications. Join a team focused on reliable data-processing, regulatory support and collaboration with testing, BI and business teams to

Qualifications

• Bachelor's degree in CS/IT or related field.
• Strong ETL and data integration experience.
• Hands-on IBM DataStage and/or Informatica experience.
• Strong SQL and Oracle PL/SQL knowledge.
• 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.
• Knowledge of Moody's RCO, RAY or RFO is an advantage.
• Strong analytical, troubleshooting and problem-solving skills.

Responsibilities

• Design, develop and maintain data integration and processing solutions.
• 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

Banking Domain

UNIX/Shell Scripting

CI/CD

Education

Bachelor's degree in CS/IT or related field

Tools

IBM DataStage

Informatica

Oracle PL/SQL

SQL

UNIX/Linux

Control-M

Jenkins

Git

Bitbucket

Job description

RISKDATA CONSULTING PTE. LTD. seeks an experienced Software Engineer with strong ETL, data integration and data warehousing skills to support banking applications.

You will design, develop, test, deploy and support enterprise data-processing solutions using IBM DataStage, Informatica, Oracle SQL, UNIX and CI/CD tools, including Moody's RCO, RAY and RFO applications. Join a team focused on reliable data-processing, regulatory support and collaboration with testing, BI and business teams to