Job Description
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. Run EPM batch cycles including PFT/FTP/Allocations. Analyze logs, SQL traces, and performance bottlenecks and apply tuning fixes. Understand performance optimization for par...