Description
We are looking for an experienced Data Engineer / Oracle Data Integrator (ODI) Developer to design, develop, optimize, and support enterprise Data Warehouse solutions using Oracle Data Integrator (ODI), Oracle Database, and PL/SQL.

The ideal candidate has strong experience building scalable ETL/ELT pipelines, optimizing database performance, developing reusable integration frameworks, and partnering with business stakeholders to translate requirements into technical solutions.

This role requires excellent analytical skills, hands-on Oracle database expertise, and the ability to deliver high-quality solutions in a quick-paced enterprise environment.

Responsibilities
Key Responsibilities
- Design, develop, test, deploy, and maintain enterprise ETL/ELT solutions using Oracle Data Integrator (ODI).
- Develop reusable mappings, load plans, workflows, and automation frameworks.
- Design and optimize Oracle SQL and PL/SQL packages, procedures, functions, triggers, and views.
- Implement data quality, auditing, exception handling, error recovery, and logging frameworks.




- Optimize ETL jobs, SQL queries, indexing, and partitioning strategies for high performance.
- Build and maintain scalable data warehouse schemas and validate data integrity.
- Collaborate with business users to convert business requirements into technical specifications.
- Manage code using Git and participate in deployment, testing, and production support activities.

Qualifications & Skills
Mandatory
- Bachelor's Degree in Computer Science, Information Systems, Software Engineering or related discipline (or equivalent experience)
- 4+ years of Oracle Data Integrator (ODI) development experience
- End-to-end Data Warehouse implementation experience
- Oracle SQL and PL/SQL expertise
- ETL / ELT architecture and implementation
- ODI Repositories, Designer, Operator, Agents, Load Plans
- Knowledge Modules (KM) customization
- Performance tuning
- Data modelling
- Oracle Database development
- G

📌 Oracle Data Integrator (Bengaluru)
🏢 Oracle
📍 Bengaluru