Oracle Integration Cloud (OIC) Developer

Job Description: Oracle Integration Cloud (OIC) Developer – Public Safety

Position Title: Oracle Integration Cloud (OIC) Developer

Domain: Public Safety / State & Local Government

Location: 100% Remote (USA)

Employment Type: Contract (6–12 Months, potential extension)

Work Authorization: US Citizen or Green Card preferred (due to CJIS compliance considerations)

Position Overview

We are seeking an experienced Oracle Integration Cloud (OIC) Developer to lead the architecture, implementation, and optimization of critical system integrations, data conversions, and migrations within a Public Safety enterprise environment.

In this role, you will be responsible for bridging legacy public safety systems (CAD, RMS, JMS) with modern cloud platforms, ensuring secure, high-integrity data movement and automated transactional workflows that support first responders and public safety agency operations.

Key Responsibilities

• Integration Development: Design, build, configure, test, and deploy robust orchestrations using Oracle Integration Cloud (OIC Gen 2 / Gen 3) covering both application integration and process automation.
• Hybrid Connectivity: Deploy and manage OIC On-Premises Connectivity Agents to establish secure communication between municipal on-premise infrastructure and cloud targets.
• Data Migration & Conversion: Plan, execute, and validate bulk data conversions and legacy data migration pipelines, leveraging FBDI, Stage File actions, OCI Object Storage, and REST/SOAP endpoints.
• Transformation & Mapping: Build complex payload mappings utilizing XSLT, XPath functions, JSON transformations, and custom PL/SQL staging procedures.
• Error Handling & Resilience: Implement enterprise-grade fault handling, automated retry mechanisms, error notification frameworks, and tracking dashboards within OIC.
• Compliance & Governance: Ensure all data in transit and at rest strictly adheres to public safety compliance standards, including CJIS (Criminal Justice Information Services), NIST guidelines, and PII protection protocols.
• Reporting & Operational Support: Assist in building data extract feeds for OTBI/BIP reports and provide technical escalation support during deployment cycles and post-go-live stabilization.

Required Technical Qualifications

• 5+ years of hands-on enterprise integration experience, with at least 3+ years dedicated to Oracle Integration Cloud (OIC) .
• Proven track record building both scheduled batch orchestrations and real-time event-driven integrations .
• Deep proficiency with integration protocols and formats: REST, SOAP, WSDL, XML, XSLT, JSON, and XPath .
• Strong database integration capabilities with Oracle DB, PL/SQL, SQL , and stored procedures.
• Hands-on experience configuring and maintaining the OIC Connectivity Agent for hybrid network connectivity.
• Practical knowledge of bulk data operations (chunking, staging, file handling, and large payload management).

Preferred / Nice-to-Have Skills

• Direct experience integrating Public Safety applications (e.g., Computer-Aided Dispatch [CAD], Records Management Systems [RMS], Jail Management Systems [JMS], or 911 dispatch platforms).
• Familiarity with CJIS security compliance requirements.
• Experience with adjacent Oracle Cloud technologies (OCI, Oracle Fusion ERP/HCM, Visual Builder Cloud Service [VBCS], or Process Cloud Service [PCS]).
• Relevant certifications: Oracle Cloud Platform Application Integration Specialist .