Oracle EPM Data Integration Lead Consultant

Alithya; Montreal; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Unlimited vacation

24/7 virtual healthcare

Wellness portal & resources

Online courses & certifications

Tuition reimbursement

Employee share purchase plan

Job summary

Alithya in Montreal, QC is seeking an experienced Oracle EPM Data Integration Lead Consultant to design, develop, and maintain integrations across Oracle EPM Cloud apps and source systems. You will drive end-to-end data flows to support enterprise performance processes.

You will leverage expertise in Oracle EPM integration, data mappings, and automation to streamline data exchange, build scalable pipelines, and ensure reliable connections across systems in a dynamic consulting environment.

Qualifications

• 5+ years of experience with Oracle EPM Cloud Analytical products and integrations.
• Strong data wrangling, mapping, and transformation skills.
• Proficiency with SQL (ANSI/Oracle/T-SQL).
• Experience with REST APIs and scripting languages (PowerShell, Python, Groovy, Java, C#).
• Knowledge of EPM Automate and Oracle Integration Cloud (OIC).
• Experience in system integration testing and UAT.

Responsibilities

• Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and various source and target systems.
• Register source applications, build mappings, export data to target systems or files, and automate 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 integration jobs, analyze logs, and resolve data issues promptly.
• Collaborate with business and technical teams to define integration specs and ensure alignment with enterprise standards.
• Proactively communicate blockers, dependencies, risks, and status updates to stakeholders.
• Document integration designs, configurations, and runbooks for operational transparency.

Skills

Oracle EPM Cloud

FCCS/EPBCS/PCMCS/ARCS

Data integration

SQL

Java/Groovy/C#

REST APIs

OIC

PowerShell

UAT

Documentation

Education

B.Tech/BE/M.Tech/MCA (CS/IS/SE)

Tools

Pipelines

CDM/Data Exchange

FDMEE

EPM Integration Agent

ODI

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 .