The OFSAA EPM Consultant implements EPM solutions, configures OFSAA components, develops SQL scripts, optimizes performance, and supports data processing and validation efforts.
- 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.
Requirements
- 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
Top Skills
Epm
Informatica
Odi
Ofsaa
Plsql
SQL
Similar Jobs
Information Technology • Consulting
The Technical Consultant designs, develops, and configures components across OFSAA EPM suite, focusing on profitability, allocation, and reporting. Responsibilities include SQL scripting, ETL support, performance optimization, testing, and cross-functional collaboration to ensure effective EPM solutions.
Top Skills:
InformaticaOdiOfsaaPlsqlSQL
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
The Aircraft Systems Engineer troubleshoots airplane systems issues, develops engineering solutions, collaborates with customers, and ensures compliance with Boeing standards.
Top Skills:
Avionics SystemsBoeing Aircraft Hydro-Mechanical SystemsElectrical SystemsEnvironmental Control SystemsFlight Controls SystemsFluid SystemsLanding Gear SystemsMS OfficePropulsion And Fuel Systems
Information Technology • Software • Financial Services • Big Data Analytics
Develop mathematical models and trading strategies, back test trading models, conduct research and statistical analysis for monetization systems.
Top Skills:
C++PythonR
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
