Senior Data Integration Engineer – Informatica PowerCenter

Unleash Data Transformation & Integration Excellence — Lead the Future of Data Architecture!

Porto-based opportunity with hybrid work model.

As a Senior Data Integration Engineer – Informatica PowerCenter, you will be working for our client in the financial services sector, focusing on delivering scalable data solutions for Lease Applications. Join an innovative team shaping the future of data management and drive impactful projects in a dynamic environment.

Your main responsibilities:

• Analyze complex functional and technical requirements provided by business teams and Business Analysts to design effective data architectures.
• Develop, test, and deploy high-performance ETL workflows using Informatica PowerCenter and cloud services such as Informatica IICS.
• Write and optimize intricate SQL queries, stored procedures, and system automation scripts in Linux/Unix.
• Integrate diverse data sources including relational databases, APIs, flat files, and cloud environments.
• Tune and troubleshoot existing ETL pipelines for optimal performance and resilience.
• Ensure data integrity, security, and quality across all processes and environments.
• Automate scheduling and operational workflows using tools like Control-M, Jenkins, or similar.
• Serve as the technical lead for the Porto engineering team, conducting code reviews and establishing best practices.

You’re ideal for this role if you have:

• Minimum of 7 years of proven experience as a Data Engineer / ETL Developer.
• Deep hands-on expertise with Informatica PowerCenter suite (PowerCenter Designer, Workflow Manager, Repository Manager).
• Strong knowledge of SQL and experience with major DBMS platforms (Oracle, SQL Server, PostgreSQL, Teradata).
• Proficiency in Shell scripting (Bash/Unix/Linux).
• Solid understanding of Data Warehousing methodologies and schema design (Kimball/Inmon, star/snowflake models).
• Excellent command of English (fluent level).

It is a strong plus if you have:

• Experience with Informatica Cloud (IICS), Data Quality (IDQ), MDM, or cloud platforms like AWS, Azure, GCP, Snowflake.
• Knowledge of modern programming languages such as Python, Scala, Java, or Spark.
• Familiarity with Automation and DevOps tools like Control-M, Jenkins, and CI/CD practices.
• Experience working within Agile frameworks (Scrum or Kanban).

Language Required for the role:

• Fluent English (spoken and written).

Eligibility for the role:

• Only candidates with an existing legal right to work in Europe will be considered for this role.

#MAKEYourCareerBETTER

Interested? Apply now and include your CV (preferably in English) along with a statement confirming your consent to the processing and storage of your personal data.