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.