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