Senior Oracle PL / SQL and OIC Consultant

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 :