Job Description

Role & responsibilities 1. Integration Development: Design, build, and maintain data integrations between Oracle EPM Cloud and upstream systems such as Oracle Fusion (AR/AP/Cash Management), Workday, Salesforce, Trovata, and BigQuery. Develop and manage automated ETL/ELT pipelines and APIs to feed structured data into EPM Predictive Planning modules. 2. Data Mapping & Transformation: Translate business and functional requirements into data mapping and transformation logic for cash flow inputs (inflows, outflows, forecast drivers). Ensure accurate alignment between source data formats and EPM model requirements. 3. Workflow Automation & Scheduling: Implement integration workflows using tools like Oracle Data Integration (ODI), Oracle Data Management (DM), Oracle Integration Cloud (OIC), Informatica, Cloud Composer (Airflow), or dbt. Schedule and monitor daily/weekly batch jobs, ensuring data freshness and consistency for forecasting cycles. 4. Error Handling & Performance Optimization: Build validation checks, exception logging, and recovery mechanisms for integration failures. Optimize integration performance for high-volume financial data and time-sensitive reporting cycles. 5. Documentation & Collaboration: Maintain technical documentation for integration workflows, data models, APIs, and troubleshooting steps. Work closely with EPM consultants, business analysts, and finance teams to align on integration logic and testing. Preferred candidate profile Exposure to Oracle EPM Cloud (especially Planning and Predictive Planning modules). Understanding of financial forecasting and cash flow modeling concepts. Experience in cloud environments (OCI, GCP, AWS). DevOps tools for CI/CD in data pipelines (e.g., Git, Jenkins, Terraform for infrastructure-as-code)