Senior Data Integration Engineer — Lead ETL & Architecture

ITDS; Lisboa; Híbrido; EUR 75 000 - 95 000; Tempo integral

Resumo da oferta

ITDS in Porto invites a Senior Data Integration Engineer – Informatica PowerCenter to join a dynamic financial services client. You will deliver scalable data solutions for Lease Applications, lead the Porto engineering team, and optimize ETL pipelines across on‑prem and cloud environments.

The ideal candidate has 7+ years in data engineering/ETL, strong SQL, and hands‑on Informatica expertise. Fluency in English is required; a hybrid work model is offered with cross‑functional collaboration.

Qualificações

• 7+ years of proven experience as a Data Engineer/ETL Developer.
• Deep hands‑on expertise with Informatica PowerCenter suite (PowerCenter Designer, Workflow Manager, Repository Manager).
• Strong knowledge of SQL and major DBMS platforms (Oracle, SQL Server, PostgreSQL, Teradata).
• Scripting in Shell (Bash/Unix/Linux).
• Understanding of Data Warehousing methodologies and schema design (Kimball/Inmon, star/snowflake).
• Fluent English (spoken and written).

Responsabilidades

• Analyze complex requirements from business teams to design data architectures.
• Develop, test, and deploy ETL workflows using Informatica PowerCenter and IICS.
• Write and optimize SQL queries, stored procedures, and automation scripts.
• Integrate data sources from relational DBs, APIs, flat files, and cloud.
• Tune ETL pipelines for performance and resilience.
• Ensure data quality, security, and governance across environments.
• Automate scheduling and workflows with Control-M, Jenkins, or similar.
• Lead Porto engineering team, conduct code reviews and establish best practices.

Conhecimentos

Informatica PowerCenter

SQL

Shell scripting

Cloud platforms AWS/Azure/GCP

Data warehousing Kimball/Inmon

ETL/Data Integration

English fluency

Ferramentas

Informatica PowerCenter tools

Jenkins

Control‑M

Descrição da oferta de emprego

ITDS in Porto invites a Senior Data Integration Engineer – Informatica PowerCenter to join a dynamic financial services client. You will deliver scalable data solutions for Lease Applications, lead the Porto engineering team, and optimize ETL pipelines across on‑prem and cloud environments.

The ideal candidate has 7+ years in data engineering/ETL, strong SQL, and hands‑on Informatica expertise. Fluency in English is required; a hybrid work model is offered with cross‑functional collaboration.