Senior ETL Developer - Informatica PowerCenter Lead

Decskill; Lisboa; Híbrido; EUR 65 000 - 90 000; Tempo integral

Resumo da oferta

Decskill is seeking a Senior ETL Developer - Informatica PowerCenter to join our team in a hybrid capacity. You will design complex data flows, develop robust ETL processes with Informatica PowerCenter/IICS, and optimize SQL across major DBMS.

You will guide a high-performing team, review code, and mentor colleagues, while ensuring data quality and security. The role emphasizes leadership, data warehousing expertise, and cross-functional collaboration within an international context.

Qualificações

• 7+ years of professional experience as an ETL Developer.
• Advanced Informatica PowerCenter knowledge: Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Strong SQL with major DBMS (Oracle/SQL Server/Teradata/PostgreSQL).
• Solid data warehousing understanding and SCD concepts.

Responsabilidades

• Design architectures for complex data flows, mappings, mapplets and workflows.
• Develop, test and deploy ETL processes using Informatica PowerCenter and IICS.
• Write and optimize complex SQL queries, stored procedures and shell scripts.
• Integrate heterogeneous data sources incl. relational DBs, flat files, APIs, XML/JSON and cloud.
• Analyze and optimize ETL and DB performance.
• Troubleshoot Level 3 production incidents and ensure data quality.
• Automate scheduling/workloads using Control-M, AutoSys or Dollar Universe.
• Maintai n high-quality technical documentation.
• Act as Tech Lead, review code and promote best practices.
• Mentor and support other development team members.

Conhecimentos

ETL development

SQL

Data warehousing

Tech lead

Shell scripting

Performance tuning

Ferramentas

Informatica PowerCenter

Informatica IICS

Control-M

Jenkins

Cloud platforms (AWS/Azure/Snowflake/GCP)

Descrição da oferta de emprego

Decskill is seeking a Senior ETL Developer - Informatica PowerCenter to join our team in a hybrid capacity. You will design complex data flows, develop robust ETL processes with Informatica PowerCenter/IICS, and optimize SQL across major DBMS.

You will guide a high-performing team, review code, and mentor colleagues, while ensuring data quality and security. The role emphasizes leadership, data warehousing expertise, and cross-functional collaboration within an international context.