Job highlights

- Required Qualifications and Experience

- Job Summary . We are seeking an Oracle Technical Consultant with 7-15 years of experience and strong backend and integration skills to join our AI Solutions practice

- Experience with BIP / BI Publisher report development (data models,templates,bursting).

Job Summary

We are seeking an Oracle Technical Consultant with 7-15 years of experience and solid backend and integration skills to join our AI Solutions practice. You will be the technical backbone of our Oracle AI Agent Studio implementations - building the ORDS endpoints, PL/SQL logic, and BIP reports that power intelligent agents. This is a hands-on role where your technical work directly enables AI-driven automation at scale.

Key Responsibilities

- Design and develop ORDS REST endpoints on Oracle ATP/DB to serve as tool backends for AI agents.

- Write and optimise PL/SQL procedures, functions, and packages that encapsulate Fusion business logic.

- Build and maintain BIP/BI Publisher reports for data extraction and agent consumption.

- Integrate with Oracle Fusion REST APIs for procurement, finance, and HR transaction processing.

- Collaborate with functional consultants to translate data specs into efficient backend implementations.

- Support Oracle AI Agent Studio tool definition - parameter schemas, response handling, and error flows.

- Manage Oracle ATP schema design, grants, and performance tuning for agent workloads.





- Troubleshoot integration failures across ORDS, OIC, and Fusion REST layers.

Required Qualifications and Experience

- 7-15 years of Oracle technical development experience.

- Strong PL/SQL - procedures, packages, dynamic SQL, and exception handling.

- Hands-on experience with Oracle REST Data Services (ORDS) - module/handler design and parameter binding.

- Experience with BIP/BI Publisher report development (data models, templates, bursting).

- Working knowledge of Oracle Fusion REST APIs - authentication, request/response patterns, and error handling.

- Familiarity with Oracle ATP or Oracle DB Cloud - schema management, user grants, and REST enablement.

- Ability to read and interpret Fusion functional requirements and convert them into technical specifications.

Additional Qualifications

- Experience with Oracle Integration Cloud (OIC) - REST/SOAP adapters and scheduled orchestrations.

- Exposure to Oracle AI Agent Studio tool configuration or agent integration.

- Understanding of Oracle BPM workflow and approval routing.

- Knowledge of JSON schema design for REST API contracts.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Oracle Technical Consultant - AI Agent Studio (Kochi)
🏢 Gapblue Software Labs
📍 Kochi