Oracle Financial Consultant

PT Loren Tech Solutions; Jakarta Pusat; On-site; IDR 300,000,000 - 600,000,000; Full time

Job summary

PT Loren Tech Solutions seeks an Oracle Technical Consultant (EBS) to design, customize, and maintain Oracle E-Business Suite modules focused on Finance. Based in Jakarta, you will work on integration and data processing to support business processes across consumer healthcare and pharmaceutical manufacturing sectors.

The role requires strong PL/SQL, EBS technical skills, and experience with APIs/Web Services.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or related field.
• Minimum 2 years of experience as an Oracle E-Business Suites (EBS) Technical.
• Strong PL/SQL skills with query optimization and performance tuning.
• Experience in Oracle EBS integrations via APIs/Web Services (XML/JSON); ORDS is a plus.
• Experience in developing reports using Oracle Reports Builder and handling Oracle Personalization.
• Willing to be placed in Pulomas, East Jakarta.

Responsibilities

• Perform development, customization, and maintenance of the Oracle E-Business Suite (EBS) system based on business requirements.
• Design, develop, and optimize PL/SQL objects (packages, procedures, functions, triggers, and queries) including performance tuning.
• Develop and maintain reports, as well as handle data processing (ETL) to support business and reporting needs.
• Integrate Oracle EBS with external systems through APIs/Web Services, including XML/JSON data processing.
• Conduct technical analysis, debugging, troubleshooting, and issue resolution within the Oracle EBS system.
• Develop and maintain Oracle Personalization and system enhancements based on user/business needs.
• Support deployment, migration, and maintenance activities across environments (development, testing, production).
• Collaborate with functional teams to translate requirements into technical solutions and ensure proper documentation.
• Provide ongoing support for incidents, enhancements, and change requests related to Oracle EBS.

Skills

PL/SQL

Oracle EBS

API/Web Services

ORDS (Oracle REST Data Services)

Education

Bachelor's degree in Computer Science / IT

Job description

Oracle Technical Consultant (EBS) - Module Finance

Placement: Consumer Healthcare / Pharmaceutical Manufacturing

Duration: 12 years (PKWT) - Extend base on Performance & Project

Job Description:

• Perform development, customization, and maintenance of the Oracle E-Business Suite (EBS) system based on business requirements.
• Design, develop, and optimize PL/SQL objects (packages, procedures, functions, triggers, and queries) including performance tuning.
• Develop and maintain reports, as well as handle data processing (ETL) to support business and reporting needs.
• Integrate Oracle EBS with external systems through APIs/Web Services, including XML/JSON data processing.
• Conduct technical analysis, debugging, troubleshooting, and issue resolution within the Oracle EBS system.
• Develop and maintain Oracle Personalization and system enhancements based on user/business needs.
• Support deployment, migration, and maintenance activities across environments (development, testing, production).
• Collaborate with functional teams to translate requirements into technical solutions and ensure proper documentation.
• Provide ongoing support for incidents, enhancements, and change requests related to Oracle EBS.

Requirement :

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or related field.
• Minimum 2 years of experience as an Oracle E-Business Suites (EBS) Technical.
• Strong PL/SQL skills (packages, procedures, functions) with query optimization and performance tuning.
• Experience in Oracle EBS integrations via APIs/Web Services (XML/JSON); Oracle REST Data SERVICES (ORDS) is a plus.
• Experience in developing reports using Oracle Reports Builder and handling Oracle Personalization.
• Strong troubleshooting, debugging, and issue analysis skills in Oracle EBS.
• Ability to collaborate with functional teams to translate business requirements into technical solutions.
• Willing to be placed in Pulomas, East Jakarta