Job Description
Key Responsibilities 1. Technical Build & Configuration
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.
2. SQL/PLSQL Engineering
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.
3. Data Integration & ETL Engineering
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.<...
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.
2. SQL/PLSQL Engineering
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.
3. Data Integration & ETL Engineering
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.<...