Data Engineer - SSIS Migration to SQL Server 2022

SmartLogix; United States; Remote; USD 80,000 - 110,000; Full time

Benefits offered by this job

Competitive package

Job summary

A technology solutions provider is seeking a Data Engineer to support the migration of ETL workloads from SSIS 2016 to SSIS 2022. The role requires expertise in SQL Server Integration Services (SSIS) and a background in data engineering. Responsibilities include upgrading projects, validating compatibility, and collaborating across teams to ensure data consistency. Ideal candidates will possess a Bachelor's degree and strong problem-solving skills. A competitive compensation package is offered.

Qualifications

• 3–5 years in data engineering roles with SSIS migration experience.
• Hands-on validation of ETL processes and data integrity.
• Familiar with job automation/orchestration tools.

Responsibilities

• Upgrade and validate SSIS projects to SQL Server 2022.
• Document results and issues in Azure DevOps.
• Collaborate with Technical Leads, QA, and DevOps teams.

Skills

SSIS development and migration

SQL Server and T-SQL

Visual Studio 2022

SQL Server Management Studio (SSMS)

Azure DevOps

CA Workload (ESP dSeries)

Data validation and QA documentation

Education

Bachelor’s degree in computer science or related field

Tools

SSIS

Visual Studio

Azure DevOps

Job description

A technology solutions provider is seeking a Data Engineer to support the migration of ETL workloads from SSIS 2016 to SSIS 2022. The role requires expertise in SQL Server Integration Services (SSIS) and a background in data engineering. Responsibilities include upgrading projects, validating compatibility, and collaborating across teams to ensure data consistency. Ideal candidates will possess a Bachelor's degree and strong problem-solving skills. A competitive compensation package is offered.