Senior Oracle OIC Middleware & ETL Developer

Washington, DC, US Posted 3d First seen 3d
ATS Keyword Match See which key terms from this posting your resume already has. Free.
Job Summary Seeking a Senior Oracle OIC Middleware & ETL Developer with 10+ years of Oracle EBS technical/integration experience, including 3 5+ years of hands-on OIC, SQL, and PL/SQL experience. The role focuses on designing, developing, and supporting integrations between Oracle EBS R12, OCI, and external systems. Key Responsibilities Design and develop OIC orchestrations, scheduled jobs, file-based and event-driven integrations. Build REST/SOAP, EBS Adapter, FTP/SFTP, and OCI Object Storage integrations. Develop FBDI/API-based integrations for Financials, Procurement, AR/AP, and custom modules. Develop XSLT/JSON/XML mappings, error handling, retries, notifications, and monitoring. Work with EBS interface tables, APIs, concurrent programs, staging tables, and PL/SQL. Support ETL/data-load processes, cutovers, migrations, and OCI deployments. Monitor and troubleshoot OIC integrations, data failures, performance issues, and complex data flows. Create technical design documents, integration specifications, mappings, and support runbooks. Support SOX/SOD, audit, security, and compliance requirements. Must-Have Skills 7 10+ years Oracle EBS Technical/Integration Strong Oracle EBS R12 3 5+ years hands-on OIC 3 5+ years SQL/PL/SQL & ETL REST/SOAP, APIs, event-driven integrations, FTP/SFTP EBS Interface Tables, Open APIs, Concurrent Programs FBDI/ADFdi XSLT, JSON, XML OCI Object Storage, Networking, Keys/Certificates Strong PL/SQL and performance tuning Excellent communication and integration-program experience. Preferred EBS Cloud Integrations, ERP Modernization, OBIEE/Snowflake, ODI/Informatica, OCI DevOps, Git-based CI/CD, API Gateway. Core Keywords Oracle OIC Oracle Integration Cloud Oracle EBS R12 Middleware ETL PL/SQL SQL REST SOAP FBDI ADFdi EBS APIs Interface Tables Concurrent Programs XSLT JSON XML OCI Object Storage FTP/SFTP OIC Orchestration ERP Integration Data Migration Performance Tuning API Gateway CI/CD