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)