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 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.
Strong 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
This job post has been translated by AI and may contain minor differences or errors.
