Oracle Fusion ERP Technical Reports and OIC Consultant

Ibm

Apply to this job
Canada Until 10/4/2026 7+ years exp First posted June 8, 2026 Last posted August 5, 2026
Job description

We are seeking a highly experienced Oracle Fusion ERP Technical Reports and OIC Consultant with a minimum of 7 years of experience to join our team. The ideal candidate will be a subject matter expert in Oracle Integration Cloud (OIC) and Oracle Fusion ERP reporting tools, capable of leading technical implementations, designing complex integrations, and mentoring junior team members.

  • Lead the design, development, and deployment of complex integrations using Oracle Integration Cloud (OIC)
  • Architect and implement REST and SOAP-based web services and API integrations
  • Build end-to-end integrations between Oracle Fusion ERP Cloud and third-party applications (Salesforce, Workday, legacy systems, etc.)
  • Develop and optimize File-Based Data Imports (FBDI), HCM Data Loader (HDL), and ADFdi integrations
  • Design and implement OIC Process Automation and orchestration workflows
  • Troubleshoot complex integration issues, performance bottlenecks, and error handling
  • Monitor, maintain, and optimize integrations in production environments
    • Implement best practices for integration design, security, and governance
    • Design and develop advanced custom reports using BI Publisher (BIP), OTBI (Oracle Transactional Business Intelligence), and Smart View
  • Create complex SQL queries, data models, and sub-templates for enterprise reporting requirements
  • Develop reports across Financial Management, Procurement, Supply Chain Management, Project Management, and HCM modules
  • Build interactive dashboards and analysis using OTBI
  • Work closely with business stakeholders to gather requirements and translate them into scalable technical solutions
  • Configure and schedule reports using ESS (Enterprise Scheduler Service)
  • Optimize report performance and troubleshoot reporting issues
  • Minimum 7+ years of hands-on experience with Oracle Fusion ERP Cloud (SaaS)
  • 5+ years of experience with Oracle Integration Cloud (OIC) or similar integration platforms (Oracle SOA, Dell Boomi, MuleSoft)
  • 5+ years of experience developing reports using BI Publisher (BIP) and OTBI
  • Strong expertise in SQL, PL/SQL, XML, XSLT, XPath, and Groovy scripting
  • Deep understanding of REST/SOAP APIs, web services, and integration patterns
  • Extensive experience with FBDI, HDL, ADFdi, and Web Services (SOAP/REST)
  • Solid knowledge of Oracle Fusion modules: Financials (GL, AP, AR, FA, CM), SCM (Procurement, Inventory, Order Management), or HCM (Core HR, Payroll, Talent Management)
  • Experience with Oracle Fusion security model (roles, privileges, data security policies)
  • Proven ability to lead technical implementations and mentor team members
  • Strong analytical, problem-solving, and troubleshooting skills
  • Excellent communication and stakeholder management abilities
  • Ability to work independently and manage multiple priorities
  • Experience with VBCS (Visual Builder Cloud Service) for custom application development
  • Knowledge of OIC Process Automation and Oracle Process Cloud Service
  • Familiarity with Oracle Cloud Infrastructure (OCI) and cloud architecture
  • Experience with Subledger Accounting (SLA), Costing, or Financial Reporting Studio (FRS)
  • Understanding of Oracle EPM Cloud (FCCS, ARCS, EDMCS)
  • Experience with DevOps practices and CI/CD pipelines for Oracle Cloud
  • Knowledge of Agile/Scrum methodologies
  • Experience in at least 2 full lifecycle Oracle Fusion implementations
  • Oracle certifications in Oracle Fusion ERP or Oracle Integration Cloud
  • Experience working with global, distributed teams
About this role

Summary

Lead Oracle Fusion ERP reporting, integrations, and automation; mentor team.

Job title

Oracle Fusion ERP Technical Reports and OIC Consultant

Experience level

7+ years

Minimum experience

7+ years exp

Industry

software

Location requirements

Canada, remote work allowed

Salary

Not specified

Management role

No

Skills & keywords

Required skills

oracle fusionoracle integration cloudbi publisherotbisqlpl/sqlxmlxsltxpathgroovyweb services

Preferred skills

oracle cloud infrastructurevbcSoracle process cloudoracle epm clouddevops

Specializations

oracle fusionerpoicreportsintegration
Locations

Structured locations inferred from the posting.

Canada

Remote Country
Related searches