Remote Oracle Technical Consultant

Job Description

Job Description

Remote Oracle Technical Consultant (Oracle Fusion Cloud ERP Implementation)

OCI/OIC Integrations & Data Conversion

Client: Confidential Payment Processing Client

Duration: 9 months

Key Responsibilities

1. Oracle Integration Development

·    Design, develop, unit test, and deploy integrations using Oracle Integration Cloud (OIC).

·    Collaborate with SI Partner functional and technical teams to translate business requirements and functional designs into technical solutions.

·    Build and support inbound and outbound integrations between Oracle Fusion ERP and external platforms.

·    Develop REST and SOAP web service integrations, file-based interfaces, scheduled orchestrations, and event-driven integrations.

·    Implement robust error handling, logging, monitoring, restart, and reconciliation capabilities.

·    Troubleshoot integration defects and support SIT, UAT, cutover, and hypercare.

2. Data Conversion Activities

·    Develop and support Oracle data migration processes using FBDI, HDL, ADFDI, Spreadsheet Loader, and other applicable loading methods.

·    Create and maintain source-to-target mappings, transformation rules, extraction and conversion scripts, validation routines, and reconciliation reports.

·    Support mock conversions, dress rehearsals, production data migration, and post-load validation.

·    Analyze and resolve data quality, transformation, interface, and load errors with business, functional, and source-system teams.

3. OCI Technical Development

·    Develop and support OCI-based technical components required for Oracle Fusion integrations and conversions.

·    Use OCI services, including Object Storage, for file movement, staging, automation, logging, and data processing.

·    Support secure connectivity, deployment, monitoring, and issue resolution across OCI and OIC environments.

4. Technical Documentation, Testing & Deployment

·    Prepare Technical Design Documents, mapping specifications, unit test evidence, deployment instructions, and operational support documentation.

·    Participate in technical walkthroughs, design reviews, code reviews, and architecture governance discussions.

·    Support SIT, UAT, production readiness testing, defect triage, cutover execution, and hypercare.

5. Collaboration & Governance

·    Coordinate delivery activities with SI Partner technical consultants and leads.

·    Participate in working sessions, status meetings, defect triage, and technical workshops.

·    Provide clear progress updates and proactively escalate risks, issues, dependencies, and decisions.

·    Maintain delivery discipline, version control, traceability, and compliance with program governance standards.

Required Skills & Experience

Professional Experience

·    7-9 years of hands-on Oracle technical consulting or development experience.

·    Experience delivering at least two Oracle Fusion Cloud ERP implementation projects involving integrations and/or data conversions.

·    Proven experience working in large-scale ERP transformation programs with client teams and SI Partners.

·    Ability to work independently, manage assigned deliverables, and collaborate effectively in a multi-vendor environment.

Oracle Integration Cloud (OIC)

·    Strong hands-on experience designing and developing OIC integrations and orchestrations.

·    Experience with REST APIs, SOAP web services, file-based interfaces, scheduled integrations, connectivity agents, adapters, and integration monitoring.

·    Practical knowledge of exception handling, fault policies, reprocessing, security, performance tuning, and production troubleshooting.

Oracle Cloud Infrastructure (OCI)

·    Working knowledge of OCI fundamentals and services used to support integrations and conversions.

·    Experience with OCI Object Storage, identity and access concepts, networking fundamentals, security, monitoring, and logging.

·    Ability to support deployment and operational troubleshooting across OCI and OIC components.

Data Conversion & Oracle Technical Skills

·    Hands-on experience with FBDI, HDL, ADFDI, Spreadsheet Loader, and other Oracle Fusion loading utilities, as applicable.

·    Experience with data extraction, cleansing, mapping, transformation, validation, reconciliation, mock conversions, and cutover execution.

·    Strong SQL, PL/SQL, XML, XSLT, JSON, Oracle Fusion REST and SOAP web services skills.

·    BI Publisher and OTBI reporting experience is preferred.

Preferred Experience

·    Oracle Fusion Financials exposure across GL, AP, AR, Cash Management, Procurement, and Fixed Assets.

·    Experience integrating Oracle Fusion with treasury systems, banking platforms, data warehouses, tax engines, and payment processors.

·    Experience supporting SIT, UAT, cutover planning and execution, hypercare, and transition to sustainment.

Key Competencies

·    Strong analytical, diagnostic, and problem-solving skills.

·    High attention to detail in technical design, mapping, reconciliation, data quality, and test evidence.

·    Clear written and verbal communication with technical and non-technical stakeholders.

·    Ability to work independently with minimal supervision while remaining aligned with program leads.

·    Collaborative approach when working with architects, functional consultants, developers, source-system teams, and SI Partners.