Integration Engineer - Informatica, Ipaas

Som3; Reading; Remote; GBP 55,000 - 75,000; Full time

Job summary

A technology integration company is seeking an experienced Integration Engineer to design and develop data integration solutions using Informatica IPaaS and Snowflake. The role mainly offers remote work with monthly team meet-ups. Candidates should have a strong background in ELT & ETL pipelines, cloud platforms, and data warehousing concepts. This is an excellent opportunity for those looking to guide a team while implementing scalable integration solutions.

Qualifications

• Proven experience in a similar role to provide guidance to the team.
• Excellent experience in Informatica as an IPaaS.
• Strong understanding of data warehousing and medallion architecture.

Responsibilities

• Design, develop, and implement ELT & ETL pipelines.
• Build connectors from multiple sources including cloud platforms.
• Ensure integration pipelines are built with error handling.

Skills

Informatica ELT & ETL development

SQL and relational databases

Cloud integration solutions

REST APIs

Data warehousing concepts

Job description

Overview

Integration Engineer

Mainly Remote (monthly meet ups with team). Outside IR35.

Experienced Integration Engineer needed to help design and develop data integration solutions using Informatica IPaaS and Snowflake data Lakehouse.

Responsibilities

• Design, develop and implement ELT & ETL pipelines and workflows using Informatica PowerCenter and Informatica Cloud.
• Build connectors from multiple sources including cloud platforms, bespoke and out-of-the-box APIs, databases, and flat files.
• Develop and maintain data mappings, transformations, data pipelines and integration workflows.
• Implement real-time and batch data integration solutions to support business requirements.
• Ensure any integration pipelines or ELT / ETL workflows are built with error handling, exception handling, retries and observability.

Your experience

• Proven experience in a similar role so you can provide advice and guidance to the team.
• Excellent experience in Informatica ELT & ETL development and integration solutions using Informatica as an IPaaS.
• SQL and relational databases (e.g., Oracle, SQL Server, PostgreSQL).
• Cloud based data storage solutions such as Snowflake and data lakehouse.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) and cloud-based data integration.
• Strong understanding of data warehousing concepts, dimensional modelling and medallion architecture.
• Building production-grade pipelines with logging, alerting, retries, idempotency, and robust error handling.
• Experience with REST APIs, pagination, authentication (OAuth2, service principals), and file-based ingestion (CSV/Parquet).