VS01710 - OFSAA ETL / ODI Technical Consultant

E4 Software Services Pvt Ltd.; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

E4 Software Services Pvt Ltd. in Mumbai seeks an ODI-certified data integration specialist with 5+ years of hands-on experience to design and maintain ETL interfaces for OFSAA data models. You will work with EDW/source systems, deliver data extraction/ transformation, and support OFSAA applications such as ALM and LRM.

You will also optimize SQL/PL/SQL queries, tune ODI mappings, and support SIT/UAT and production processes while collaborating with business teams to ensure accurate data delivery.

Qualifications

• 5+ years of hands-on experience with ODI in financial services data models
• Design, development and maintenance of ETL interfaces using ODI
• Experience integrating data for OFSAA applications (ALM, LRM, FTP, LLFP, PFT)
• Strong SQL and PL/SQL skills including query tuning and debugging
• Experience with ODI mappings, packages/workflows, scheduling and performance tuning ETL processes
• Ability to map source-to-target data, validate data, and troubleshoot data-load issues

Responsibilities

• Design, develop and maintain ODI-based ETL interfaces for OFSAA data models
• Implement data integration for OFSAA applications including SIT/UAT and production support
• Troubleshoot data-load issues and optimize SQL/PL-SQL code
• Collaborate with business teams to translate data requirements into ODI solutions

Skills

ODI (Oracle Data Integrator)

SQL

PL/SQL

ETL design

Data integration

Production support

Tools

ODI

Job description

5+ years of hands-on experience in Oracle Data Integrator (ODI), preferably supporting OFSAA implementations and financial services data models.
Strong experience in designing, developing and maintaining ETL interfaces using ODI for extraction, transformation and loading of data from EDW/source systems into OFSAA.
Experience in integrating data for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT, including understanding of OFSAA staging/data structures.
Strong SQL and PL/SQL skills, including development, troubleshooting and optimization of queries and database processing.
Experience in ODI mappings, packages/workflows, scheduling, data transformations and performance tuning of ETL processes.
Ability to perform source-to-target data mapping, data validation, reconciliation and troubleshooting of data-load/integration issues.
Experience working with functional/business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions, including SIT/UAT and production support.