Lead Consultant, Oracle EPM Data Integration

Posted 4 hours ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Oracle EPM consultant designing automated data integrations across cloud performance systems. Supporting Alithya’s enterprise technology and digital transformation consulting engagements.

Responsibilities

  • 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

  • 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

  • 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

Job title

Job type

Full Time

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

CloudGroovyJavaOraclePythonSQL

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.