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, Open API/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/e Text), 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, bulk

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