Oracle Technical Consultant (Kochi)

About the Role

We are seeking an Oracle Technical Consultant with robust 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 productive backend implementations
Support Oracle AI Agent Studio tool definition — parameter schemas, response handling, 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 Skills & Experience
7–15 years of Oracle technical development experience
Strong PL/SQL — procedures, packages, agile SQL, exception handling
Hands-on experience with Oracle REST Data Services (ORDS) — module/handler design, parameter binding
Experience with BIP/BI Publisher report development (data models, templates, bursting)
Working knowledge of Oracle Fusion REST APIs — authentication, request/response patterns, error handling
Familiarity with Oracle ATP or Oracle DB cloud — schema management, user grants, REST enablement
Ability to read and interpret Fusion functional requirements and convert to technical specifications

Nice to Have
Experience with Oracle Integration Cloud (OIC) — REST/SOAP adapters, scheduled orchestrations
Exposure to Oracle AI Agent Studio tool configuration or agent integration patterns
Understanding of Oracle BPM workflow and approval routing
Knowledge of JSON schema design for REST API contracts

📌 Oracle Technical Consultant Kochi
🏢 Gapblue Software Labs
📍 Kochi