# Technical Consultant - OFSAA - PFT & FTP Implementation

**Company:** [Unison Group](http://jobs.workable.com/companies/deKpPhPMtQZga7XoPG1tSo.md)
**Location:** Singapore, Singapore
**Workplace:** on site
**Department:** Bharat

[Apply for this job](http://jobs.workable.com/view/3145d751-a8b9-4546-8101-dd8d11516a37)

## Description

**Key Responsibilities**

**1\. Technical Build & Configuration**

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

**2\. SQL/PLSQL Engineering**

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

**3\. Data Integration & ETL Engineering**

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

**4\. Batch Execution & Performance Support**

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

**5\. Testing & Quality Assurance**

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

**6\. Documentation & Deployment**

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

**7\. Cross-Functional Collaboration**

-   Work closely with functional EPM consultants to translate allocation logic, FTP methods, and profitability calculations into technical builds.
-   Collaborate with DBA, infrastructure, and data architecture teams on performance and deployment issues.
-   Provide guidance and mentoring to IC1/IC2 developers.

**Required Skills & Experience**

**Technical Skills**

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

**Performance & Architecture Awareness**

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

**Domain Understanding (Technical View)**

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

**Soft Skills**

-   Good analytical and problem-solving ability.
-   Strong communication and documentation skills.
-   A self-driven mindset with the ability to drive module delivery with minimal oversight.
-   Mentoring capability for junior technical consultants.

**Preferred Qualifications**

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

**Success Measures (KPIs)**

-   Quality and timeliness of module delivery.
-   Reduced defects and optimized rule run-times.
-   Accurate technical configurations aligned with business and performance requirements.
-   Smooth batch execution and stable deployments.
-   Positive feedback from IC4 leads, architects, and clients.