Senior OIPA Technical Integration Consultant

Senior OIPA Technical Integration Consultant

Location: Remote

Role Description:

Support OIPA implementations through hands-on delivery of inbound integrations and outbound data extracts. Extensive OIPA technical experience is essential.

Responsibilities:

• Design, develop, and support OIPA integrations using REST/SOAP services, AsFile, and Oracle Integration Cloud (OIC).
• Develop outbound extracts using Oracle SQL and PL/SQL, including source-data mapping, selection logic, transformations, reconciliation, and performance tuning.
• Translate functional requirements into technical designs that accurately reflect OIPAs data model, configuration, and processing behavior.
• Own assigned components through development, testing, environment promotion, and defect resolution, working with configuration, QA, and infrastructure teams.

Required experience:

• Extensive recent experience delivering OIPA integrations and extracts, with strong knowledge of its data model, activity processing, and configuration framework. OIPA 12.x experience preferred.
• Proven hands-on development with AsFile, XML/XSLT, and REST/SOAP services.
• Strong Oracle SQL and PL/SQL skills, including stored procedures, complex queries, asynchronous execution patterns, and extract validation.
• Experience with OIC orchestration and file-based integration, including error handling, recovery, and operational monitoring.
• Ability to diagnose issues across application, integration, and database layers and deliver independently with minimal technical guidance.
• Candidates should demonstrate personal ownership of completed OIPA integration and extract implementations.