Job Description
We are seeking a skilled ETL Developer to join our team. As a key member, you will be responsible for delivering and maintaining data integration activities, designing, developing, and maintaining ETL workflows and mappings using Informatica PowerCenter (on-premises) and Informatica Cloud Data Integration (CDI/CDI-PC).
* Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter and CDI/CDI-PC.
* Lead and participate in data migration projects from on-premise systems to cloud platforms, including design, testing, documentation, and implementation.
* Implement complex ETL jobs and workflows, ensuring performance, scalability, and data reliability.
* Develop and apply data validation and testing strategies to ensure accuracy, consistency, and integrity of data.
Requirements
* Proven experience (3–5+ years) as an ETL Developer working with Informatica PowerCenter and Informatica CDI/CDI-PC.
* Hands-on experience in migration projects from Informatica legacy to Informatica Cloud (CDI/CDI-PC).
* Solid expertise in Unix scripting.
* Strong proficiency in SQL and experience with databases such as Oracle, SQL Server, and PostgreSQL.
Aubay Portugal is a multinational company with offices in Lisbon and Porto, specializing in management, implementation, development, and maintenance of information systems.