> Markdown version of [/jobs/ext/3099394-ssis-migration-etl-sql](https://www.wearedevelopers.com/jobs/ext/3099394-ssis-migration-etl-sql). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SSIS Migration/ETL/SQL

- **Company:** Shephard Family Enterprise LLC
- **Location:** Plano, TX, United States
- **Experience:** Experienced
- **Salary:** $83,200.0 - $93,600.0
- **Contract:** Temporary to permanent
- **Skills:** .NET Framework, Microsoft Azure, C Sharp (Programming Language), Continuous Integration, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Migration, Data Warehousing, DevOps, Dimensional Modeling, Python (Programming Language), Microsoft SQL Server, Performance Tuning, Windows PowerShell, Power BI, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Transact-SQL, Real Time Systems, Data Ingestion, Snowflake, Apache Spark, Git, Microsoft Fabric, Pyspark, Star Schema, Azure Synapse Analytics, Data Pipelines, Sql Tuning, Databricks
- **Published:** September 26, 2026
- **Apply:** https://www.careerjet.com/jobad/us1656dc6ea7527342b13bb235c49aee31

## About the Role

Analyze, migrate, and modernize SSIS packages, ETL workflows, and dependencies to Azure/Fabric/Databricks/Synapse.
Design scalable ETL/ELT pipelines, data ingestion, transformation, orchestration, and batch/near real-time processing.
Develop migration frameworks, automation, testing, deployment, production support, and data validation/reconciliation.
Build and optimize SQL Server solutions using T-SQL, performance tuning, stored procedures, views, and functions.
Design enterprise data warehouse models including Star Schema, Snowflake, Fact/Dimension, CDC, and SCD.
Support cloud-native data integration and CI/CD using Azure DevOps and Git. Required Skills
Core: SQL Server, T-SQL, SSIS Development & Migration, ETL/ELT, Data Migration, SQL Performance Tuning
Data Warehouse: Dimensional Modeling, Star/Snowflake Schema, Fact & Dimension, CDC, SCD
Cloud: Azure Data Factory, Azure Synapse, Microsoft Fabric, ADLS, Databricks, Spark/PySpark (experience in one or more)
Reporting: SSRS, Power BI
Programming: Python, PowerShell, C#, .NET
DevOps: Azure DevOps, Git, CI/CD Preferred
7-10+ years in ETL/Data Engineering and 3+ years in SSIS.
Hands-on SSIS migration to ADF, Fabric, Databricks, or Synapse.
Experience estimating migration effort and resolving dependency impacts.