Data Engineer (SSIS)

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 Eligible to workimize 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., * 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.