ODI Developer (Oracle Data Integration)

Empowered by our motto, "Making Data Matter", Keyrus stands at the forefront of global consultancy in Data & Analytics, AI & Machine Learning, and Digital Transformation. With a presence in 27 countries across 4 continents, we're on a mission to elevate the impact of data.

We are data experts, guiding our clients through their data journey regardless of their level of maturity in analytics. As an end-to-end partner, we address varied challenges that our clients face, from Advanced Analytics, Cloud, Data Governance, Visualisation to Enterprise Performance Management, from advisory to delivery.

With more than 3200 employees in all corners of the world, Keyrus is dedicated to helping businesses taking advantage of the Data and Digital paradigm to enhance their performance, facilitating, and accelerating their transformation, and generating new drivers of growth, competitiveness, and sustainability.

Job Summary 

Keyrus is looking for an experienced ODI Developer to join our team and support enterprise data integration projects across a variety of industries. 

You’ll play a central role in designing and maintaining robust, scalable ETL/ELT pipelines using Oracle Data Integrator (ODI), helping organisations modernise their data platforms and enhance data accessibility.

Whether you’re an experienced freelancer or seeking a permanent opportunity, this role offers the chance to contribute to impactful data initiatives within a dynamic, tech-driven environment.

• Location: Portugal (On-site availability for select projects required)
• Start date: September 

Note: All applications/CV’s must be submitted in English.

Key Responsibilities

• Design, develop, and maintain ETL/ELT processes using Oracle Data Integrator (ODI)
• Integrate data from multiple on-prem and cloud-based sources into centralised data warehouses or lakes
• Optimise performance of data integration jobs, including tuning and parallelisation strategies
• Ensure data quality, consistency, and compliance with governance standards
• Collaborate with business analysts, data architects, and other stakeholders to gather requirements and deliver end-to-end data solutions
• Monitor, troubleshoot, and maintain ODI jobs in production environments
• Document technical specifications and create support materials for ongoing maintenance
• Participate in code reviews, testing, and deployment cycles

Requirements for the role 

• 4+ years of hands-on experience with Oracle Data Integrator (ODI) (preferably ODI 12c)
• Strong experience in ETL/ELT design and implementation, including data modelling fundamentals
• Solid understanding of Oracle databases and PL/SQL
• Familiarity with data warehousing concepts, star/snowflake schemas, and staging architectures
• Experience working with data integration between Oracle and non-Oracle sources
• Good understanding of performance tuning and error handling within ODI workflows
• Proficiency in SQL for querying and validating datasets
• Strong communication and problem-solving skills, with the ability to work independently or in cross-functional teams
• Fluent in English
• Must be a Portuguese or European citizen or have a work permit for Portugal

What we offer at Keyrus Portugal:

• Competitive salary based on your skills & experience and according to the Data market practice
• Meal allowance of €8.32 per day
• Flexible benefits option
• Private Medical Insurance
• 22 days of annual leave (increasing every 3 years up to a maximum of 25 days)
• Training Program through KLX (Keyrus Learning Experience) Platform

Why Keyrus?

Joining Keyrus means joining a market leader in the Data Intelligence field and an (inter)national player in Management Consultancy and Digital Experience.

Keyrus Portugal operates on five guiding pillars that shape our approach to work and collaboration – Diversity; Trust; Flexibility; Ownership & Innovation - we're dedicated to cultivating a team as diverse as the challenges we take on. 

We embrace and celebrate the rich variety of backgrounds, perspectives, and talents that each individual brings. We firmly believe that diversity fuels innovation, ignites creativity, and propels us towards greatness. 

Regardless of race, ethnicity, gender, sexual orientation, disability, age, or any other dimension of diversity, everyone is not only welcome but valued here. 

Join us in shaping a future where everyone can thrive!