ODI Specialist (ETL)

TL;DR

ODI Specialist (ETL): Developing and optimizing ETL processes using Oracle Data Integrator and relational databases with an accent on SQL tuning and PL/SQL development. Focus on multidimensional modeling, implementing TDD/BDD practices, and ensuring efficient data flow within a Scrum environment.

Location: Hybrid, Lisbon, Portugal

Company

Specialized IT consulting partner with 18 years of experience helping clients make the right decisions in a fast-moving market.

What you will do

• Develop and maintain complex ETL processes, primarily using ODI.
• Design and optimize relational database schemas and data models for Oracle 12c or higher.
• Write and tune high-performance SQL and PL/SQL scripts, focusing on transactional logic and CRUD operations.
• Implement multidimensional modeling concepts for data architecture.
• Collaborate within a Scrum team to deliver iterative technical improvements.
• Apply TDD/BDD and Continuous Delivery principles to the development lifecycle.

Requirements

• 3+ years of professional experience in ETL development.
• Advanced knowledge of Oracle 12c or higher.
• Proficiency in SQL (tuning, data models) and PL/SQL.
• Experience with multidimensional modeling concepts.
• Must be based in or able to work in Lisbon, Portugal (Hybrid).
• Knowledge of Scrum methodology, TDD/BDD, and Continuous Delivery.

Culture & Benefits

• Permanent full-time contract with comprehensive health insurance.
• 26 days of total paid time off (22 standard days plus 4 extra annual days).
• Meal allowance provided via Coverflex.
• Annual training budget for professional development.
• Referral bonuses and various flexible discount options.
• Team-oriented culture within a dynamically growing international company.