Job Role- OFSAA ETL / ODI Technical Consultant

Location: Mumbai

Work Arrangement: On-site

Experience: 5+ years

Role Overview:

We are looking for an experienced OFSAA ETL / ODI Technical Consultant with strong hands-on experience in Oracle Data Integrator (ODI) , preferably supporting OFSAA implementations and financial services data models . The role involves designing, developing, and maintaining ETL interfaces and supporting data integration between EDW/source systems and OFSAA.

Key Responsibilities:
Design, develop, and maintain ETL interfaces using ODI for extraction, transformation, and loading of data from EDW/source systems into OFSAA.
Work on ODI mappings, packages/workflows, scheduling, data transformations, and ETL performance tuning .
Perform source-to-target data mapping, data validation, reconciliation, and troubleshooting of data-load and integration issues.
Integrate data for OFSAA applications such as ALM, LRM, FTP, LLFP, and PFT .
Work with functional and business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions .
Support SIT/UAT and production activities.

Required Skills & Qualifications:
5+ years of hands-on experience in Oracle Data Integrator (ODI).




Robust experience in ETL development and data integration using ODI .
Strong SQL and PL/SQL skills, including development, troubleshooting, and optimization.
Experience with ODI mappings, packages/workflows, scheduling, and data transformations .
Solid understanding of source-to-target data mapping, data validation, and reconciliation .
Experience troubleshooting data-load and integration issues .

Good to Have:
Experience supporting OFSAA implementations .
Experience with OFSAA applications such as ALM, LRM, FTP, LLFP, and PFT .
Understanding of OFSAA staging and data structures .
Experience working with financial services data models .
Experience with SIT/UAT and production support .

Ideal Candidate:
Has robust hands-on experience in ODI, ETL, SQL, and PL/SQL .
Ideally has experience working with OFSAA implementations and financial services data .
Comfortable working with functional/business and technical teams .
Strong in data mapping, validation, reconciliation, troubleshooting, and ETL performance tuning .
Able to translate business and data requirements into effective ODI/OFSAA integration solutions .

If interested, share your CV at

📌 Ofsaa Etl / Odi Technical Consultant Mumbai
🏢 ZIDEA
📍 Mumbai