Engenheiro de Dados Oracle | ETL & SQL de Alta Performance

Genesis Digital Solutions; Lisboa; Hybrid; EUR 42,000 - 70,000; Full time

Job summary

Genesis Digital Solutions is seeking a Data Engineer in Lisbon, Portugal. You will design, develop and optimize data processing solutions using Oracle databases and ETL pipelines within an Agile environment.

You will collaborate with cross-functional teams, ensure data quality and performance, and contribute to continuous delivery and data-driven decision making for clients across industries.

Qualifications

• Advanced knowledge of relational databases, particularly Oracle 12c or later.
• Strong SQL skills, including CRUD operations, data modelling, transaction management, and performance tuning.
• Strong proficiency in PL/SQL.
• Experience developing and maintaining ETL processes.
• Experience with Oracle Data Integrator (ODI) is a plus.
• Strong understanding of multidimensional data modelling.
• Advanced troubleshooting and problem-solving capabilities.
• Experience working in Scrum and Agile environments.
• Knowledge of TDD and BDD practices.
• Knowledge of Continuous Delivery principles.
• Ability to work autonomously while collaborating effectively with the team.
• Strong communication skills, with the ability to adapt technical explanations to different audiences.
• Proactive, delivery-oriented mindset, with a strong sense of ownership and accountability.

Responsibilities

• Develop, maintain, and optimize data processing solutions using Oracle databases.
• Design and implement ETL processes to extract, transform, and load data from different sources.
• Develop complex SQL queries and PL/SQL procedures to support data processing and business requirements.
• Work with relational databases, data models, CRUD operations, and transactional processes.
• Apply SQL performance tuning techniques to improve query efficiency and database performance.
• Implement and maintain data models based on multidimensional modelling principles.
• Perform advanced troubleshooting, investigate data issues, and identify root causes.
• Analyse data to ensure accuracy, consistency, and reliability.
• Collaborate with cross-functional teams using Scrum and Agile methodologies.
• Apply testing practices, including Test-Driven Development (TDD) and Behaviour-Driven Development (BDD).
• Contribute to Continuous Delivery practices and the continuous improvement of development workflows.
• Work closely with team members and clients to clarify requirements, manage expectations, and ensure successful delivery.

Skills

Oracle 12c

SQL

PL/SQL

ETL

Data modelling

Multidimensional modelling

Troubleshooting

Scrum/Agile

TDD/BDD

CD/CI

Stakeholder management

Communication

Tools

ODI

Job description

Genesis Digital Solutions is seeking a Data Engineer in Lisbon, Portugal. You will design, develop and optimize data processing solutions using Oracle databases and ETL pipelines within an Agile environment.

You will collaborate with cross-functional teams, ensure data quality and performance, and contribute to continuous delivery and data-driven decision making for clients across industries.