- 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 partitions, indexes, and materialized views.
- Write and execute unit tests and SIT test plans.
- Validate profitability/FTP/Allocation rule outputs against functional requirements.
- Assist in defect triage, RCA, and support the UAT cycle.
- Prepare technical design documents, build workbooks,
and mapping specifications.
- Support deployment across environments (DEV → SIT → UAT → PROD).
- Maintain version-controlled build scripts and change management documentation.
- Robust hands-on SQL/PLSQL expertise (complex joins, aggregations, performance tuning).
- Experience configuring OFSAA Rule Framework components (allocation, FTP, PFT).
- Understanding of DIM/FCT metadata models and mapping concepts.
- Familiarity with ETL tools (ODI/Informatica) or PL/SQL-based data ingestion pipelines.
- Experience working with large data volumes and performance tuning concepts:
- Indexing strategy
- Partitions and subpartitions
- Column statistics and gathering plans
- Query execution plans
- Familiarity with OCI/Exadata environments (preferred).
- Understanding of financial/treasury data such as:
- GL & cost center hierarchies
- Product hierarchies
- Driver-based allocations
- Transfer pricing models
- Ability to convert functional logic into scalable technical execution.
- 4–7 years of experience in OFSAA EPM implementations.
- Hands-on experience in PFT/FTP/Allocations/Costing/MIS.
- Experience in multi-entity/multi-GL EPM implementations.
- Degree in Computer Science, Engineering, Information Systems, or equivalent