ODI/ETL TECHNICAL CONSULTANT
Posted Updated
Summary
An ODI/ETL technical consultant in Mumbai who designs, builds and maintains Oracle Data Integrator ETL interfaces integrating EDW/source systems with OFSAA banking modules (ALM, LRM, FTP, LLFP, PFT), including SQL/PL-SQL optimization, data validation and reconciliation. Requires 5+ years' experience; CTC ₹15 LPA.
WE ARE HIRING | ODI/ETL TECHNICAL CONSULTANT
Location: Mumbai
Experience: 5+ Years
CTC: ₹15 LPA
Work Mode: As per project requirement
ROLE OVERVIEW
We are looking for an experienced ODI/ETL Technical Consultant with strong expertise in Oracle Data Integrator (ODI), preferably with OFSAA implementation experience and financial services data models.
KEY RESPONSIBILITIES
• Design, develop and maintain ETL interfaces using ODI.
• Integrate EDW/source systems with OFSAA applications.
• Work on OFSAA modules such as ALM, LRM, FTP, LLFP and PFT.
• Develop and optimize SQL/PL-SQL queries and database processes.
• Create and manage ODI mappings, packages, workflows and schedules.
• Perform source-to-target mapping, data validation and reconciliation.
• Troubleshoot data-load and integration issues and improve ETL performance.
• Collaborate with functional/business teams on data requirements.
• Support SIT, UAT and production environments.
REQUIRED SKILLS
• Oracle Data Integrator (ODI)
• ETL Development
• OFSAA
• Oracle Database
• SQL
• PL/SQL
• Data Integration
• Data Mapping
• Data Validation & Reconciliation
• ODI Mappings
• ODI Packages & Workflows
• ETL Performance Tuning
• OFSAA ALM
• OFSAA LRM
• OFSAA FTP
• OFSAA LLFP
• OFSAA PFT