ZIDEA
Website:
zidea.tech
Company:
https://www.linkedin.com/company/zidea
Seniority: Mid-Senior level
Industries: IT Services and IT Consulting
Job details:
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.
Click on Apply to know more.
