Technical Consultant - OFSAA EPM Suite (New Delhi)

Job Description We are seeking a skilled OFSAA EPM Technical Consultant with solid 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. Job Description We are seeking a skilled OFSAA EPM Technical Consultant with solid 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 exec