Senior Specialist - Package Implementation

Key Responsibilities

Job Summary

Responsible for designing developing and managing data integrations between Oracle EPBCS and various source systems to support planning and reporting processes

Job Description

Design and develop data integrations between Oracle EPBCS and source systems such as ERP data warehouses and flat files Configure and manage Data Management Data Exchange and FDMEE for data loading and transformation processes Build and maintain data mappings load rules and integration pipelines to enable planning and reporting cycles Implement integrations using EPM Integration Agent APIs RESTSOAP and automation scripts Perform data validation reconciliation and error handling to ensure data accuracy across systems Automate integration jobs using EPM Automate scripting and scheduling tools to improve efficiency Troubleshoot and resolve data load failures mapping issues and integration errors Collaborate with finance and IT teams to translate business requirements into effective integration solutions Support testing phases including System Integration Testing SIT and User Acceptance Testing UAT deployment and migration of integration components across environments Maintain comprehensive technical documentation and ensure compliance with audit and governance standards

Roles and Responsibilities

Lead the design and development of data integration solutions for Oracle EPBCS Configure and manage Data Management tools including Data Exchange and FDMEE Develop and maintain data mappings load rules and integration workflows Utilize EPM Integration Agent RESTSOAP APIs and automation scripts to implement integrations Conduct thorough data validation reconciliation and error handling activities Automate and schedule integration jobs using EPM Automate and scripting languages to improve operations Diagnose and resolve issues related to data loads mappings and integration processes Work closely with crossfunctional teams including finance and IT to gather and analyze integration requirements Manage testing deployment and migration activities for integration components Ensure documentation remains current and compliance with relevant audit and governance policies is maintained