Title: Oracle OIC/ETL Specialist
Client: USAC
Location: Washington DC
JD:
OIC Integration Design & Development
- 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.
- 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.
- 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.
- 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.
- 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 like Review ERP TDD for ERB or integration-focused reviews.
- Excellent communication skills and experience supporting large integration programs.
Preferred Qualifications
- 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.
AK Dube
[email protected]
Pay: $80.00 per hour
Work Location: In person
