Apply Now

Web Module Lead - SSIS Migration & Modernization (Mandatory)

Plano, TX, US • Posted 3 hours ago • Updated 3 hours ago

Contract W2

Contract Independent

12 Months

No Travel Required

On-site

Depends on Experience

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Job Title - Web Module Lead-H1b only Location - Plano TX-Local only Experience - 10-14 Years Job Description - Key Responsibilities SSIS Migration & Modernization (Mandatory) Analyze and assess existing SSIS packages
ETL workflows
and dependencies. Design migration strategies for SSIS workloads to modern cloud-based or enterprise data platforms. Re-engineer ETL logic while preserving business functionality. Develop migration accelerators
reusable frameworks
and automation solutions. Perform end-to-end migration
testing
deployment
and production support. Data Engineering Design and build scalable data pipelines. Develop data ingestion
transformation
and orchestration processes. Implement data quality and validation frameworks. Support batch and near-real-time data processing requirements. Database Development Develop and optimize complex T-SQL queries
views
procedures
and functions. Perform SQL performance tuning and troubleshooting. Implement data reconciliation and validation processes. Data Warehousing Design and support enterprise data warehouse solutions. Work with Fact
Dimension
Star Schema
and Snowflake Schema models. Implement CDC and SCD strategies. Cloud Data Platforms Develop and support cloud-native data integration solutions. Participate in migration of on-premises data workloads to cloud environments. Support CI/CD implementation for data pipelines. Required Skills Core Technologies SQL Server T-SQL SSIS Package Development SSIS Package Analysis and Migration ETL/ELT Design Data Migration SQL Performance Tuning Data Warehousing Dimensional Modeling Star Schema Snowflake Schema Fact and Dimension Modeling CDC SCD Cloud & Modern Data Engineering Experience in one or more: Azure Data Factory (ADF) Azure Synapse Analytics Microsoft Fabric Azure Data Lake Storage (ADLS) Databricks Apache Spark / PySpark Reporting & Analytics SSRS Power BI Programming & Scripting Python PowerShell C# .NET DevOps Azure DevOps Git CI/CD Pipelines Preferred Experience 5+ years of experience in ETL/Data Engineering. 3+ years of SSIS development experience. Hands-on experience migrating SSIS workloads to: Azure Data Factory Microsoft Fabric Databricks Synapse Analytics Experience with data validation and reconciliation during migration projects. Ability to estimate migration effort and identify dependencies.

Job Title - Web Module Lead-H1b only Location - Plano TX-Local only Experience - 10-14 Years Job Description - Key Responsibilities SSIS Migration & Modernization (Mandatory) Analyze and assess existing SSIS packages
ETL workflows
and dependencies. Design migration strategies for SSIS workloads to modern cloud-based or enterprise data platforms. Re-engineer ETL logic while preserving business functionality. Develop migration accelerators
reusable frameworks
and automation solutions. Perform end-to-end migration
testing
deployment
and production support. Data Engineering Design and build scalable data pipelines. Develop data ingestion
transformation
and orchestration processes. Implement data quality and validation frameworks. Support batch and near-real-time data processing requirements. Database Development Develop and optimize complex T-SQL queries
views
procedures
and functions. Perform SQL performance tuning and troubleshooting. Implement data reconciliation and validation processes. Data Warehousing Design and support enterprise data warehouse solutions. Work with Fact
Dimension
Star Schema
and Snowflake Schema models. Implement CDC and SCD strategies. Cloud Data Platforms Develop and support cloud-native data integration solutions. Participate in migration of on-premises data workloads to cloud environments. Support CI/CD implementation for data pipelines. Required Skills Core Technologies SQL Server T-SQL SSIS Package Development SSIS Package Analysis and Migration ETL/ELT Design Data Migration SQL Performance Tuning Data Warehousing Dimensional Modeling Star Schema Snowflake Schema Fact and Dimension Modeling CDC SCD Cloud & Modern Data Engineering Experience in one or more: Azure Data Factory (ADF) Azure Synapse Analytics Microsoft Fabric Azure Data Lake Storage (ADLS) Databricks Apache Spark / PySpark Reporting & Analytics SSRS Power BI Programming & Scripting Python PowerShell C# .NET DevOps Azure DevOps Git CI/CD Pipelines Preferred Experience 5+ years of experience in ETL/Data Engineering. 3+ years of SSIS development experience. Hands-on experience migrating SSIS workloads to: Azure Data Factory Microsoft Fabric Databricks Synapse Analytics Experience with data validation and reconciliation during migration projects. Ability to estimate migration effort and identify dependencies.

Summary

Location - Plano TX-Local only

Experience - 10-14 Years

Job Description -

Key Responsibilities

SSIS Migration & Modernization (Mandatory)

