Job Role- OFSAA ETL / ODI Technical Consultant
Location: Mumbai
Work Arrangement: In office
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).
Strong 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.
Strong 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 strong hands-on experience in ODI, ETL, SQL, and

📌 OFSAA ETL (Mumbai)
🏢 ZIDEA
📍 Mumbai