Technical Consultant - OFSAA EPM Suite

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

• 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.