Oracle Fusion ERP Technical Reports and OIC Consultant

IBM

IBM

IT

Calgary, AB, Canada

Posted on May 27, 2026
Introduction

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.

In this role, you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.

Your role and responsibilities
  • 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
Required education
Bachelor's Degree
Preferred education
Bachelor's Degree
Required technical and professional expertise
  • 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
Preferred technical and professional experience
  • 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 BUSINESS UNIT

IBM Consulting is IBM’s consulting and global professional services business, with market leading capabilities in business and technology transformation. With deep expertise in many industries, we offer strategy, experience, technology, and operations services to many of the most innovative and valuable companies in the world. Our people are focused on accelerating our clients’ businesses through the power of collaboration. We believe in the power of technology responsibly used to help people, partners and the planet.

YOUR LIFE @ IBM

In a world where technology never stands still, we understand that, dedication to our clients success, innovation that matters, and trust and personal responsibility in all our relationships, lives in what we do as IBMers as we strive to be the catalyst that makes the world work better.

Being an IBMer means you’ll be able to learn and develop yourself and your career, you’ll be encouraged to be courageous and experiment everyday, all whilst having continuous trust and support in an environment where everyone can thrive whatever their personal or professional background.

Our IBMers are growth minded, always staying curious, open to feedback and learning new information and skills to constantly transform themselves and our company. They are trusted to provide on-going feedback to help other IBMers grow, as well as collaborate with colleagues keeping in mind a team focused approach to include different perspectives to drive exceptional outcomes for our customers. The courage our IBMers have to make critical decisions everyday is essential to IBM becoming the catalyst for progress, always embracing challenges with resources they have to hand, a can-do attitude and always striving for an outcome focused approach within everything that they do.

Are you ready to be an IBMer?

ABOUT IBM

IBM’s greatest invention is the IBMer. We believe that through the application of intelligence, reason and science, we can improve business, society and the human condition, bringing the power of an open hybrid cloud and AI strategy to life for our clients and partners around the world.

Restlessly reinventing since 1911, we are not only one of the largest corporate organizations in the world, we’re also one of the biggest technology and consulting employers, with many of the Fortune 500 companies relying on the IBM Cloud to run their business.

At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing and blockchain. Now it’s time for you to join us on our journey to being a responsible technology innovator and a force for good in the world.

IBM is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, neurodivergence, age, or other characteristics protected by the applicable law. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

OTHER RELEVANT JOB DETAILS

Must have the ability to work in Canada without sponsorship.

This role will involve working with technology that is covered by Export Regulations sanctions. If you are a Foreign National from any of the following US sanctioned countries (Cuba, Iran, North Korea, Syria, and the Crimea, Luhansk, Donetsk, Kherson, and Zaporizhia regions of Ukraine) on a work permit, you are not eligible for employment in this position.

See more open positions at IBM