Oracle Developer (PL/SQL/ETL)

Hammerjack Pty Ltd; Philippines; On-site; PHP 720,000 - 1,200,000; Full time

Benefits offered by this job

Day 1 HMO with 2 Free Dependents

Communication Allowance

Rice Allowance

Clothing Allowance

Christmas/Holiday Gift

Group Personal Accident Insurance

Life Insurance

Optical/Medicine/Dental Allowance

Bereavement Assistance

Job summary

Hammerjack Pty Ltd in the Philippines is seeking a hands-on Oracle developer with 2+ years of experience in SQL development, scripting, ETL/integration concepts, and Oracle RICEW objects. The role includes working on Procure-to-Pay (P2P) processes and gaining expertise in the Ivalua platform.

Key responsibilities include building and optimizing SQL queries, designing integrations, supporting data flows, and participating in end-to-end project delivery from requirements gathering to go-live.

Qualifications

• 2+ years of experience in Oracle technical development, application development, or integration projects.
• Strong SQL skills with experience writing medium to complex queries.
• Experience with scripting technologies such as Shell Scripting, Python, Perl, Groovy, or similar.
• Understanding of integration concepts, APIs, ETL processes, and system-to-system data flows.
• Experience developing or supporting Oracle RICEW objects.
• Basic to intermediate knowledge of Procure-to-Pay (P2P) and Procurement business processes.
• Experience participating in implementation, migration, upgrade, or transformation projects.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.

Responsibilities

• Develop, maintain, and optimize medium to complex SQL queries, stored procedures, and database objects.
• Analyze, troubleshoot, and support application data issues across multiple systems.
• Design and support integrations between enterprise applications, databases, and third-party systems.
• Understand and document end-to-end data flows, mappings, and integration requirements.
• Develop and support ETL processes, data migration, and data conversion activities.
• Create and maintain Oracle RICEW objects (Reports, Interfaces, Conversions, Extensions, and Workflows).
• Participate in system implementation projects, including requirements gathering, design, development, testing, deployment, and post-go-live support.
• Collaborate with business users and functional teams to understand procurement and P2P business requirements.
• Provide technical support, root cause analysis, and issue resolution during project and production phases.
• Learn and support the Ivalua Procurement platform and related Source-to-Pay processes.

Skills

SQL development

Scripting

ETL concepts

Integration concepts

Oracle RICEW objects

P2P processes

Ivalua experience

Tools

Oracle

SQL

ETL tools

Job description

The ideal candidate will have hands-on experience with SQL development, scripting, ETL/integration concepts, and Oracle RICEW objects, along with a basic understanding of Procure-to-Pay (P2P) processes. This role offers an opportunity to learn and specialize in Ivalua, a leading Procurement and Source-to-Pay platform.

Key Responsibilities

• Develop, maintain, and optimize medium to complex SQL queries, stored procedures, and database objects.
• Analyze, troubleshoot, and support application data issues across multiple systems.
• Design and support integrations between enterprise applications, databases, and third-party systems.
• Understand and document end-to-end data flows, mappings, and integration requirements.
• Develop and support ETL processes, data migration, and data conversion activities.
• Create and maintain Oracle RICEW objects (Reports, Interfaces, Conversions, Extensions, and Workflows).
• Participate in system implementation projects, including requirements gathering, design, development, testing, deployment, and post-go-live support.
• Collaborate with business users and functional teams to understand procurement and P2P business requirements.
• Provide technical support, root cause analysis, and issue resolution during project and production phases.
• Learn and support the Ivalua Procurement platform and related Source-to-Pay processes.

Required Qualifications

• 2+ years of experience in Oracle technical development, application development, or integration projects.
• Strong SQL skills with experience writing medium to complex queries.
• Experience with scripting technologies such as Shell Scripting, Python, Perl, Groovy, or similar.
• Understanding of integration concepts, APIs, ETL processes, and system-to-system data flows.
• Experience developing or supporting Oracle RICEW objects.
• Basic to intermediate knowledge of Procure-to-Pay (P2P) and Procurement business processes.
• Experience participating in implementation, migration, upgrade, or transformation projects.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.

Company Benefits:

• Day 1 HMO with 2 Free Dependents
• Communication Allowance
• Rice Allowance
• Clothing Allowance
• Christmas/Holiday Gift
• Group Personal Accident Insurance
• Life Insurance
• Optical/Medicine/Dental Allowance
• Bereavement Assistance