PowerIT Services Pvt.ltd, Hiring! Full Time Technical Consultant in , Earn up to SGD 9,230.9 - Ricebowl

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:

o Allocation and driver rules

o Transfer pricing pools and pricing rules

o Transformation rules

o 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:

o Data transformation & enrichment

o Rule logic support

o Batch execution

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

Pay: $5,400.16 - $9,230.90 per month

Work Location: In person