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 solid 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 workplace.

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