Senior Data Integration Engineer – Informatica PowerCenter,

ITDS; Porto; Híbrido; EUR 55 000 - 75 000; Tempo integral

Resumo da oferta

ITDS is seeking a Senior Data Integration Engineer – Informatica PowerCenter in Porto, offering a hybrid work model. You will deliver scalable data solutions for Lease Applications in the financial services sector and lead the Porto engineering team.

You will design data architectures, develop ETL workflows with Informatica PowerCenter and IICS, optimize SQL, integrate diverse data sources, and ensure data quality while steering code reviews and best practices.

Qualificações

• 7+ years of experience as a Data Engineer/ETL Developer.
• Strong SQL and DBMS knowledge (Oracle, SQL Server, PostgreSQL, Teradata).
• Proficiency in Bash/Unix/Linux scripting.
• Solid understanding of data warehousing (Kimball/Inmon, star/snowflake).
• Fluent English in speaking and writing.

Responsabilidades

• Analyze functional and technical requirements to design data architectures.
• Develop, test, and deploy ETL workflows using Informatica PowerCenter and IICS.
• Write and optimize SQL queries, procedures, and automation scripts in Linux/Unix.
• Integrate diverse data sources including relational DBs, APIs, and cloud environments.
• Tune ETL pipelines for performance and reliability; ensure data integrity and quality.
• Automate scheduling and workflows with tools like Control-M or Jenkins.
• Serve as technical lead for the Porto engineering team and conduct code reviews.

Conhecimentos

ETL Development

SQL

Data Warehousing

Shell scripting

English fluency

Ferramentas

Informatica PowerCenter

Informatica IICS

Descrição da oferta de emprego

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.