Oracle EPM Data Integration Lead Consultant

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.

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.

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.

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!