Senior Oracle Integration Cloud Architect (EBS/OIC)

Accelyst, LLC; Maryland; On-site; USD 120,000 - 160,000; Full time

Job summary

Accelyst, LLC is seeking a Senior Oracle Integration Cloud (OIC) Middleware Specialist to design, build, and support ETL jobs and OIC integrations for an Oracle E-Business Suite R12 environment hosted in OCI. You will ensure secure, scalable data flows between EBS and external systems and adhere to enterprise integration standards.

The role requires deep expertise in OIC orchestration, REST/SOAP services, FBDI/HDL patterns, ERP adapters, and PL/SQL with hands-on knowledge of EBS interface tables

Qualifications

• 7-10+ years of Oracle EBS technical or integration development experience, including strong expertise in EBS R12.
• 3-5+ years of hands-on experience with Oracle Integration Cloud (OIC), including orchestrations.
• 3-5+ years of hands-on experience with Oracle SQL, PL/SQL, and ETL data-load patterns.
• Experience with 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 in FBDI/ADFdi, transformation mappings (XSLT/JSON/XML), and integration best practices.
• Proficiency with OCI services relevant to integrations (Object Storage, Networking, Keys/Certificates).
• Strong PL/SQL and performance tuning skills with the ability to debug complex data flows.
• Experience participating in cross-functional design reviews such as ERP TDD and integration-focused reviews.
• Excellent communication skills and experience supporting large integration programs.

Responsibilities

• Design, build, and maintain OIC integrations (orchestrations, scheduled jobs, file-based flows, event-driven integrations) that support ERP modernization and UNIFI operations.
• Implement REST/SOAP services, OIC connectors, EBS adapters, FTP/SFTP, and OCI Object Storage patterns.
• Build FBDI-based and API-based integrations for Financials, Procurement, AR/AP, and custom modules.
• Develop transformation mappings (XSLT/JSON/XML) and apply error-handling, retry, and notification frameworks.
• Develop and troubleshoot PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts, and middleware/integration components; implement monitoring and audit-ready logging; support test cycles and cutovers; and resolve production defects while adhering to federal security and compliance expectations.

Skills

Oracle EBS

OIC orchestration

SQL/PLSQL

REST/SOAP integrations

EBS interfaces/APIs

FBDI/ADFdi

ETL patterns

OCI Object Storage/Networking

Performance tuning

Tools

ODI

Informatica

OCI DevOps pipelines

Git-based CI/CD

Job description

Accelyst, LLC is seeking a Senior Oracle Integration Cloud (OIC) Middleware Specialist to design, build, and support ETL jobs and OIC integrations for an Oracle E-Business Suite R12 environment hosted in OCI. You will ensure secure, scalable data flows between EBS and external systems and adhere to enterprise integration standards.

The role requires deep expertise in OIC orchestration, REST/SOAP services, FBDI/HDL patterns, ERP adapters, and PL/SQL with hands-on knowledge of EBS interface tables