Data Engineer (Informatica PowerCenter)
Consulting-role data engineer for Dellent, working on an investment banking client's tech-hub project. Day to day: building, tuning, and debugging Informatica PowerCenter ETL workflows and mappings for large datasets, using SQL and relational databases. Hybrid position in Porto or Lisbon.
- Compensation
- Not disclosed
- Location
- Portugal
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 6+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 6+ years of professional experience in Data Engineering, Data Integration, ETL or related field
- Proficiency with Informatica PowerCenter
- Knowledge of Informatica mappings/workflows, Data Masking, sessions, workflow configuration, transformations, parameterization, error handling, recovery, monitoring and debugging
- Experience troubleshooting and optimizing ETL processes with large datasets and high-volume workloads
- Working experience with SQL and relational databases
- Experience analyzing data integration performance issues and implementing optimizations
- Knowledge of ETL/ELT concepts, data integration architectures and data lifecycle principles
- Experience in structured development environments with version control, deployment processes and technical documentation
- Fluent in English
Nice to have
- Experience with Informatica Intelligent Data Management Cloud (IDMC)
- Experience participating in or leading PowerCenter-to-IDMC migration initiatives
- Knowledge of PowerCenter migration assessment, compatibility analysis and remediation
- Experience with Informatica Data Quality / IDMC Data Quality
- Knowledge of Informatica services related to metadata, governance or cataloguing
- Experience with CI/CD and automated deployment of data integration components
- Experience with cloud platforms and modern data architectures
- Knowledge of scripting languages such as Python or Shell
- Experience working in Agile environments
Full description
Descrição da Função
Dellent is a consulting company focused in System Information and Telecommunications. Our goal is to help our candidates and consultants to take a step forward in their careers through projects that meet their needs and expectations. This project is part of the business investment banking and financial services area, that currently has its technological hub in Portugal and is working on the development of innovative solutions and support for all operations related to the business. We are looking for a Data Engineer (Informatica PowerCenter) to work in this project in Porto or Lisbon (Hybrid).
Required skills and experience:
- 6+ years of professional experience in Data Engineering, Data Integration, ETL or a related field;
- Proficiency with Informatica PowerCenter;
- Knowledge of Informatica mappings and workflows, Data Masking, sessions, workflow configuration, transformations, parameterization, error handling, recovery mechanisms, workflow monitoring and debugging;
- Experience with troubleshooting and optimizing ETL processes handling large datasets and high-volume workloads;
- Working experience with SQL, and relational databases;
- Experience with analyzing data integration performance issues and implementing technical optimizations;
- Knowledge of ETL/ELT concepts, data integration architectures and data lifecycle principles;
- Experience working in structured development environments with version control, deployment processes and technical documentation;
- Fluent in English.
Preferred qualifications:
- Experience with Informatica Intelligent Data Management Cloud (IDMC);
- Experience participating in or leading PowerCenter-to-IDMC migration initiatives;
- Knowledge of PowerCenter migration assessment, compatibility analysis and remediation activities;
- Experience with Informatica Data Quality / IDMC Data Quality;
- Knowledge of Informatica services related to metadata, governance or cataloguing;
- Experience with CI/CD and automated deployment of data integration components;
- Experience working with cloud platforms and modern data architectures;
- Knowledge of scripting languages such as Python or Shell;
- Experience working in Agile environments.
What can you expect from us?
- Health insurance;
- A personalized training plan, with a budget to spend on the training you find necessary;
- Constant feedback so you can grow professionally;
- Remote onboarding process;
- Team events every semester so you can live new adventures;
- Culture of proximity and transparency.
Your ideas and needs are heard and valued by us!