ETL Developer — Senior

What You Will Do on a Daily Basis

Development & Maintenance

• Design, develop, and maintain ETL processes and data integration workflows across multiple source and target systems.

• Develop complex Oracle PL/SQL procedures, packages, functions, triggers, and SQL queries.

• Build and optimize data extraction, transformation, and loading processes for performance and scalability.

• Work with ODI, DataStage, or Informatica PowerCenter to develop, tune, and maintain ETL workflows.

Analysis & Design

• Analyze business and technical requirements and translate them into scalable, maintainable data solutions.

• Design data models and mapping specifications in collaboration with data architects and business stakeholders.

• Document ETL processes, data flows, and technical specifications.

Quality & Support

• Monitor, troubleshoot, and resolve issues in ETL jobs and data pipelines, ensuring data quality and integrity.

• Lead testing and validation of ETL processes before deployment.

• Provide production support and root-cause analysis for complex data-related incidents.

Collaboration

• Work closely with business analysts, DBAs, and other developers to ensure alignment between technical solutions and business needs.

• Lead code reviews and drive best practices for ETL development.

• Mentor junior team members.

Your Key Skills

• Solid professional experience as an ETL Developer / Data Integration Developer.

• Strong hands-on experience with Oracle Database and PL/SQL (procedures, packages, functions, triggers).

• Solid experience with at least one ETL tool: ODI, DataStage, or Informatica PowerCenter.

• Proven experience developing, optimizing, and troubleshooting complex ETL processes.

• Strong understanding of data warehousing concepts and data modeling.

• Strong analytical and problem-solving skills.

• Ability to work independently, manage priorities, and mentor others.

• Strong communication skills, able to work with both technical and business stakeholders.

• Fluent English (written and spoken); Portuguese is a plus.

Location & Schedule

• Hybrid, 2x/week — Amoreiras

What can you expect from us?

Mind-blowing workplace culture. You will be integrated in a professional, dynamic and collaborative team.

100% Remote opportunities

We want you to have the flexibility to work where you feel most comfortable and productive.

International Career

• You can expect professional growth and to be connect with the world.

• We are represented in Portugal, Belgium, Luxembourg, and Denmark.

• And with projects in many other countries: Netherlands, Luxembourg, Singapore and in the United States of America (and a lot more is coming…)

Extra Benefits & Perks

If you wish to work with us and you are outside European Union (good news…) we are a Tech Visa Company, We will help!

As a plus, we provide Health and Life Insurance.