act digital
Informatica Data Engineer
Data engineer (6+ years' experience) who designs, maintains, troubleshoots, and optimizes ETL workflows in Informatica PowerCenter — including data masking, data quality, and performance tuning of high-volume pipelines — with optional work on PowerCenter-to-IDMC cloud migration. Based in Portugal; not remote.
- Compensation
- Not disclosed
- Location
- Portugal
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Full time
- Experience
- 6+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 6+ years of professional experience in Data Engineering, Data Integration, ETL or related field
- Strong hands-on experience with Informatica PowerCenter
- Experience developing, maintaining and optimizing ETL processes
- Solid knowledge of Informatica mappings, workflows, sessions and transformations
- Knowledge of workflow configuration and parameterization
- Knowledge of error handling, recovery mechanisms, monitoring and debugging
- Experience with Data Masking using Informatica, including dynamic and persistent approaches
- Solid knowledge of SQL and relational databases
- Knowledge of ETL/ELT concepts, data integration architectures and data lifecycle principles
- Experience troubleshooting complex ETL issues with large datasets and high-volume workloads
- Experience identifying performance bottlenecks and implementing technical optimizations
- Knowledge of Data Quality practices: validation rules, data controls, monitoring, remediation
- Experience in structured development environments with version control, deployment processes and technical documentation
- Ability to work autonomously troubleshooting and maintaining PowerCenter environments
- Strong analytical, problem-solving and communication skills
- Good command of English
Nice to have
- Hands-on experience with Informatica IDMC, particularly Cloud Data Integration (CDI)
- Experience with PowerCenter-to-IDMC migration projects (assessment, compatibility analysis, remediation)
- Knowledge of Informatica Data Quality or IDMC Data Quality
- Knowledge of Informatica services for metadata management, data governance or data cataloguing
- Experience with CI/CD practices 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
- Minimum of 6 years of professional experience in Data Engineering, Data Integration, ETL, or a related field.
- Strong hands-on experience with Informatica PowerCenter.
- Experience developing, maintaining, and optimizing ETL processes.
- Solid knowledge of:
- Informatica mappings, workflows, sessions, and transformations.
- Workflow configuration and parameterization.
- Error handling, recovery mechanisms, monitoring, and debugging.
- Data Masking using Informatica, including dynamic and persistent data masking approaches.
- SQL and relational databases.
- ETL/ELT concepts, data integration architectures, and data lifecycle principles.
- Proven experience troubleshooting complex ETL issues involving large datasets and high-volume workloads.
- Experience identifying performance bottlenecks and implementing technical optimizations.
- Knowledge of Data Quality practices, including validation rules, data controls, monitoring, and remediation processes.
- Experience working in structured development environments with version control, deployment processes, and technical documentation.
- Ability to work autonomously when troubleshooting and maintaining existing PowerCenter environments.
- Strong analytical, problem-solving, and communication skills.
- Good command of English.
Nice to Have
- Hands-on experience with Informatica Intelligent Data Management Cloud (IDMC), particularly Cloud Data Integration (CDI).
- Experience participating in PowerCenter-to-IDMC migration projects, including migration assessment, compatibility analysis, and remediation activities.
- Knowledge of Informatica Data Quality or IDMC Data Quality.
- Knowledge of Informatica services related to metadata management, data governance, or data cataloguing.
- Experience with CI/CD practices 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.
Responsibilities
- Design, develop, maintain, and enhance data integration workflows using Informatica PowerCenter.
- Develop and maintain Data Masking workflows using Informatica PowerCenter or TDM to protect sensitive data across different environments.
- Support the implementation and evolution of Data Masking solutions, including dynamic and persistent data masking approaches.
- Analyze, troubleshoot, and resolve complex issues involving ETL workflows, mappings, sessions, and data integration processes.
- Identify performance bottlenecks and implement optimizations for ETL processes handling large volumes of data.