Oracle EBS Technical / Integration Consultant

SmartDocs, Inc.; Hyderabad; On-site; INR 1,653,000 - 2,342,000; Part time

Job summary

SmartDocs, Inc. is seeking an Oracle EBS Technical / Integration Consultant for contract work. You will design and implement master-data syncs and invoice integrations between Oracle EBS and our portal, using OIC or ISG.

Strong SQL/PLSQL and REST/JSON experience are essential, along with Linux and OCI familiarity. You will collaborate with a functional consultant and developers to map data, validate tests, and ensure reliable data exchange with EBS Financials (AP/PO/GL).

Qualifications

• 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.
• Strong SQL and PL/SQL, including incremental extracts and performance tuning.
• Open interface tables and concurrent programs.
• Comfortable with REST, XML/JSON, Postman, Linux.

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.

Skills

Oracle EBS

OIC

ISG

SQL

PL/SQL

REST/JSON

Linux

Tools

OIC Gen 2/Gen 3

Integrated SOA Gateway

Oracle Cloud (OCI)

SQL/PLSQL tooling

Job description

Oracle EBS Technical / Integration Consultant

5-14

Part-Time

INR 1200 - 1700

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
• 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)

Type: Contract (duration to be discussed)