The Role
Migrate and validate SSIS ETL workloads from SSIS 2016 to SSIS 2022: update configs, execute and compare runs via SSISDB and orchestration tools, document findings in Azure DevOps, and collaborate with QA, DevOps, and technical leads during sprint-based deliveries.
Summary Generated by Built In
This is a remote position.
Job Objective: Data Engineer with solid experience in SQL Server Integration Services (SSIS) to support the migration of ETL workloads from SSIS 2016 to SSIS 2022.The role focuses on upgrading packages, validating compatibility, and ensuring data consistency across environments using structured sprint-based delivery.
Responsibilities:
- Upgrade and validate SSIS projects to SQL Server 2022.
- Update connection managers, parameters, and environment variables to align with new configuration models.
- Execute and validate workloads through SSISDB and CA Workload (ESP dSeries) or similar orchestration tools.
- Compare execution results between versions to ensure data and functional parity.
- Document results, issues, and configurations in Azure DevOps.
- Collaborate with Technical Leads, QA, and DevOps teams during validation and release cycles.
Requirements
Bachelor’s degree in computer science, Software Engineering, or related field.
Preferred certifications: Microsoft Certified Data Engineer, SSIS, Azure DevOps.
3–5 years in data engineering roles, with hands-on SSIS migration, ETL validation, and use of Visual Studio, SSMS, and Azure DevOps.
Required Skills:
- Proven experience with SSIS development, configuration, and migration.
- Strong SQL Server and T-SQL skills for ETL troubleshooting and optimization.
- Experience using Visual Studio 2022, SQL Server Management Studio (SSMS), and Azure DevOps.
- Familiarity with CA Workload (ESP dSeries) or equivalent job automation/orchestration tools.
- Understanding of environment variable management, package parameters, and catalog deployment (SSISDB).
- Experience validating data pipelines and documenting results for QA/UAT.
- Strong problem-solving, communication, and documentation skills.
Soft Skills:
- Analytical thinking: assess compatibility and validate data integrity.
- Problem-solving: troubleshoot migration and execution issues.
- Communication: document findings and collaboration across teams.
- Time management: delivery within sprint cycles and tight timelines.
- Team collaboration: work effectively with QA, DevOps, and technical leads.
Benefits
We offer a competitive package with several advantages.
Skills Required
- Bachelor's degree in Computer Science, Software Engineering, or related field
- 3-5 years in data engineering roles with hands-on SSIS migration and ETL validation
- Proven experience with SSIS development, configuration, and migration
- Strong SQL Server and T-SQL skills for ETL troubleshooting and optimization
- Experience using Visual Studio 2022
- Experience using SQL Server Management Studio (SSMS)
- Experience using Azure DevOps (work item tracking, documentation)
- Familiarity with CA Workload (ESP dSeries) or equivalent orchestration/job automation tools
- Understanding of environment variable management, package parameters, and SSISDB/catalog deployment
- Experience validating data pipelines and documenting results for QA/UAT
- Strong problem-solving, communication, and documentation skills
- Preferred certifications: Microsoft Certified Data Engineer, SSIS, Azure DevOps
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SmartLogix is an information technology services and software development company creating custom cloud applications and market-ready products. Its capabilities include cloud integration, data analytics, mobile technology, UI/UX design, and managed IT services. The company also offers staffing and talent solutions, pre-screening professionals and organizing resources for projects, consultancy, daily operations, and IT staffing across healthcare, food distribution, insurance, and other industries.
