Must Have Skills -

1. Strong experience in Data Engineering
2. Snowflake - Strong hands-on implementation experience in Snowflake
3. Strong understanding of Snowflake Architecture - experience with designing and building solutions.
   1. Architecture, design aspects, performance tuning, time travel, warehouse concepts - scaling, clustering, micro-partitioning
   2. Experience with SnowSQL, Snowpipe
   3. Experience with Snowflake performance optimization techniques
4. Advanced SQL - Hands-on experience with writing Complex queries using - Joins, Self Joins, Views, Materialized Views, Cursor also Recursive, use of GROUP BY, PARTITION BY functions / SQL Performance tuning
5. Hands-on experience with ETL and Dimensional Data Modelling -
   1. Slowly Changing Dimensions (SCD - Type 1, 2, 3)
   2. Good understanding of concepts like schema types, table types - fact-dimension etc. like how to design a dimension vs fact, design considerations factored etc.
6. Python - Proficiency in Python scripting/programming - using Pandas, PyParsing, Airflow.
   1. Pandas, Tableau server modules, Numpy, Datetime, Apache Airflow related modules, APIs
   2. Setting up Python scripts on DataLab, scheduling processes, connecting with DataLake (S3 etc )
   3. Data Pipeline automation

Good experience with ETL Frameworks