Position Overview
- Implement end-to-end EPM solutions for PFT/FTP/Allocations under guidance of IC4 leads.
- Configure OFSAA Rule Framework components including:
- Allocation and driver rules
- Transfer pricing pools and pricing rules
- Transformation rules
- Profitability and costing calculation logic
- Configure and maintain metadata (DIM/FCT structures), hierarchies, and mapping rules.
- Develop SQL/PLSQL scripts, packages, functions, and procedures for:
- Data transformation & enrichment
- Rule logic support
- Batch execution
- Exception handling
- Optimize SQL logic for medium-to-large workloads and improve execution efficiency.
- Support and enhance data pipelines (STG - FCT - Reporting layer).
- Work with ETL engineers (ODI/Informatica) to implement mapping and ingestion logic.
- Perform data profiling, cleansing, reconciliation, and lineage documentation.