Enterprise PL/SQL & ETL Applications Developer

UNISONEDGE CONSULTING PTE. LTD.

Singapore

On-site

SGD 60,000 - 95,000

Full time

3 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

UNISONEDGE CONSULTING PTE. LTD. in Singapore is seeking an experienced Applications Programmer to develop, enhance, test and maintain enterprise applications and database solutions with a focus on Oracle SQL/PLSQL, ETL data integration, and batch processing in banking environments.

The role involves data migration, production support and collaboration with cross-functional teams to implement system upgrades, releases, and fixes using Python, PySpark, Databricks and Apache Spark.

Qualifications

Bachelor's or Master's degree in Computer Science, IT, or related discipline.
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 testing, troubleshooting, and production support.
Knowledge of banking, financial services, risk management or regulatory reporting preferred.
Familiarity with Python, PySpark, Databricks, Apache Spark, SQL Server and reporting tools is a plus.

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.