Job Title: Oracle Integration Cloud Consultant

The ideal candidate brings robust expertise in Oracle Integration Cloud (OIC), REST and SOAP APIs, Oracle SQL/PL-SQL, and Oracle BI Publisher (BIP).

Key Responsibilities:

API & Integration Development:
Design, build, test, and consume secure RESTful APIs and SOAP Web Services (JSON, XML, WSDL, OpenAPI/Swagger) for seamless data exchange between Oracle Fusion systems and third-party platforms.
Build and maintain scalable integrations using Oracle Integration Cloud (OIC) utilizing REST, SOAP, Oracle Fusion/ERP Cloud, HCM, and database adapters.
Implement authentication standards (OAuth 2.0, Basic Auth, API Keys, SSL certificates) and configure custom REST endpoints within Oracle Cloud.
Database & Business Logic Development:
Write, optimize, and maintain complex SQL queries, PL/SQL packages, stored procedures, triggers, and custom data-processing scripts.
Perform SQL query performance tuning, index optimization, and data modeling for high-volume transaction staging.

Reporting & Data Utilities:




Design and deliver custom Oracle BI Publisher (BIP) data models, layout templates (RTF/Excel/eText), and reports, as well as OTBI analytics.
Build automated data extraction pipelines using FBDI (File-Based Data Import), HDL (HCM Data Loader), HCM extract, and API-triggered background jobs.

Architecture, Testing & Support:
Create detailed technical design specifications (TD080/MD070), Postman collections, mapping sheets, and architecture diagrams.
Perform unit testing, API payload validation, exception handling, and post-production hypercare support.

Required Qualifications & Skills

Web Services & Integrations:
Deep understanding and practical experience working with REST and SOAP APIs (payload design, JSON/XML handling, HTTP methods, status codes, and security mechanisms).
Hands-on development experience with Oracle Integration Cloud (OIC).

Core Technical Development:
Advanced proficiency in Oracle SQL and PL/SQL (collections

📌 Oracle Integration Cloud Consultant (India)
🏢 TRUGlobal
📍 India