Oracle EPM Data Integration Lead Consultant

Accountabilities

Integration Design and Implementation: Design, develop, deploy, and maintain end-to-end integrations between Oracle EPM Cloud applications and various source and target systems, ensuring reliable and scalable data exchange.
Data Integration Management: Register source applications, configure integrations and mappings, export data to target systems or files, and automate data movement through integration pipelines.
Data Mapping and Transformation: Define and maintain data mappings, transformation rules, and validation procedures to ensure accuracy, consistency, and integrity across connected systems.
Automation and Scripting: Automate integration workflows using EPM Automate, batch files, REST APIs, and relevant scripting technologies to streamline recurring processes and minimize manual intervention.
Monitoring and Troubleshooting: Monitor integration jobs, analyze execution logs, identify data discrepancies, investigate failures, and implement timely corrective actions to maintain reliable operations.
Stakeholder Collaboration: Work with business stakeholders, technical teams, and enterprise architects to gather requirements, define integration specifications, and ensure solutions align with business objectives and technical standards.
Project Coordination: Proactively communicate project progress, dependencies, risks, blockers, and delivery updates to relevant stakeholders, supporting effective planning and execution.
Technical Documentation: Develop and maintain integration design documents, configuration records, operational runbooks, and system administration guides to support knowledge transfer and ongoing maintenance.
Testing and Quality Assurance: Support integration testing and user acceptance testing (UAT), validate data flows, and ensure solutions meet functional and technical requirements before deployment.
Continuous Improvement: Identify opportunities to optimize integration architecture, improve automation, strengthen data quality, and enhance the performance and maintainability of Oracle EPM solutions.
Requirements
Education: Bachelor's or master's degree in Computer Science, Information Systems, Software Engineering, or a related discipline, including B.Tech, BE, M.Tech, or MCA qualifications.
Professional Experience: At least 5 years of relevant experience working with Oracle EPM Cloud applications, data integration solutions, and enterprise data management processes.
Oracle EPM Expertise: Hands-on experience with Oracle EPM Cloud analytical applications such as Financial Consolidation and Close Cloud Service (FCCS), Enterprise Planning and Budgeting Cloud Service (EPBCS), Profitability and Cost Management Cloud Service (PCMCS), or Account Reconciliation Cloud Service (ARCS).
Integration Technologies: Strong practical knowledge of Oracle EPM integration tools and frameworks, including Pipelines, Cloud Data Management (CDM), Data Exchange, FDMEE, EPM Integration Agent (EPMIA), and Oracle Data Integrator (ODI).
Data Management Skills: Experience extracting, transforming, mapping, validating, and loading data across source and target systems, with a strong understanding of data quality and consistency.
Database and SQL Proficiency: Experience with relational database management systems and strong SQL skills, including ANSI SQL, T-SQL, or Oracle SQL.
Programming Experience: Working knowledge of Java, Groovy, or C# for developing and supporting integration components and custom solutions.
Oracle Automation and APIs: Familiarity with Oracle EPM REST APIs, EPM Automate commands, and related data management capabilities, including CDM, FDM, or FDMEE.
Scripting Skills: Experience with PowerShell, VBScript, Jython, Python, or Groovy is an advantage.
Testing and Integration: Experience supporting system integration testing, user acceptance testing, and troubleshooting complex integration scenarios.
Additional Technical Assets: Familiarity with Oracle Integration Cloud (OIC) and experience preparing detailed integration design documents and system administration guides are considered advantageous.
Communication Skills: Proficient English is required to collaborate daily with colleagues and managers outside Quebec. Intermediate French is an asset.
Analytical and Problem-Solving Abilities: Strong troubleshooting, critical-thinking, and attention-to-detail skills, with the ability to identify root causes and develop effective solutions.
Collaboration and Ownership: Ability to work effectively with cross-functional teams, manage competing priorities, communicate risks proactively, and take ownership of technical deliverables.
Benefits
Remote Work Flexibility: Remote work arrangements in Canada, supporting flexibility and work-life balance.
Flexible Time Off: Access to an Unlimited Vacation Plan to help you rest and recharge.
Healthcare and Wellness: Access to 24/7 virtual healthcare and a comprehensive wellness portal supporting physical, mental, emotional, and financial well-being.
Professional Development: Access to thousands of online courses and certifications through partnerships with leading education providers.
Leadership Development: Opportunities to participate in leadership development programs and expand your professional capabilities.
Tuition Reimbursement: Financial support for eligible external training to encourage continuous learning and career advancement.
Employee Share Purchase Plan: Opportunity to become a shareholder through an employee share purchase program with matched contributions.
Meaningful Client Engagements: Work on challenging enterprise technology projects that support digital transformation and business performance.
Collaborative Environment: Join a diverse, inclusive team that values innovation, knowledge-sharing, and continuous improvement.
Inclusive Recruitment: Commitment to equal employment opportunities and accessible recruitment processes, with accommodations available when required.