Lead Consultant, Oracle EPM Data Integration

Alithya

. Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and source and target systems .

Posted 10/8/2026full-timeRemote • CanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and managing integrations between Oracle EPM Cloud applications and various systems, with a strong focus on data mapping, transformation, and automation. Proficient in utilizing Oracle EPM REST APIs and scripting languages to enhance integration processes and ensure operational transparency.

Highest-signal resume keywords

Oracle EPM Cloud Analytical ProductsData Mapping and TransformationOracle Integration Cloud (OIC)ANSI SQL, T-SQL, or Oracle SQLIntegration Testing and User Acceptance Testing (UAT)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data WranglingEPM Automate ScriptingJava DevelopmentGroovy DevelopmentC# DevelopmentPowerShell ScriptingVBScript ScriptingJython ScriptingPython ScriptingRelational Database Management

Soft Skills

CollaborationCommunicationProblem-Solving

Tools & Technologies

EPM Integration Agent (EPMIA)FDMEECloud Data Management (CDM)PipelinesOracle EPM REST APIs

Industry Keywords

Integration SpecificationsEnterprise Architecture StandardsSystem Administration GuidesIntegration Detailed Design Documents

Tech Stack

Tools & technologies

CloudGroovyJavaOraclePythonSQL

About the role

Key responsibilities & impact

Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and 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 for accurate and consistent data movement
Automate integration tasks using EPM Automate scripts, batch files, and REST APIs
Monitor integration jobs, analyze logs, and promptly resolve errors or data issues
Collaborate with business and technical teams to define integration specifications and align with enterprise architecture standards
Communicate blockers, dependencies, risks, status updates, and other project-related information to stakeholders
Document integration designs, configurations, and runbooks to support operational transparency

Requirements

What you’ll need

B.Tech, BE, M.Tech, or MCA in Computer Science, Information Systems, or Software Engineering
5+ years of experience with Oracle EPM Cloud Analytical products such as FCCS, EPBCS, PCMCS, or ARCS
Experience with integration products including Pipelines, Cloud Data Management (CDM/Data Exchange), FDMEE, EPM Integration Agent (EPMIA), and ODI
Experience with data wrangling, mapping, and transforming data from source to target systems
Experience with relational database management systems and 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
Proficient English
Intermediate French
Experience with PowerShell, VBScript, Jython, Python, or Groovy scripting
Experience with system integration testing and user acceptance testing (UAT)
Experience with Oracle Integration Cloud (OIC)
Experience authoring integration detailed design documents and system administration guides

Benefits

Comp & perks

Flexible work options
Unlimited Vacation Plan
24/7 virtual healthcare
Wellness portal with tools and resources for physical, mental, emotional, and financial well-being
Access to thousands of online courses and certifications
Exclusive leadership programs
Tuition reimbursement program for external training
Employee Share Purchase Plan with matched contributions