Technical Consultant - OFSAA - PFT & FTP Implementation

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 → ...