Data Engineer - Informatica & Data Masking

Hexa Group; Lisboa; Hybrid; EUR 60,000 - 90,000; Full time

Benefits offered by this job

Private health insurance

Mental health support

Training and certification

Hybrid work arrangement

Family/childcare support

Team and knowledge sharing

Job summary

Hexa Group in Lisbon is seeking a Senior Data Engineer with 6–9 years of experience to join a data integration initiative in the banking sector. The role is based in Lisbon with a hybrid working model and focuses on enterprise data integration, data masking, and high-performance data processing.

You will develop, optimize and ensure reliability of ETL processes, data masking solutions and data quality controls across development, testing and production environments.

Qualifications

• 6 to 9 years of professional experience in Data Engineering, ETL development or enterprise data integration.
• Strong practical experience with Informatica PowerCenter in complex data processing environments.
• Troubleshoot, maintain and optimize data pipelines handling large data volumes.
• Experience implementing or maintaining data masking solutions.
• Understanding of data integration architectures, data lifecycle management and data quality.
• Autonomous work style with ability to prioritise technical challenges.
• Strong analytical thinking and problem-solving with attention to technical quality.
• Professional working proficiency in English.

Responsibilities

• Develop and improve ETL processes using Informatica PowerCenter for reliable data integration.
• Implement and maintain data masking mechanisms across environments.
• Analyze complex data processing issues, identify root causes and implement solutions.
• Optimize data workflows and database interactions for large-scale processing.
• Support data quality controls, validation processes and monitoring activities.
• Investigate production incidents and contribute to service stability.
• Support deployment, standardization and industrialization of data integration components.
• Maintain technical documentation for integration processes and configurations.
• Collaborate with engineering, architecture and applications teams.
• Contribute to knowledge sharing and reusable engineering solutions.

Skills

Data engineering

ETL development

Data masking

Data quality

SQL proficiency

Analytical thinking

Autonomy

English proficiency

Tools

Informatica PowerCenter

Informatica Data Masking

Informatica IDMC CDI

SQL databases

Job description

We are looking for a Senior Data Engineer with 6 to 9 years of experience to join a data integration initiative within the banking sector, based in Lisbon with a hybrid working model.

You will contribute to the development, optimization and operational reliability of enterprise data integration and masking solutions, ensuring secure data processing, high performance and consistent data quality across different environments.

WHAT YOU WILL DO

• Develop and improve ETL processes using Informatica PowerCenter, ensuring efficient and reliable data integration.
• Implement and maintain data masking mechanisms to protect sensitive information across development, testing and production environments.
• Analyze complex data processing issues, identify root causes and implement sustainable technical solutions.
• Optimize data workflows and database interactions to support large-scale processing requirements.
• Support data quality controls, validation processes and monitoring activities to improve data consistency and reliability.
• Investigate production incidents and contribute to service stability through effective troubleshooting and remediation.
• Support deployment, standardization and industrialization of data integration components across environments.
• Maintain technical documentation covering integration processes, configurations and operational procedures.
• Collaborate with engineering, architecture and application teams to ensure alignment with technical requirements.
• Contribute to knowledge sharing, reusable solutions and continuous improvement of engineering practices.

WHAT WE ARE LOOKING FOR

• 6 to 9 years of professional experience in Data Engineering, ETL development or enterprise data integration.
• Strong practical experience with Informatica PowerCenter in complex data processing environments.
• Proven ability to troubleshoot, maintain and optimize data pipelines handling significant data volumes.
• Experience implementing or maintaining data masking solutions for sensitive information.
• Solid understanding of data integration architectures, data lifecycle management and data quality principles.
• Ability to work autonomously, prioritize technical challenges and deliver maintainable solutions.
• Strong analytical thinking, structured problem-solving skills and attention to technical quality.
• Effective collaboration within multidisciplinary teams and professional working proficiency in English.

TECHNICAL SKILLS

• Informatica PowerCenter, including mappings, transformations, sessions and workflow orchestration.
• Informatica Data Masking and Test Data Management (TDM).
• Dynamic and persistent data masking techniques.
• Advanced SQL and relational database concepts.
• ETL/ELT architecture, data transformation and integration patterns.
• Workflow parameterization, execution monitoring, exception handling and recovery procedures.
• Performance analysis and optimization of high-volume data processing.
• Data quality validation, monitoring and remediation practices.
• Version control, deployment management and technical documentation.

NICE TO HAVE

• Experience with Informatica Intelligent Data Management Cloud (IDMC), particularly Cloud Data Integration (CDI).
• Participation in migration initiatives from Informatica PowerCenter to IDMC.
• Knowledge of migration assessment, compatibility evaluation and technical remediation.
• Experience with Informatica Data Quality or cloud-based data quality capabilities.
• Familiarity with metadata management, data governance and data cataloguing.
• Knowledge of CI/CD practices and automated deployment processes.
• Exposure to cloud platforms and modern data integration architectures.
• Scripting experience with Python or Shell.
• Familiarity with Agile delivery methodologies.

WHAT WE OFFER

• Private health insurance from your first day, with no waiting period and optional family extension.
• Free and confidential psychological support through our mental health partnership, including specialist assistance and well-being resources.
• Continuous professional development through training, certification opportunities and structured learning.
• Opportunities to strengthen expertise in information security, quality management and cybersecurity best practices.
• Hybrid working arrangements aligned with the requirements of the role.
• Childcare vouchers and support measures designed to promote work-life balance.
• Opportunities to connect with colleagues through community activities, team initiatives and shared experiences.
• A collaborative professional environment focused on long-term development, meaningful contributions and mutual support.

EQUAL OPPORTUNITY

At Hexa, we are committed to equal opportunity and an inclusive recruitment process. Aligned with the principles of the Portuguese Diversity Charter, we value different backgrounds, experiences and perspectives. All applica