08 Sep
|
ZIDEA
|
Maharashtra
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 . 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 solid 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 (Maharashtra)
🏢 ZIDEA
📍 Maharashtra