Senior ETL Developer- Informatica PowerCenter

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 PowerCenter for 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.
• Solid Shell/Bash/Unix/Linux scripting experience.
• 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

Join us Send us your CV in English to with “DA / ETL”.

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.