EI
Senior Oracle Integration Cloud (OIC) Middleware & ETL Developer
Expert In Recruitment Solutions
🇺🇸 United States
On-site
Senior
1 month ago
- Oracle
- ETL
- EBS
- OCI
- SOAP
- ERP
- FTP
- SFTP
- XSLT
- JSON
- XML
- PL/SQL
- SOX
- Oracle EBS
- SQL
- TDD
- Snowflake
- Informatica
- Devops
- Git
- CI/CD
- API Gateway
1 month ago
This position requires deep expertise inOIC orchestration, REST/SOAP services, FBDI/HDL patterns, ERP adapters, ETL Processand hands-on understanding of EBS interface tables, APIs, and concurrent program frameworks.
Key Responsibilities
OIC Integration Design & Development
• Design, build, and maintainOIC integrations(orchestrations, scheduled jobs, file-based flows, event-driven integrations) that support ERP modernization and UNIFI operations, aligned with initiative discussions in Pre-IBM Review Meeting Re: Integrations and Data Transport Methods.
• ImplementREST/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.
• Developing and troubleshooting PL/SQL, EBS interfaces/APIs, concurrent programs, BI Publisher/XML artifacts as needed, and middleware/integration components (e.g.,Oracle integration Cloud (OIC)/Oracle Integration patterns, web services, file-based exchanges); implementing monitoring and audit-ready logging; supporting test cycles and cutovers; and resolving production defects while adhering to federal security and compliance expectations.
EBS R12 Integration Support
Confidential - Not for Public Disclosure
• Design and supportinterfaces and concurrent program frameworksusing EBS staging tables, validations, and public APIs.
• Collaborate with technical teams on data extraction requirements for outbound integrations.
• Troubleshoot data, process, API, and workflow issues involving EBS subledger modules.
Operational Readiness & Migration Support
• Participate in integration design reviews and cross-team planning meetings (e.g., ERP Interim Operational Capacity (IOC) Design Review).
• Support cutovers, migrations, and release deployments across OCI environments.
• Coordinate with DBAs, EBS Admins, and Technical Developers to validate end-to-end integration readiness.
Monitoring, Troubleshooting & Support
• Monitor OIC dashboards, error logs, instance runs, and connectors.
• Analyze and resolve integration failures, data inconsistencies, and performance bottlenecks.
• Enhance logging, observability, and exception-handling capabilities to meet enterprise reliability standards.
Documentation & Governance
• Develop technical design documents, integration specifications, and support runbooks.
• Maintain source-to-target mappings, API catalogs, and versioning standards in alignment with ongoing operational planning .
• Support SOX/SOD, audit evidence, and compliance documentation as required.
Required Skills & Experience
• 7–10+ years with Oracle EBS technical or integration development, including strong expertise inEBS R12.
• 3–5+ years hands-on withOracle Integration Cloud (OIC), including orchestrations.
• 3–5+ years hands-on withOracle SQL, PL/SQL ETLdata-load patterns.
• REST/SOAP integrations, event-driven flows, file transfers, and scheduling.
• Strong experience withEBS interface tables, open APIs, concurrent programs, and data-load patterns.
• Expertise withFBDI/ADFdi, transformation mappings (XSLT/JSON/XML), and integration best practices.
• Proficiency withOCI servicesrelevant 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 like Review ERP TDD for ERB or integration-focused reviews.
• Excellent communication skills and experience supporting large integration programs.
Preferred Qualifications
• Background inEBS integrations with cloud systems, ERP modernization.
• Experience inData warehouse tools(e.g., OBIEE, Snowflake, etc..)
• Experience inETL tools(e.g., ODI, Informatica, etc..)
• Experience in OCI DevOps pipelines, Git-based CI/CD for OIC, or API Gateway
Senior Oracle Integration Cloud (OIC) Middleware & ETL Developer · Expert In Recruitment Solutions