OFSAA ODI/ETL Consultant

Unison Group; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Unison Group in Mumbai is seeking an OFSAA ODI/ETL Technical Consultant with 5+ years of Oracle OFSAA experience to lead ODI/ETL development, manage data mappings, interfaces and data integration across systems.

The role requires hands-on OFSAA data model, staging areas, data loading, metadata and batch processing, plus strong Oracle SQL/PLSQL for transformations and performance tuning. Familiarity with OFSAA architecture and EPM/ERM, ALM or Risk is a plus.

Qualifications

• 5+ years of experience with Oracle OFSAA and ODI/ETL development.
• Strong knowledge of ODI, ETL processes, data mappings, interfaces and data integration.
• Hands-on experience with OFSAA data model, staging areas, data loading and batch processing.
• Expertise in Oracle SQL/PLSQL, data transformation and performance tuning.
• Experience developing and troubleshooting ODI mappings, packages and workflows.
• Understanding OFSAA architecture and integration with source/target systems.
• Familiarity with OFSAA EPM/ERM, ALM, Risk or LLFP is a plus.

Skills

Oracle OFSAA

ODI/ETL

Data Integration

SQL/PLSQL

Performance Tuning

Tools

ODI

ETL

OFSAA data model

Interfaces & Workflows

Metadata Management

Job description

Role: OFSAA ODI/ETL Technical Consultant

• 5+ years of experience in Oracle OFSAA with strong hands-on experience in ODI/ETL development.
• Strong knowledge of Oracle Data Integrator (ODI), ETL processes, data mappings, interfaces and data integration.
• Hands-on experience with OFSAA data model, staging areas, data loading, metadata and batch processing.
• Strong expertise in Oracle SQL/PLSQL, data transformation, data validation and performance tuning.
• Experience developing and troubleshooting ODI mappings, packages, procedures, interfaces and workflows.
• Good understanding of OFSAA architecture and integration with source/target systems.
• Experience in implementation, deployment, testing, production support and issue resolution.
• Knowledge of OFSAA EPM/ERM, ALM, Risk or LLFP is an added advantage.