Job Title: Business Intelligence Developer
Description
We are seeking a skilled Business Intelligence Developer to join our team. The ideal candidate will have experience with Informatica PowerCenter and Informatica Cloud Data Integration (CDI), as well as strong analytical, problem-solving, and troubleshooting skills.
Key Responsibilities:
* Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter and CDI;
* Lead and participate in end-to-end data migration projects from on-premise systems to cloud platforms using CDI;
* Optimize existing ETL processes to improve performance, scalability, and data reliability;
* Develop and implement data validation and testing strategies to ensure accuracy, consistency, and integrity of data;
* Monitor and support ETL operations in production, ensuring timely and accurate data delivery;
* Collaborate with data architects and cross-functional teams to define data models, data integration strategies, and ETL standards;
* Create and maintain comprehensive technical documentation for ETL processes and migration strategies;
Requirements
The successful candidate will possess the following qualifications:
* Proven experience (3–5+ years) as an ETL Developer working with Informatica PowerCenter;
* Hands-on experience with Informatica Cloud Data Integration (CDI), including development of cloud-based mappings and synchronization tasks;
* Demonstrated experience in data migration projects, particularly from on-premise to cloud platforms;
* Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT principles;
* Strong proficiency in SQL and experience with relational databases such as Oracle and SQL Server;
* Experience with scripting languages (e.g., Python, Shell scripting) is a plus;
* Excellent analytical, problem-solving, and troubleshooting skills;
* Written and verbal communication skills in English (B2 or above);
* Candidates must be based in Portugal and possess either European citizenship or a valid Work Visa/Residence Card – mandatory requirement;
Benefits
We offer a range of benefits to our employees, including:
* Health Insurance;
* Feedback&Coffee – the system that includes Aubay's Performance Management Cycle, with regular moments of feedback and the Career Progression Model;
What We Offer
Our company culture is based on values such as transparency, team spirit, regular feedback, and continuous learning. We believe in providing a supportive and collaborative work environment that encourages growth and development.