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
Develop and support full-stack, data-enabled applications using Python, FastAPI, React.js, Databricks, SQLite, and SharePoint. Build REST APIs, front-end components, data workflows, integrations, and persistence layers while contributing to testing, documentation, CI/CD, deployments, observability, troubleshooting, and secure coding. Collaborate with stakeholders to clarify requirements, estimate work, deliver iteratively, and maintain operational runbooks.
Top Skills:
SparkCi/CdDatabricksFastapiGitJavaScriptOpenapiPythonReactRest ApisSharepointSQLSqliteSwaggerTypescript
Financial Services
Supports day-to-day transportation operations, including nodal and cab services. Coordinates vendors, prepares management and KPI reports, tracks compliance and operational metrics, resolves issues, and supports continuous improvement focused on service quality, safety, and cost efficiency. Partners with stakeholders and uses technology and data to improve service delivery.
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Designs and maintains scalable UI and API automation frameworks using Playwright and TypeScript. Tests AI-powered applications, LLMs, agentic workflows, prompts, and autonomous agent behavior. Develops evaluation frameworks for response quality, accuracy, safety, reliability, and performance. Automates functional, regression, integration, smoke, and end-to-end testing, integrates suites into CI/CD pipelines, tracks defects, prepares quality metrics, and mentors junior QA engineers.
Top Skills:
Agentic AiAi AgentsAi Evaluation FrameworksCi/CdLarge Language Models (Llms)PlaywrightRest ApisTypescript
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.
