Senior Informatica ETL Engineer - PowerCenter (Lisbon)

Hexa Consulting; Lisboa; Híbrido; EUR 60 000 - 90 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid in Lisbon

Private health insurance

Mental health support

Childcare vouchers

Learning & certifications

Team empowerment culture

Exposure to QA/InfoSec

Resumo da oferta

Hexa Consulting is seeking a Senior Informatica ETL Developer to join our Client's team in a hybrid work model from Lisbon. You will design, develop and optimize ETL processes using Informatica PowerCenter and related tooling.

The ideal candidate has 6+ years of ETL experience, strong SQL, Linux/Unix scripting, and a solid understanding of data warehousing concepts. English proficiency is essential for collaboration across teams.

Qualificações

• Minimum 6 years of professional ETL development experience with Informatica PowerCenter.
• Strong hands-on Informatica PowerCenter components and ETL design expertise.
• Advanced knowledge of ETL design, mappings, workflows and performance tuning.
• Strong SQL and experience with Oracle, SQL Server, Teradata or PostgreSQL.
• Experience with Linux/Unix, shell scripting and Bash.
• Solid data warehousing knowledge (star/snowflake schemas; Kimball/Inmon).
• Experience integrating diverse data sources (relational DBs, flat files, APIs, XML/JSON).
• Experience with workload automation tools (Control-M, AutoSys, Dollar Universe).
• Strong incident troubleshooting and L3 support capability.
• Professional English communication skills.

Responsabilidades

• Analyze requirements and translate them into technical specifications.
• Design data flows, mappings, reusable components and integration patterns.
• Develop, test and deploy scalable ETL processes using Informatica PowerCenter.
• Build and optimize SQL queries, stored procedures and shell scripts.
• Integrate heterogeneous data sources from cloud and on‑prem sources.
• Improve ETL performance via mapping optimization and query tuning.
• Investigate and resolve production incidents (L3 support).
• Ensure data integrity, quality and security throughout ETL processes.
• Maintain scheduling and workload automation processes.
• Provide technical guidance and code reviews for the team.

Conhecimentos

ETL design

SQL proficiency

Linux/Unix scripting

Analytical thinking

English proficiency

Ferramentas

Informatica PowerCenter

Informatica Designer

Informatica Workflow Manager

Informatica Workflow Monitor

Informatica Repository Manager

Control-M

AutoSys

Dollar Universe

Oracle

SQL Server

Teradata

PostgreSQL

AWS/Azure/Snowflake

Jenkins

Descrição da oferta de emprego

Hexa Consulting is seeking a Senior Informatica ETL Developer to join our Client's team in a hybrid work model from Lisbon. You will design, develop and optimize ETL processes using Informatica PowerCenter and related tooling.

The ideal candidate has 6+ years of ETL experience, strong SQL, Linux/Unix scripting, and a solid understanding of data warehousing concepts. English proficiency is essential for collaboration across teams.