Live opening · Posted 1 day ago
The key details from the original listing.
Live timing from JobBeeper.
Description supplied by the original job listing.
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 strong 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 rudrakshi.jain@zidea.tech.
Work arrangement
No
Recently tracked roles with full details and direct application links.