Job Description
We are seeking a skilled
OFSAA EPM Technical Consultant
with strong expertise in SQL/PLSQL and hands-on experience in implementing Profitability (PFT), Funds Transfer Pricing (FTP), and Allocation solutions. The role involves end-to-end development, configuration, and performance optimization of OFSAA Rule Framework components, along with close collaboration with functional and data teams.
Key Responsibilities
1. Technical Build & Configuration
Implement end-to-end EPM solutions for PFT, FTP, and Allocations under guidance of senior leads.
Configure OFSAA Rule Framework components:
Allocation and driver rules
Transfer pricing pools and pricing rules
Transformation rules
Profitability and costing logic
Configure and maintain metadata including DIM/FCT structures, hierarchies, and mappings.
2. SQL/PLSQL Engineering
Develop SQL/PLSQL scripts, procedures, functions, and packages for:
Data transformation and enrichment
Rule logic implementation
Batch execution processes
Exception handling
Optimize SQL queries for large datasets and improve execution performance.
3. Data Integration & ETL Engineering
Support and enhance data pipelines across staging, fact, and reporting layers.
Collaborate with ETL teams (ODI/Informatica) for data ingestion and mapping.
Perform data profiling, cleansing, reconciliation, and lineage documentation.
4. Batch Execution & Performance Support
Execute EPM batch cycles including PFT, FTP, and Allocations.
Analyze logs, SQL traces, and resolve performance bottlenecks.
Apply tuning techniques involving indexing, partitioning,



and materialized views.
5. Testing & Quality Assurance
Develop and execute unit test cases and SIT plans.
Validate outputs of profitability, FTP, and allocation rules.
Support defect resolution, root cause analysis, and UAT cycles.
6. Documentation & Deployment
Prepare technical design documents, mapping specifications, and build workbooks.
Support deployment across environments (DEV, SIT, UAT, PROD).
Maintain version-controlled scripts and change management records.
7. Cross-Functional Collaboration
Work closely with functional consultants to translate business logic into technical solutions.
Collaborate with DBA, infrastructure, and data architecture teams.
Mentor junior developers and provide technical guidance.
Required Skills & Experience
Technical Skills
Solid expertise in SQL/PLSQL including complex queries and performance tuning.
Hands-on experience with OFSAA Rule Framework (PFT, FTP, Allocations).
Knowledge of DIM/FCT data models and metadata configuration.
Experience with ETL tools (ODI/Informatica) or PL/SQL-based pipelines.
Performance & Architecture Awareness
Experience handling large data volumes with focus on:
Indexing strategies
Table partitioning
Query execution plans
Statistics gathering
Exposure to OCI/Exadata environments is a plus.
Domain Knowledge
Understanding of financial data concepts:
General Ledger and cost center hierarchies
Product hierarchies
Driver-based allocations
Transfer pricing models
Ability to translate functional requirements into scalable technical designs.

📌 Technical Consultant - Ofsaa Epm Suite (Delhi)
🏢 Unison Group
📍 Delhi