Oracle Data Integrator (ODI) Developer/ Lead

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.

Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.

True innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [email protected] or by calling 1-888-404-2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

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 & SkillsMandatory

• 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
• 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
Bachelor's 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
Bachelor's 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
Master's Degree in Software Engineering, Data Engineering, Data Science, Computer Science, Information Systems, or related field