OFSAA ETL / ODI Technical Consultant

Delivery Centric Technologies; Mumbai; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Health insurance

Job summary

Delivery Centric Technologies in Mumbai, India, seeks a seasoned ODI specialist to design, develop and optimize ETL interfaces for OFSAA data models. The role focuses on data extraction, transformation, and loading from EDW/source systems into OFSAA.

Candidates should have 5+ years of hands-on ODI experience, strong SQL/PLSQL skills, and a track record of implementing SIT/UAT and production support for OFSAA integrations.

Qualifications

• 5+ years of hands-on experience in ODI
• Strong SQL and PL/SQL skills, including development and optimization
• Experience designing and maintaining ETL interfaces using ODI for OFSAA
• Experience in ODI mappings, workflows, scheduling and performance tuning
• Experience in data integration for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT
• Ability to translate data requirements into ODI/OFSAA solutions with SIT/UAT and production support

Responsibilities

• Design, develop and maintain ODI ETL interfaces for OFSAA data models
• Support OFSAA applications like ALM, LRM, FTP, LLFP and PFT with data integration
• Collaborate with business teams to understand data requirements and validate data loads
• Troubleshoot data-load issues, perform data reconciliation and optimize performance

Skills

ODI

OFSAA

ETL design

SQL/PLSQL

Data integration

Tools

ODI

OFSAA

Job description

Role & responsibilities

• 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.