ETL Developer

act digital; Lisboa; On-site; EUR 48,000 - 64,000; Full time

Job summary

act digital is seeking an ETL Developer to design, build, and optimize data integration solutions across enterprise systems. You will develop robust ETL processes, ensure data quality, and collaborate with business and technical stakeholders to translate requirements into scalable data architectures.

The role emphasizes Oracle SQL/PLSQL development, data workflows, and performance tuning, with a focus on reliability and governance.

Qualifications

• Mandatory: professional experience as ETL/Data Integration Developer or similar.
• Strong hands-on experience with Oracle Database.
• Advanced knowledge of PL/SQL and SQL development.
• Experience designing and developing ETL processes and data integration solutions.
• Strong analytical and problem-solving skills.
• Ability to translate business needs into technical solutions.
• Experience troubleshooting and optimizing complex data processes.

Responsibilities

• Design and implement reliable and scalable data integration solutions.
• Develop and optimize ETL processes that support business and operational needs.
• Ensure data quality, consistency, and performance across platforms.
• Collaborate with business and technical teams to deliver efficient data solutions.
• Contribute to the continuous improvement of data architecture and integration practices.

Skills

Oracle Database

PL/SQL

SQL Development

ETL / Data Integration

Data Quality

Problem Solving

Communication

Tools

ETL Tools

Oracle SQL Developer

Job description

We are looking for an ETL Developer to join our data and integration team, contributing to the design, development, and optimization of enterprise data solutions.

In this role, you will be responsible for building and maintaining robust ETL processes, ensuring data quality, reliability, and accessibility across systems. You will work closely with business and technical stakeholders to transform requirements into scalable data integration solutions that support reporting, analytics, and business-critical operations.

This is an excellent opportunity for someone who enjoys working with data, solving complex integration challenges, and contributing to modern data platforms.

As an ETL Developer, you will:

• Design and implement reliable and scalable data integration solutions.
• Develop and optimize ETL processes that support business and operational needs.
• Ensure data quality, consistency, and performance across platforms.
• Collaborate with business and technical teams to deliver efficient data solutions.
• Contribute to the continuous improvement of data architecture and integration practices.

ETL & Data Integration Development

• Design, develop, and maintain ETL processes and data integration workflows.
• Build and optimize data extraction, transformation, and loading processes.
• Develop and maintain ETL jobs using industry-standard tools and frameworks.
• Monitor and troubleshoot data integration processes to ensure reliability and performance.
• Ensure data quality and consistency throughout the data lifecycle.

Database Development

• Develop complex SQL and Oracle PL/SQL components, including:Procedures
• Packages
• Functions
• Triggers
• Views
• Queries
• Optimize database performance and data processing efficiency.
• Support data modeling and database design initiatives.

Solution Design & Analysis

• Analyze business requirements and translate them into technical solutions.
• Collaborate with stakeholders to define data integration strategies.
• Contribute to the design of scalable and maintainable data architectures.
• Identify opportunities for process automation and optimization.

Quality & Continuous Improvement

• Perform testing and validation of ETL processes and data transformations.
• Troubleshoot and resolve data-related issues and incidents.
• Participate in code reviews and technical discussions.
• Ensure compliance with data governance, security, and development standards.
• Contribute to improving development practices and delivery processes.

What We're Looking For

Mandatory Requirements

• Professional experience as an ETL Developer, Data Integration Developer, or similar role.
• Strong hands-on experience with Oracle Database.
• Advanced knowledge of PL/SQL and SQL development.
• Experience designing and developing ETL processes and data integration solutions.
• Strong analytical and problem-solving skills.
• Ability to understand business needs and translate them into technical solutions.
• Experience troubleshooting and optimizing complex data processes.

ETL Tools

Solid experience with at least one of the following: