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

Job Summary/Company: Our client is seeking an expert Oracle Cloud Middleware & ETL Developer to work onsite in Washington DC. 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.

Responsibilities:

• 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.
• Design and support interfaces and concurrent program frameworks using EBS staging tables, validations, and public APIs.
• Participate in integration design reviews and cross-team planning meetings (e.g., ERP Interim Operational Capacity (IOC) Design Review).

Qualifications/Background Profile:

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

------------------------------------------------------------------

This job is Hybrid Remote.

Pay Range: Hourly $90.00 to $105.00

We offer several comprehensive benefits package including health and life insurance, paid and unpaid time off, and retirement and savings plans to qualifying employees.

Download the Sparks Group mobile app from Apple App Store or Google Play.

------------------------------------------------------------------

Sparks Group is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, pregnancy, citizenship, family status, genetic information, disability, or protect veteran status.