Designs, develops, and maintains ODI ETL interfaces integrating enterprise data warehouses and source systems with OFSAA applications. Responsibilities include creating mappings, packages, workflows, and schedules; developing SQL and PL/SQL processes; performing data validation and reconciliation; troubleshooting data loads; optimizing ETL performance; and supporting SIT, UAT, and production environments while collaborating with business teams.
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
Similar Jobs
Financial Services
This is a test requisition with no actual job responsibilities, qualifications, technologies, compensation details, or application requirements provided.
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Leads multiple software engineering teams through new product development from concept to implementation. Provides technical and strategic leadership across architecture, Java and Spring-based applications, cloud-native systems, microservices, CI/CD, quality initiatives, automation, and real-time platforms. Manages stakeholders, project metrics, cross-location coordination, business execution, team development, and strategic technology direction while ensuring consistent delivery and security practices.
Top Skills:
AICi/CdDigital Native ArchitectureJavaMicroservicesPivotal Cloud FoundryReal-Time Online SystemsScaled Agile FrameworkSpring BootSpring Framework
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Designs, develops, tests, deploys, and maintains secure software solutions across the full SDLC. Leads technical solution planning, production support, incident remediation, technology evaluations, and proof-of-concept initiatives. Creates technical documentation, ensures testing and quality compliance, coordinates offshore development, supports vendor collaboration, and mentors team members through training and knowledge transfer.
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
