Oracle Data Integrator (ODI) Developer Lead
Job Location:
Monthly Salary:
Posted on:
Vacancies:
Department:
Job Summary
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 fast-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
- Bachelors 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
- Git version control
- Strong communication skills
- Experience translating business requirements into technical solutions
Good-to-Have
- Python scripting
- Shell scripting
- AI / Generative AI awareness
- AI-assisted Data Engineering tools
- Financial Services domain experience
- Experience working in global enterprise environments
Self-Assessment Questions
- Do I have 4 years of hands-on Oracle Data Integrator (ODI) development experience
- Have I independently delivered end-to-end Data Warehouse implementations
- Am I comfortable developing advanced Oracle SQL and PL/SQL solutions
- Have I optimized ETL workflows for performance and scalability
- Can I translate business requirements into technical ETL designs with minimal supervision
Qualifications
Minimum Job Qualifications
Education and/or Experience:
5 years of experience in software engineering data engineering data science computer science or information systems
OR
Bachelors Degree in Software Engineering Data Science Computer Science Information Systems or related field AND 1 years of experience in software engineering data engineering data science computer science or information systems
Job Skills:
Applied Algorithm Engineering Demonstrated skill in designing analyzing and optimizing algorithms for efficiency and scalability.
Data Management Demonstrated ability in or knowledge of data management including designing operationalizing securing and monitoring data pipelines.
Software Engineering Demonstrated proficiency in all phases of software engineering and development.
Programming Demonstrated proficiency in major programming languages to deliver effective software solutions.
Automation Demonstrated ability in or knowledge of automation including designing implementing and managing automated tools processes or systems to streamline operations.
Preferred Job Qualifications
Education and/or Experience:
6 years of experience in software engineering data engineering data science computer science or information systems
OR
Bachelors Degree in Software Engineering Data Science Computer Science Information Systems or related field AND 2 years of experience in software engineering data engineering data science computer science or information systems
OR
Masters Degree in Software Engineering Data Engineering Data Science Computer Science Information Systems or related field
Required Experience:
IC
About Company
As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when eve ... View more
