Data Integration Engineer (REMOTE)

emagine Consulting; France; À distance; EUR 45 000 - 70 000; Plein temps

Résumé du poste

A leading consulting firm in France seeks a Data Integration Engineer specializing in Microsoft SQL Server Integration Services (SSIS). In this critical role, you will analyze and migrate data integration workflows, optimizing performance and scalability. Ideal candidates will have a degree in Computer Science and solid experience with SQL, ELT/ETL processes. Collaborate with various stakeholders to drive significant transitions in integration processes within a dynamic environment.

Qualifications

• Experience in data integration projects.
• Excellent SQL / T-SQL skills for complex queries and large-volume data processing.
• Familiarity with ETL / ELT architectures in SQL Server.

Responsabilités

• Analyze existing integration processes developed in Boomi.
• Design, develop, and migrate data integration workflows in SSIS.
• Document developments and contribute to knowledge transfer.

Connaissances

SQL

T-SQL

Data Integration Principles

Automation

Formation

Degree in Computer Science

Outils

SQL Server

SSIS

Boomi

SQL Agent

Visual Studio Data Tools

Description du poste

Data Integration Engineer , specializing in Microsoft SQL Server Integration Services (SSIS) with solid knowledge in SQL and ELT . This role focuses on a strategic data migration project originally developed in Boomi to an SSIS-based architecture.

Job Description :

Analyze existing integration processes developed in Boomi

Design, develop, and migrate data integration workflows in SSIS using an ETL / ELT approach

Implement high-performance integration strategies via Extract, Load, and Transform (ELT) processes in SQL Server

Optimize data processing to ensure performance, scalability, and maintainability

Conduct functional and performance testing of migrated packages

Document all developments and contribute to knowledge transfer

Collaborate closely with data teams, IT architects, and business stakeholders

Profile :

Degree in Computer Science (Bachelor’s or Master’s level) or equivalent

y of experience in data integration projects

Excellent SQL / T-SQL skills , including complex queries and large-volume data processing

Proven experience with ELT / ETL architectures , particularly within SQL Server (heavy use of SQL for transformations)

Working knowledge of Boomi for understanding and analyzing existing processes

In-depth understanding of data integration principles , data flow orchestration, and automation

Experience working on ETL / ELT tool or platform migrations

Familiarity with Microsoft ecosystem tools : SSMS, SQL Agent, Visual Studio Data Tools

Comfortable working in complex project environments and managing priorities

Working language : English (French is a plus)

This role offers the opportunity to be part of a significant transition in the integration processes while collaborating with various stakeholders in a dynamic environment.