Data Engineer – SSIS Migration ProjectSmartLogix • New York, New York, United States
Data Engineer – SSIS Migration Project
SmartLogix
- New York, New York, United States
- New York, New York, United States
À propos
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.
We offer a competitive package with several advantages.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.