MS SQL Server – Snowflake Migration Specialist

o T-SQL

o Stored procedures and performance tuning

o Indexing and query optimization

· Strong knowledge of:

o Snowflake architecture

o Virtual warehouses

o Clustering

o Time travel & data retention

o Snowflake security model

Migration Experience

· Proven experience in at least 1–2 end-to-end SQL to Snowflake migrations.

· Experience with ETL/ELT tools.

· Data validation and reconciliation expertise.

Additional Skills (Preferred)

· Experience migrating from MS SQL Server 2016 specifically.

· Experience in cloud platforms (Azure/AWS).

· Familiarity with data warehousing concepts.

· Experience with BI tools (Power BI, Tableau).

Tools & Technologies

· MS SQL Server 2016+

· Snowflake

· SnowSQL / Snowpipe

· Azure Data Factory / Informatica / Matillion

· Power BI / Tableau (Optional)

· Git / DevOps pipelines (Preferred)

Soft Skills

· Strong analytical and problem-solving skills.

· Ability to work under tight timelines.

· Excellent communication and documentation skills.

· Ability to collaborate with application, infra, and business stakeholders.

Deliverables

· Migration strategy document

· Converted schema & code

· Successful data migration with validation report

· Performance benchmarking report

· Production deployment

· KT documentation