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