Senior Oracle PL/SQL & ETL Applications Developer

REGTECH INSIGHT PTE. LTD.; Singapore; On-site; SGD 60,000 - 98,000; Full time

Job summary

REGTECH INSIGHT PTE. LTD. in Singapore seeks an experienced Applications Programmer to develop, test and maintain enterprise applications and database solutions, with Oracle SQL/PL/SQL, ETL data integration and batch processing for financial services.

Responsibilities include designing and optimizing database objects, building ETL mappings, scripting Unix batch jobs, and supporting risk management and regulatory reporting, working with cross-functional teams on upgrades and production fixes.

Qualifications

• Strong experience in Oracle SQL and PL/SQL development.
• Hands-on ETL data integration and batch processing
• Experience with testing, troubleshooting and production support.

Responsibilities

• Develop, maintain and optimise Oracle SQL/PL/SQL procedures and database objects.
• Design and maintain ETL mappings and data integration workflows.
• Develop Unix shell scripts and batch scheduling processes for data processing.
• Prepare design documents, test cases and workflow diagrams; perform unit/integration testing.
• Support risk management, regulatory reporting and data warehouse applications.
• Collaborate with cross-functional teams to implement system upgrades and production fixes.

Skills

Oracle SQL

PL/SQL

ETL pipelines

Unix shell scripting

Python

Databricks/PySpark

Tools

Informatica

SQL Server

Databricks

Job description

REGTECH INSIGHT PTE. LTD. in Singapore seeks an experienced Applications Programmer to develop, test and maintain enterprise applications and database solutions, with Oracle SQL/PL/SQL, ETL data integration and batch processing for financial services.

Responsibilities include designing and optimizing database objects, building ETL mappings, scripting Unix batch jobs, and supporting risk management and regulatory reporting, working with cross-functional teams on upgrades and production fixes.