Oracle EBS Technical / Integration Consultant

Role: Oracle EBS Technical / Integration Consultant

Experience: 5+ years in Oracle E-Business Suite (R12.2) technical work, including hands-on Oracle Integration Cloud (OIC)

Type : Contract

About the role

We're integrating our SmartDocs portal with Oracle EBS Financials in both directions:

- Master data from EBS to the portal: suppliers and sites, GL accounts, payment terms, operating units, POs and receipts, and similar. - Transactions from the portal to EBS: AP invoices, with their status and results sent back.

Depending on the client, this runs through Oracle Integration Cloud (OIC) or EBS Integrated SOA Gateway (ISG), plus read-only database views. We already have an EBS functional consultant. This person owns the technical and integration side.

Responsibilities

- Design and build master-data syncs from EBS to the portal: full and incremental (changed-records-only) loads, read-only views, scheduled OIC integrations - Build invoice integrations into EBS (Payables open interface, import program, result read-back) using OIC or ISG - In OIC: EBS, database and REST adapters, connectivity agent, scheduling, error handling and monitoring - In ISG: deploy REST services, manage grants, troubleshoot through server logs - Write and tune SQL and PL/SQL across EBS Financials tables (AP, PO, GL, suppliers/TCA) - Work with the functional consultant and our developers on data mapping, validation and testing - Basic environment work: Linux/SSH, Oracle Cloud (OCI) networking

Must have

- Oracle EBS R12.2 technical experience in Financials (AP, PO, GL; suppliers) - Strong knowledge of the EBS data model for suppliers, POs, invoices and GL accounts - Oracle Integration Cloud (OIC Gen 2/Gen 3): EBS adapter, connectivity agent, DB/REST adapters, scheduled integrations, at least one delivered EBS integration - Integrated SOA Gateway (ISG): REST/SOAP service deployment - Strong SQL and PL/SQL, including incremental extracts and performance tuning - Open interface tables and concurrent programs - Comfortable with REST, XML/JSON, Postman, Linux

Good to have

- Boomi or other iPaaS tools - Oracle Workflow, AME, business events - BI Publisher, OAF/Forms - Java/Spring (JDBC) - OCI basics (VMs, security lists)

Engagement Details

Location: Hyderabad

Type: Contract (duration to be discussed)

Start: Immediate / ASAP