ODI/ETL TECHNICAL CONSULTANT

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