Oracle EPM Data Integration Lead Consultant
At a glance
Senior Data Engineering role at Alithya. Remote, Canada · full-time · no salary stated · we estimate CA$117,900–CA$152,500 across Canada.
Alithya has not published a salary for this role. The figure below is our estimate, not theirs.
remoteroles summary, based on the employer's posting.
What you'll do
- Build and maintain connections between Oracle EPM Cloud applications and source or target systems
- Set up source applications, map data, export it to destinations, and automate transfers through pipelines
- Use EPM Automate, batch files, and REST APIs to run integration tasks
- Track job runs, inspect logs, and fix errors or data problems promptly
- Agree on integration needs with business and technical teams, share project risks, and document designs and runbooks
What you bring
- At least five years working with Oracle EPM Cloud analytical products and integration tools
- A degree in computer science, information systems, software engineering, or another listed field
- Hands-on data mapping and transformation experience, plus proficiency in ANSI SQL, T-SQL, or Oracle SQL
- Experience with a programming language such as Java, Groovy, or C#, and working knowledge of Oracle EPM APIs and automation commands
Who this fits
This senior consultant role suits someone with substantial Oracle EPM integration experience who can work across business and technical teams. English proficiency is required for daily communication with colleagues and managers outside Quebec; intermediate French is listed.
From the employer
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.
Your day-to-day
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.
Extra edge
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.
Language skills
English: Proficient
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.