Jobless Developer
SmartDocs. Great logo

Posted 1 month ago

Oracle EBS Technical / Integration ConsultantSmartDocs. Great · Hyderabad

Oracle EBS Technical / Integration Consultant

HyderabadOn-sitePart-time

AI Summary

Designs and builds integrations between the SmartDocs portal and Oracle EBS Financials, covering master-data syncs to the portal and AP invoice transactions back into EBS using OIC or ISG. Also writes SQL/PL/SQL against EBS tables and handles the technical environment.

About this role

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

Skills

Concurrent ProgramsIntegrated SOA GatewayJSONLinuxOIC Connectivity AgentOIC EBS AdapterOpen Interface TablesOracle Cloud InfrastructureOracle EBS R12.2Oracle Integration CloudOracle PayablesPL/SQLREST APISOAPSQLXML

Explore related jobs

Browse these categories

Market data for this role

All reports →