Technical Consultant - OFSAA EPM Suite at Unison Group

New Delhi, delhi, India -

Full Time

Start Date

Immediate

Expiry Date

22 Jul, 26

Salary

0.0

Posted On

23 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, PL/SQL, OFSAA, EPM, Profitability, Funds Transfer Pricing, Allocation, Data Transformation, ETL, ODI, Informatica, Performance Tuning, Metadata Configuration, Financial Data Concepts, Database Management, Technical Documentation

Industry

Business Consulting and Services

Description

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 Responsibilities1. 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 & ExperienceTechnical Skills Strong 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.

Responsibilities

The consultant will implement and configure OFSAA EPM solutions, including PFT, FTP, and allocation rules, while managing metadata and data integration. They are also responsible for performance optimization, batch execution, and collaborating with cross-functional teams to translate business logic into technical designs.