Applications Programmer

UNISYNC SYSTEMS PTE. LTD.; Singapore; On-site; SGD 100,000 - 140,000; Full time

Job summary

UNISYNC SYSTEMS PTE. LTD. is seeking an experienced applications programmer to develop, enhance, test, and maintain enterprise applications and database solutions in banking and financial services projects. The role emphasizes Oracle SQL/PLSQL development, data integration, and production support.

You'll work with cross-functional teams, design ETL mappings, automate data processing with Unix scripts, and apply Python/PySpark/Databricks technologies as project needs.

Qualifications

• 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.

Responsibilities

• Develop, maintain, and optimize 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.

Skills

Oracle SQL

PL/SQL

ETL development

Unix shell scripting

Python

PySpark

Tools

Informatica

Databricks

Apache Spark

SQL Server

Job description

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 optimize 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.