Exp: 5+ Years
5+ years experience in MS SQL Server (2012–2019 preferred).
3+ years hands-on experience with Snowflake.
Strong experience with:
T-SQL
Stored procedures and performance tuning
Indexing and query optimization
Strong knowledge of:
Snowflake architecture
Virtual warehouses
Clustering
Time travel & data retention
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