Senior Oracle integration Cloud (OIC) Middleware & ETL Developer (EBS 12.2.12)

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

The Senior Oracle Integration Cloud (OIC) Middleware ETL EBS Integration Specialist is responsible for designing building and supporting ETL Jobs Oracle Integration Cloud (OIC) integrations for an Oracle E-Business Suite R12 environment hosted in OCI. This role ensures reliable secure and scalable data flows between EBS and external systems aligning with enterprise integration standards and operational readiness activities. This position requires deep expertise in OIC orchestration REST/SOAP services FBDI/HDL patterns ERP adapters ETL Process and hands-on understanding of EBS interface tables APIs and concurrent program frameworks.

• Design build and maintain OIC 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.
• 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 as needed 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.

• Design and support interfaces and concurrent program frameworks using 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.

• Participate in integration design reviews and cross-team planning meetings.
• Support cutovers migrations and release deployments across OCI environments.
• Coordinate with DBAs EBS Admins and Technical Developers to validate end-to-end integration readiness.

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

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

• 710 years with Oracle EBS technical or integration development including strong expertise in EBS R12.
• 35 years hands-on with Oracle Integration Cloud (OIC) including orchestrations.
• 35 years hands-on with Oracle SQL PL/SQL 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 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.
• Excellent communication skills and experience supporting large integration programs.

• Background in EBS integrations with cloud systems ERP modernization.
• Experience in Data warehouse tools (e.g. OBIEE Snowflake etc.).
• Experience in ETL tools (e.g. ODI Informatica etc.).
• Experience in OCI DevOps pipelines Git-based CI/CD for OIC or API Gateway.