Job DescriptionJob Role- OFSAA ETL / ODI Technical Consultant
nLocation: Mumbai
nWork Arrangement: On-site
nExperience: 5+ years
nRole Overview:
nWe 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.
nKey Responsibilities:
n
- n
- Design, develop, and maintain ETL interfaces using ODI for extraction, transformation, and loading of data from EDW/source systems into OFSAA.n
- Work on ODI mappings, packages/workflows, scheduling, data transformations, and ETL performance tuning.n
- Perform source-to-target data mapping, data validation, reconciliation, and troubleshooting of data-load and integration issues.n
- Integrate data for OFSAA applications such as ALM, LRM, FTP, LLFP, and PFT.n
- Work with functional and business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions.n
- Support SIT/UAT and production activities.n
nRequired Skills & Qualifications:
n
- n
- 5+ years of hands-on experience in Oracle Data Integrator (ODI).n
- Robust experience in ETL development and data integration using ODI.n
- Strong SQL and PL/SQL skills, including development, troubleshooting, and optimization.n
- Experience with ODI mappings, packages/workflows, scheduling, and data transformations.n
- Strong understanding of source-to-target data mapping, data validation, and reconciliation.n
- Experience troubleshooting data-load and integration issues.n
nGood to Have:
n
- n
- Experience supporting OFSAA implementations.n
- Experience with OFSAA applications such as ALM, LRM, FTP, LLFP, and PFT.n
- Understanding of OFSAA staging and data structures.n
- Experience working with financial services data models.n
-
📌 OFSAA ETL (Raigarh)
🏢 ZIDEA
📍 Raigarh