Senior ETL Developer- Informatica PowerCenter

Decskill; Portugal; Híbrido; EUR 40 000 - 60 000; Tempo integral

Resumo da oferta

Decskill is seeking a Senior ETL Developer to design and implement robust data integration solutions using Informatica PowerCenter/IICS. This role offers a hybrid work model across Lisbon, Porto and Madrid, with exposure to international projects and a strong focus on data quality, security and performance.

You will lead technical delivery, mentor teammates, and collaborate with cross-functional teams to drive data-driven initiatives in a dynamic IT consultancy environment.

Qualificações

• 7+ years of professional ETL Developer experience.
• Advanced Informatica PowerCenter knowledge: Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Strong SQL knowledge with Oracle, SQL Server, Teradata or PostgreSQL.

Responsabilidades

• Design architectures for complex data flows and ETL workflows.
• Develop, test and deploy ETL processes with Informatica PowerCenter/IICS.
• Write and optimize SQL queries, stored procedures and Shell scripts.
• Integrate diverse data sources: relational DBs, flat files, APIs, XML/JSON, cloud.
• Analyze and optimize ETL and DB performance.
• Troubleshoot Level 3 production incidents.
• Ensure data quality, integrity and security in ETL processes.
• Automate scheduling/workloads using Control-M, AutoSys or Dollar Universe.
• Maintain high-quality technical documentation.
• Act as a Tech Lead; review code and promote best practices.
• Mentor and support development team members.

Conhecimentos

ETL development

Informatica PowerCenter

SQL

Data warehousing

IICS

Cloud platforms

Control-M

Jenkins

Agile (Scrum/Kanban)

Tech Lead / mentoring

Ferramentas

Control-M

Jenkins

Shell scripting

Descrição da oferta de emprego

We are growing. And we are looking for talented people.

At Decskill, we believe that technological excellence is driven by human talent.

We are an IT consulting company with more than 10 years of consolidated experience in the market, focused on building long‑term relationships with both our clients and our people. Today, we are a community of over 800 professionals, working from Lisbon, Porto, and Madrid, contributing to impactful technology initiatives.

As part of the Astek Group, we combine a strong local culture with a global presence, being active in around 23 countries across 4 continents. This allows us to offer an international context, diverse challenges, and long‑term career opportunities, while staying close to our teams.

We would like to meet a Senior ETL Developer- Informatica PowerCenterfor a project with a hybrid working model:

Key responsibilities:

• Design technical architectures for complex data flows, mappings, mapplets and workflows.
• Develop, test and deploy robust ETL processes using Informatica PowerCenter and, ideally, IICS.
• Write and optimize complex SQL queries, stored procedures and Shell scripts.
• Integrate heterogeneous data sources including relational databases, flat files, APIs, XML/JSON and Cloud platforms.
• Analyze and optimize ETL and database performance.
• Troubleshoot and resolve complex Level 3 production incidents.
• Ensure data quality, integrity and security throughout ETL processes.
• Automate scheduling and workload processes using tools such as Control-M, AutoSys or Dollar Universe.
• Maintain high‑quality technical documentation.
• Act as a Tech Lead, contribute to code reviews and promote development best practices.
• Mentor and support other members of the development team.

What we're looking for:

Must-have:

• 7+ years of professional experience as an ETL Developer.
• Advanced expertise in Informatica PowerCenter: Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Strong knowledge of SQL and significant experience with a major DBMS such as Oracle, SQL Server, Teradata or PostgreSQL.
• Strong understanding of Data Warehousing, including Star/Snowflake schemas, Kimball/Inmon methodologies and SCD.

Nice to have:

• Experience with Informatica IICS, IDQ or MDM.
• Knowledge of AWS, Azure, Snowflake or Google Cloud Platform.
• Experience with workload automation tools such as Control-M or Jenkins.
• Experience working in Agile environments (Scrum/Kanban).

Find with us the right opportunity to grow!

What you can expect from us:

• Long‑term projects with national and international context
• Opportunities to grow technically and professionally
• A people‑first culture, focused on transparency and trust
• Teams that value ownership, collaboration and stability

Your next challenge might start here.

At Decskill, we are committed to equal opportunities and non‑discrimination. We promote a culture of diversity and inclusion, where recruitment and career progression are based solely on talent, regardless of age, gender, ethnicity, race, nationality, or any other form of discrimination incompatible with human dignity.