Job DescriptionJob Title: Oracle Integration Cloud Consultant
n

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

nKey Responsibilities:
n

nAPI & Integration Development:
nDesign, 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.
nBuild and maintain scalable integrations using Oracle Integration Cloud (OIC) utilizing REST, SOAP, Oracle Fusion/ERP Cloud, HCM, and database adapters.
nImplement authentication standards (OAuth 2.0, Basic Auth, API Keys, SSL certificates) and configure custom REST endpoints within Oracle Cloud.
nDatabase & Business Logic Development:
nWrite, optimize, and maintain complex SQL queries, PL/SQL packages, stored procedures, triggers, and custom data-processing scripts.
nPerform SQL query performance tuning, index optimization, and data modeling for high-volume transaction staging.
n





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

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

n Required Qualifications & Skills
n

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

n Core

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