Informatica Data Engineer

act digital; Porto; On-site; EUR 55,000 - 80,000; Full time

Job summary

act digital in Porto, Portugal, is seeking a senior Data Engineer specialized in data integration and ETL with Informatica PowerCenter. You will design, develop and optimize data workflows, implement data masking, and ensure data quality across environments.

Strong SQL skills and experience with IDMC/ CDI migration projects are a plus. You'll work in a structured development environment with version control, documentation, and collaboration with Data Architects and business stakeholders.

Qualifications

• 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.

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.
• Investigate production incidents, perform root-cause analysis, and implement corrective and preventive actions.
• Contribute to Data Quality initiatives by implementing validation rules, data controls, monitoring mechanisms, and data remediation processes.
• Ensure the reliability, scalability, performance, and maintainability of ETL and data integration solutions.
• Participate in deployment and industrialization activities across development, testing, and production environments.
• Promote development standards, reusable components, and technical best practices.
• Produce and maintain clear technical documentation covering workflows, mappings, interfaces, and operational procedures.
• Collaborate with Data Engineers, Data Architects, application teams, and business stakeholders.
• Contribute to the modernization of existing data integration solutions, including PowerCenter-to-IDMC migration initiatives where applicable.
• Share technical knowledge and contribute to the continuous improvement of Data Integration practices and the Informatica ecosystem.

Skills

ETL

Data integration

SQL

PowerCenter

Troubleshooting

Performance tuning

Data quality

Agile

Communication

English

Tools

Informatica PowerCenter

IDMC/CDI

Python

CI/CD

Shell

Job 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.
• Investigate production incidents, perform root-cause analysis, and implement corrective and preventive actions.
• Contribute to Data Quality initiatives by implementing validation rules, data controls, monitoring mechanisms, and data remediation processes.
• Ensure the reliability, scalability, performance, and maintainability of ETL and data integration solutions.
• Participate in deployment and industrialization activities across development, testing, and production environments.
• Promote development standards, reusable components, and technical best practices.
• Produce and maintain clear technical documentation covering workflows, mappings, interfaces, and operational procedures.
• Collaborate with Data Engineers, Data Architects, application teams, and business stakeholders.
• Contribute to the modernization of existing data integration solutions, including PowerCenter-to-IDMC migration initiatives where applicable.
• Share technical knowledge and contribute to the continuous improvement of Data Integration practices and the Informatica ecosystem.