Alithya

Oracle Cloud EPM Data Integration Consultant

Alithya

full-time

Posted on:

Location Type: Remote

Location: Canada

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

CloudGroovyJavaOraclePythonSQL

About the role

  • Design, implement, and manage end-to-end integrations between Oracle EPM Cloud applications and various source/target systems;
  • Register various source applications, build integrations with proper mappings, export data to target systems or files, automate using pipelines, etc.;
  • 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 messages and updates regarding blockers, dependencies, risks, and status to all project stakeholders;
  • Document integration designs, configurations, and runbooks for operational transparency.

Requirements

  • Bachelor of Technology (B.Tech.), Bachelor of Engineering (BE), Master of Technology (M.Tech.) or Master of Computer Applications (MCA) in computer science, information systems or software engineering from an accredited university;
  • Minimum 2 years of integration product experience (Pipelines, CDM – Data Management or Data Exchange, FDMEE, EPMIA, ODI);
  • Minimum 2 years of experience in data wrangling, mapping and transforming data from source to target;
  • Minimum 2 years of experience working with relational database management systems;
  • Minimum 2 years of working knowledge on any EPM Cloud analytical products such as FCCS, EPBCS, PCMCS or ARCS;
  • Working knowledge of Oracle EPM REST APIs and EPM Automate Commands for all EPM products;
  • Strong prioritization, sense of ownership, and focus skills with multitasking and competing priorities.
  • Extra edge: Experience with Java, Groovy, or C# development, and scripting with PowerShell;
  • Oracle Integration Cloud (OIC) experience;
  • Working knowledge of CDM, FDM, or FDMEE with scripting experience in VBScript, Jython, Python, or Groovy;
  • Proficiency in ANSI SQL, T-SQL, or Oracle SQL;
  • System and integration testing, and user acceptance testing experience;
  • Experience authoring integration detailed designs and system administration guides.
  • Language skills: French: Proficient, English: Proficient
Benefits
  • Unlimited Vacation Plan
  • Access to 24/7 virtual healthcare
  • Extensive wellness portal for health and wellness
  • Educational partnerships for online courses and certifications
  • Tuition reimbursement program for external training
  • Employee Share Purchase Plan
Applicant Tracking System Keywords

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

Hard Skills & Tools
EPM AutomateREST APIsdata mappingdata transformationdata wranglingrelational database management systemsOracle EPM CloudANSI SQLT-SQLOracle SQL
Soft Skills
prioritizationownershipfocusmultitaskingcommunication
Certifications
Bachelor of TechnologyBachelor of EngineeringMaster of TechnologyMaster of Computer Applications