Analyze and assess existing SSIS packages, ETL workflows, and dependencies.
Design migration strategies for SSIS workloads to modern cloud-based or enterprise data platforms.
Re-engineer ETL logic while preserving business functionality.
Develop migration accelerators, reusable frameworks, and automation solutions.
Perform end-to-end migration, testing, deployment, and production support.

Data Engineering

Design and build scalable data pipelines.
Develop data ingestion, transformation, and orchestration processes.
Implement data quality and validation frameworks.
Support batch and near-real-time data processing requirements.

Database Development

Develop and optimize complex T-SQL queries, views, procedures, and functions.
Perform SQL performance tuning and troubleshooting.
Implement data reconciliation and validation processes.

Data Warehousing

Design and support enterprise data warehouse solutions.
Work with Fact, Dimension, Star Schema, and Snowflake Schema models.
Implement CDC and SCD strategies.

Cloud Data Platforms

Develop and support cloud-native data integration solutions.
Participate in migration of on-premises data workloads to cloud environments.
Support CI/CD implementation for data pipelines.

Required Skills

Core Technologies

SQL Server
T-SQL
SSIS Package Development
SSIS Package Analysis and Migration
ETL/ELT Design
Data Migration
SQL Performance Tuning

Data Warehousing

Dimensional Modeling
Star Schema
Snowflake Schema
Fact and Dimension Modeling
CDC
SCD

Cloud & Modern Data Engineering

Experience in one or more:

Azure Data Factory (ADF)
Azure Synapse Analytics
Microsoft Fabric
Azure Data Lake Storage (ADLS)
Databricks
Apache Spark / PySpark

Reporting & Analytics

SSRS
Power BI

Programming & Scripting

Python
PowerShell
C#
.NET

DevOps

Azure DevOps
Git
CI/CD Pipelines

Preferred Experience

5+ years of experience in ETL/Data Engineering.
3+ years of SSIS development experience.
Hands-on experience migrating SSIS workloads to:

Azure Data Factory
Microsoft Fabric
Databricks
Synapse Analytics

Experience with data validation and reconciliation during migration projects.
Ability to estimate migration effort and identify dependencies.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 90838445
Position Id: 9095351
Posted 3 hours ago

Contact the job poster

Krishna Saravanan

Recruiter @ HAN IT Staffing Inc.

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Irving, Texas

•

Today

Job Description Data Migration Lead Data Warehouse & Reporting Experience: - 12+ Years Location: - Remote What is in it for you? We're looking for a Data Migration Lead with deep, hands-on experience in the data warehousing world to own end-to-end data migration efforts across our DW and Reporting ecosystem. The ideal candidate has spent significant years as a tech lead, managed complete SDLC cycles, and can independently run the show with a data-driven approach - while communicating clearl

Easy Apply

Third Party

Data Engineer (W2 - NO SPONSORSHIP AVAILABLE)

Plano, Texas

•

Today

Location: Plano, TX Salary: $100,000.00 USD Annually - $135,000.00 USD Annually Description: Data Engineer Location: Camas, WA or Plano, TX Fulltime About the Role We are seeking a talented Data Engineer to join our growing Data Delivery team. In this role, you will design, develop, and implement modern data solutions leveraging cloud technologies, enterprise data platforms, and AI-driven innovations. You will collaborate with business and technology teams to build scalable, secure, and high-p

Full-time

USD 100,000.00 - 135,000.00 per year

Data Migration Lead

Remote

•

5d ago

Hi Professionals, Data Migration Lead Experience: 12+ years, with significant Data Warehousing + Tech Lead experience. Core Ownership: Lead end-to-end data migration projects across DW and Reporting platforms. SDLC: Own requirements, planning, design, development, testing, deployment, and delivery. SQL: Strong hands-on complex SQL, optimization, validation, reconciliation, and performance tuning. Data Warehousing: Strong knowledge of dimensional modeling, Star/Snowflake schemas, ETL/ELT.

Easy Apply

Contract, Third Party

Depends on Experience

Data Migration Lead Data Warehouse & Reporting

Remote

•

Today

Data Migration Lead Data Warehouse & Reporting Experience: - 12+ Years Location: - Remote Responsibilities: - Lead data migration initiatives across DW and reporting platforms, owning design, development, and testing phases end-to-end Manage the complete SDLC for migration projects - requirements, planning, execution, testing, and delivery Write and optimize complex SQL queries for data extraction, transformation, validation, and reconciliation Build proof-of-concepts (POCs) for report analys

Easy Apply

Third Party, Contract

Search all similar jobs

More jobs at HAN IT Staffing Inc. in Plano, TX

Web Module Lead - SSIS Migration & Modernization (Mandatory)

Dice Job Match Score™

Job Details

Skills

Summary

Krishna Saravanan

Similar Jobs