Senior OIPA Technical Integration Consultant

Delivery Centric Technologies; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

Delivery Centric Technologies is seeking a Senior OIPA Technical Integration Consultant to lead hands-on delivery of inbound integrations and outbound data extracts. This remote role demands deep OIPA expertise and proven ability to translate requirements into robust technical designs.

You will design and implement OIPA integrations using REST/SOAP, AsFile, and OIC, and develop complex SQL/PLSQL extracts with careful data mapping and validation.

Qualifications

• Extensive recent experience delivering OIPA integrations and extracts, with knowledge of its data model, activity processing, and configuration framework.
• Hands-on development with AsFile, XML/XSLT, and REST/SOAP services.

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 mapping, logic, transformations, reconciliation, and performance tuning.
• Translate functional requirements into technical designs reflecting OIPA data model, configuration, and processing behavior.
• Own assigned components through development, testing, environment promotion, and defect resolution with cross-functional teams.

Skills

OIPA integrations

AsFile

XML/XSLT

REST/SOAP services

Oracle SQL/PLSQL

OIC orchestration

File-based integration

Error handling

Monitoring

Ownership

Job description

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.