Job Title: Oracle Integration Cloud Consultant The ideal candidate brings strong 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 processing, dynamic SQL, and performance tuning). Hands-on experience developing data models and layouts in Oracle BI Publisher (BIP).

Oracle Domain Knowledge: Technical exposure to data structures, APIs, and business events across Oracle Fusion Cloud Applications (Projects, HCM, Financials, or SCM).

Education &

Experience: Bachelor's degree in computer science, Software Engineering, Information Systems, or a related field. 4–7 years of experience as an Oracle Integration Cloud (OIC) Consultant. Preferred / Positive-to-Have Skills Proficiency with API testing and debugging tools such as Postman, Soap UI, or c URL.

Experience with OIC global fault handling, centralized error logging, and webhooks. Familiarity with Oracle Cloud Infrastructure (OCI) services, API Gateway.

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