Senior Oracle EBS & OIC Integration Engineer

Consulting Solutions; Maryland; On-site; USD 140,000 - 190,000; Full time

Job summary

Consulting Solutions seeks a Senior Oracle Integration Specialist to design, build, and support OIC integrations for an Oracle E-Business Suite R12 environment hosted in OCI. The role focuses on reliable, secure data flows between EBS and external systems, aligning with enterprise standards and readiness activities.

You will design orchestrations, adapters, and file-based flows; implement REST/SOAP services; and develop mappings and PL/SQL components while ensuring security, compliance, and

Qualifications

• 7–10+ years with Oracle EBS technical or integration development, including strong expertise in EBS R12.
• 3–5+ years hands-on with Oracle Integration Cloud (OIC), including orchestrations.
• 3–5+ years hands-on with Oracle SQL, PL/SQL ETL data-load patterns.
• REST/SOAP integrations, event-driven flows, file transfers, and scheduling.
• Strong experience with EBS interface tables, open APIs, concurrent programs, and data-load patterns.
• Expertise with FBDI/ADFdi, transformation mappings (XSLT/JSON/XML), and integration best practices.
• Proficiency with OCI services relevant to integrations (Object Storage, Networking, Keys/Certs).
• Strong PL/SQL, performance tuning skills, and ability to debug complex data flows.
• Experience participating in cross-functional design reviews and ERP modernization.
• Background in data warehouse tools (e.g., OBIEE, Snowflake) and ETL tools (e.g., ODI, Informatica).
• Experience in OCI DevOps pipelines, Git-based CI/CD for OIC, or API Gateway.

Responsibilities

• OIC design, development, and support for ERP modernization and UNIFI operations.
• Design, build, and maintain OIC integrations (orchestrations, file-based flows) for ERP.
• Implement REST/SOAP services, OIC connectors, EBS adapters, FTP/SFTP, OCI Object Storage.
• Build FBDI-based and API-based integrations for Financials, Procurement, AR/AP, etc.
• Develop transformation mappings and apply error-handling, retry, and notification frameworks.
• Develop and troubleshoot PL/SQL, EBS interfaces/APIs, concurrent programs, and BI artifacts.
• Monitoring, logging, test cycles, cutovers, and production defect resolution with compliance.
• Collaborate with DBAs and Technical Developers to validate end-to-end readiness.

Skills

OIC orchestration

Oracle EBS R12

REST/SOAP

ETL patterns

FBDI/HDL

EBS APIs

PL/SQL

OCI Object Storage

CI/CD for OIC

Oracle integration design

Tools

ODI

Informatica

BI Publisher

OBIEE

Git CI/CD

Job description

Consulting Solutions seeks a Senior Oracle Integration Specialist to design, build, and support OIC integrations for an Oracle E-Business Suite R12 environment hosted in OCI. The role focuses on reliable, secure data flows between EBS and external systems, aligning with enterprise standards and readiness activities.

You will design orchestrations, adapters, and file-based flows; implement REST/SOAP services; and develop mappings and PL/SQL components while ensuring security, compliance, and