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

Ampcus Inc. • Washington, DC

2d

About The Position

Ampcus Inc. is seeking a highly motivated Senior Oracle Integration Cloud (OIC) Middleware, ETL, and EBS Integration Specialist. This role is responsible for designing, building, and supporting ETL Jobs and Oracle Integration Cloud (OIC) integrations within an Oracle E-Business Suite R12 environment hosted in OCI. The specialist will ensure reliable, secure, and scalable data flows between EBS and external systems, adhering to enterprise integration standards and operational readiness. This position demands deep expertise in OIC orchestration, REST/SOAP services, FBDI/HDL patterns, ERP adapters, ETL processes, and a hands-on understanding of EBS interface tables, APIs, and concurrent program frameworks.

Requirements

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

Nice To Haves

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

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.
• 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.
• Support SOX/SOD, audit evidence, and compliance documentation as required.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed