Senior Specialist - Package Implementation
Job Description
Role description
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, including Data Exchange and FDMEE, to enable data loading and transformation processes. Build and maintain data mappings, load rules, and integration pipelines to support planning and reporting cycles. Implement integrations using EPM Integration Agent APIs (REST/SOAP) 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 enhance 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 REST/SOAP APIs and automation scripts to implement integrations. Conduct thorough data validation, reconciliation, and error handling activities. Automate and schedule integration jobs using EPM. Automate integration scripting and scheduling using scripting languages. Diagnose and resolve issues related to data loads, mappings, and integration processes. Work closely with cross-functional teams, including finance and IT, to gather and analyze integration requirements. Manage testing, deployment, and migration activities for integration components. Ensure documentation is up to date and compliance with relevant audit and governance policies is maintained.
