Oracle EPM Data Integration Lead Consultant

Alithya; Montreal (administrative region); Hybrid; CAD 120,000 - 150,000; Full time

Benefits offered by this job

Unlimited vacation

24/7 virtual healthcare

Tuition reimbursement

Employee Share Purchase Plan

Job summary

Alithya is seeking an Oracle EPM Data Integration Lead Consultant to design, develop, and maintain integrations across EPM Cloud applications and source systems. You will focus on data exchange, automation, and end-to-end data flows to support enterprise performance processes.

You will optimize integration pipelines, implement mappings, and ensure reliable connections across systems. Proficiency in Oracle EPM REST APIs, EPM Automate, and scripting is required, with strong English communication

Qualifications

• Bachelor-level degree in CS, IS, or Software Engineering.
• Minimum 5+ years in Oracle EPM Cloud integrations.
• Experience with data wrangling, mapping, and transforming data.

Responsibilities

• Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and various source/target systems.
• Register source applications, build mappings, export data to targets, and enable automation via pipelines.
• Define and manage data mappings, transformations, and validations for accurate data movement.
• Automate tasks using EPM Automate scripts, batch files, and REST APIs.
• Monitor jobs, analyze logs, and promptly resolve data issues.

Skills

Oracle EPM Cloud

EPM Integration

SQL

Java

Groovy

C#

REST APIs

EPM Automate

CDM/FDMEE

ODI

PowerShell

Data Mapping

Education

B.Tech/BE/M.Tech/MCA in CS/IS/SE

Tools

Pipelines

Oracle Integration Cloud (OIC)

SQL tools (ANSI/Oracle/T-SQL)

Job description

Be the First to Apply

Job Info

• Job Identification 1650
• Job Category IT - Development
• Posting Date 2026-10-08, 06:57 PM
• Job Schedule Full time
• Need Justification Replacement

Your role, your impact

As an Oracle EPM Data Integration Lead Consultant , you'll design, develop, and maintain integrations across various EPM Cloud applications and source systems. You'll focus on data exchange, automation, and ensuring seamless end-to-end data flows to support enterprise performance processes.

Leveraging your expertise in Oracle EPM integration and data exchange, you'll help clients streamline data flows, optimize integration processes, and ensure reliable, automated connections across source systems and EPM Cloud applications to support strategic business objectives. Join us and make a significant impact in transforming businesses through Oracle technologies.

• Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and various source and target systems;
• Register source applications, build integrations with mappings, export data to target systems or files and facilitate automation via pipelines;
• Define and manage data mappings, transformations, and validations to ensure accurate and consistent data movement;
• Automate integration tasks using EPM Automate scripts, batch files, and REST APIs;
• Monitor integration jobs, analyze logs, and resolve errors or data issues promptly;
• Collaborate with business and technical teams to define integration specifications and ensure alignment with enterprise architecture standards;
• Proactively identify and communicate blockers, dependencies, risks, status updates, and other project-related information to stakeholders;
• Document integration designs, configurations, and runbooks to support operational transparency.

Keys to your success

• B.Tech, BE, M.Tech, or MCA in Computer Science, Information Systems, or Software Engineering;
• 5+ years of experience with the following:
• Oracle EPM Cloud Analytical products such as FCCS, EPBCS, PCMCS, or ARCS;
• Integration products, including Pipelines, Cloud Data Management (CDM /Data Exchange), FDMEE, EPM Integration Agent (EPMIA), and ODI;
• Data wrangling, mapping, and transforming data from source to target systems;
• Working with relational database management systems, with proficiency in ANSI SQL, T-SQL, or Oracle SQL.
• Experience with Java, Groovy, or C# development;
• Working knowledge of Oracle EPM REST APIs and EPM Automate commands, as well as CDM, FDM or FDMEE.
• Experience with PowerShell, VBScript, Jython, Python, or Groovy scripting;
• Experience system integration testing and user acceptance testing (UAT);
• Experience with Oracle Integration Cloud (OIC);
• Experience authoring integration detailed design documents and system administration guides.
• French: Intermediate

Please note that due to the nature of the responsibilities of the position, a proficient level of English is required, in particular to communicate daily with employees and managers outside of Quebec.

Our mission, your future

As a global network of trusted advisors, we create cutting-edge technological solutions to overcome today’s challenges and anticipate tomorrow’s needs. It all starts with the collaboration of a diverse team of passionate innovators, each driven to make a difference. Together, we challenge the status quo and push each other to new heights.

Ready to leave your mark on engaging mandates and shape the future through digital transformation and strategic consulting? Take your ambitions to the next level and discover your next exciting challenge with us!

Our offer

• Balance that works for you: Work-life balance helps us stay at our best. With flexible work options and our Unlimited Vacation Plan, you can rest and recharge when you need it most.
• Support for your well-being: Our benefits are designed with optimal health and wellness in mind. You'll have access to 24/7 virtual healthcare, as well as an extensive wellness portal that provides tools and resources to support your physical, mental, emotional and financial well-being.
• Continuous growth and learning: Through partnerships with world-renowned education leaders, we provide access to thousands of top-rated online courses and certifications. With exclusive leadership programs and a tuition reimbursement program for external training, we set you up to achieve your ambitions.
• Ownership with opportunity: Through our Employee Share Purchase Plan with matched contributions, you become a shareholder, directly benefiting from our collective achievements.

Our commitments

Equal employment opportunity : Alithya is committed to providing an inclusive workplace through the implementation of an equal employment opportunity program. We encourage women, Indigenous peoples, visible and ethnic minorities, and persons with disabilities to apply.

An inclusive path to success: Fostering an environment where you can thrive starts with ensuring an accessible recruitment process. If you require any accommodations , we welcome you to contact us. For more information, please visit our accessibility page: https://www.alithya.com/en/accessibility .