Applications Programmer

RISKDATA CONSULTING PTE. LTD.; Singapore; Presencial; SGD 60 000 - 110 000; Tempo integral

Resumo da oferta

RISKDATA CONSULTING PTE. LTD. seeks an experienced Applications Programmer to develop, enhance and maintain enterprise applications and database solutions in a banking/financial services context.

You will work with Oracle SQL, PL/SQL and ETL workflows to integrate data and ensure reliable production support. Responsibilities include designing ETL mappings, scripting automated batch processes, building data migration pipelines and contributing to regulatory reporting and risk management

Qualificações

• Strong experience in Oracle SQL, PL/SQL, database development and application maintenance.
• Hands-on experience with ETL tools, data integration, Unix shell scripting and batch processing.
• Experience in application testing, troubleshooting, system enhancements and production support.
• Knowledge of banking, financial services, risk management or regulatory reporting systems is preferred.
• Familiarity with Python, PySpark, Databricks, Apache Spark, SQL Server and reporting tools will be an advantage.

Responsabilidades

• Develop, maintain and optimise Oracle SQL, PL/SQL procedures, functions, packages, triggers and database objects.
• Design, develop and maintain ETL mappings, data integration workflows and data migration processes.
• Perform application enhancements, debugging, troubleshooting and production support.
• Develop Unix shell scripts and batch scheduling processes to automate data processing.
• Prepare technical design documents, test cases and workflow diagrams, and conduct unit and integration testing.
• Support financial risk management, regulatory reporting and data warehouse applications.
• Work with cross-functional teams to implement system upgrades, releases and production fixes.
• Apply relevant technologies including Oracle Database, SQL Server, Informatica, Python, PySpark, Databricks and Apache Spark, as required by project needs.

Conhecimentos

Oracle SQL

PL/SQL

Database development

ETL tooling

Unix shell scripting

Batch processing

Python

PySpark

Databricks

Apache Spark

Informatica

SQL Server

Ferramentas

Informatica

Databricks

Apache Spark

SQL Server

Descrição da oferta de emprego

Job Description

We are seeking an experienced Applications Programmer to develop, enhance, test and maintain enterprise applications and database solutions. The role involves Oracle PL/SQL development, SQL programming, ETL data integration, batch processing and application support within banking and financial services environments.

Key Responsibilities

• Develop, maintain and optimise Oracle SQL, PL/SQL procedures, functions, packages, triggers and database objects.
• Design, develop and maintain ETL mappings, data integration workflows and data migration processes.
• Perform application enhancements, debugging, troubleshooting and production support.
• Develop Unix shell scripts and batch scheduling processes to automate data processing.
• Prepare technical design documents, test cases and workflow diagrams, and conduct unit and integration testing.
• Support financial risk management, regulatory reporting and data warehouse applications.
• Work with cross-functional teams to implement system upgrades, releases and production fixes.
• Apply relevant technologies including Oracle Database, SQL Server, Informatica, Python, PySpark, Databricks and Apache Spark, as required by project needs.

Requirements

• Strong experience in Oracle SQL, PL/SQL, database development and application maintenance.
• Hands-on experience with ETL tools, data integration, Unix shell scripting and batch processing.
• Experience in application testing, troubleshooting, system enhancements and production support.
• Knowledge of banking, financial services, risk management or regulatory reporting systems is preferred.
• Familiarity with Python, PySpark, Databricks, Apache Spark, SQL Server and reporting tools will be an advantage.