Oracle Technical Consultant – OIC & PL / SQL Developer

Job Title : Oracle Technical Consultant – OIC & PL / SQL Developer

Location : Work from Home

Experience : 5+ Years

Shift : US Rotational Shift

Employment Type : Full-Time

About the Role :

We are looking for a highly skilled Oracle Technical Consultant with strong hands-on experience in Oracle Integration Cloud (OIC) and PL / SQL development. The ideal candidate will have deep technical expertise in designing, developing, and optimizing Oracle Cloud integrations, along with strong programming skills in procedures, functions, packages , and REST API development.

This is a remote position , requiring flexibility to work in US rotational shifts and collaborate effectively with global teams and clients.

Key Responsibilities :

Design, develop, and implement integrations using Oracle Integration Cloud (OIC) for Oracle Fusion ERP and HCM applications.

Develop and optimize complex PL / SQL procedures, functions, packages , and triggers.

Work with REST and SOAP APIs for data exchange between Oracle Fusion Cloud and third-party systems.

Perform data extraction, transformation, and loading (ETL) activities using FBDI, HDL , and other Oracle integration tools.

Build integration error handling and fault management frameworks.

Collaborate with functional and technical teams to translate business requirements into technical solutions.

Participate in unit testing, SIT, and UAT phases to ensure successful integration delivery.

Troubleshoot and resolve performance or data-related issues in integrations and database procedures.

Maintain documentation, including technical design, mapping sheets, and test scripts.

Required Skills & Qualifications :

5+ years of technical experience in Oracle Fusion Cloud integrations and development.

Strong expertise in Oracle Integration Cloud (OIC) – integrations using REST, SOAP, File-based, and scheduled flows.

In-depth proficiency in Oracle PL / SQL , including complex procedures, functions, packages , and query optimization.

Hands-on experience with REST API design, development, and integration.

Exposure to Oracle ERP or HCM Cloud modules and data models.

Good knowledge of FBDI, BIP, HDL , and data conversion / migration processes.

Familiarity with error handling, logging frameworks, and OIC monitoring tools.

Strong analytical, problem-solving, and debugging skills.

Excellent communication and collaboration skills for working with distributed teams.