ODI Specialist (ETL)

TL;DR

ODI Specialist (ETL/Oracle): Developing and optimizing ETL processes using Oracle Data Integrator (ODI) with an accent on relational databases and multidimensional modeling. Focus on designing scalable data pipelines, SQL tuning, and implementing Continuous Delivery practices.

Location: Hybrid, Lisbon, Portugal

Company

hirify.global is a specialized IT consulting partner with 18 years of experience helping clients make strategic decisions in a fast-moving market.

What you will do

• Develop and maintain complex ETL processes, primarily using Oracle Data Integrator (ODI).
• Design and optimize relational database structures in Oracle 12c or higher.
• Write advanced SQL and PL/SQL scripts for data transformation and transactional logic.
• Implement multidimensional modeling concepts to support data warehousing.
• Collaborate within a Scrum-based environment to deliver high-quality data solutions.
• Integrate TDD/BDD and Continuous Delivery practices into the development lifecycle.

Requirements

• 3+ years of professional experience in ETL development.
• Advanced knowledge of Oracle 12c+ and proficiency in PL/SQL.
• Strong expertise in SQL, including CRUD, data models, and performance tuning.
• Experience with multidimensional modeling and advanced data analysis.
• Familiarity with Scrum methodology, TDD, BDD, and Continuous Delivery.
• Must be based in or able to work hybrid in Lisbon, Portugal.

Culture & Benefits

• Permanent no-term full-time contract with health insurance.
• 26 days of paid time off (22 standard days plus 4 annual bonus days).
• Meal allowance provided via Coverflex card.
• Annual training budget to support professional growth.
• Referral bonuses and a team-oriented, agile company culture.