Job Description
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). - 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. - Robust 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 st

📌 OFSAA ETL (Mumbai)
🏢 ZIDEA
📍 Mumbai