Role - Technical Lead

Experience - 10+ Years of relevant experience

Location - Singapore

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:

• Architecture, design aspects, performance tuning, time travel, warehouse concepts - scaling, clustering, micro-partitioning
• Experience with SnowSQL, Snowpipe
• 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 -

• Slowly Changing Dimensions (SCD - Type 1, 2, 3)
• 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.

• Pandas, Tableau server modules, Numpy, Datetime, Apache Airflow related modules, APIs
• Setting up Python scripts on DataLab, scheduling processes, connecting with DataLake (S3 etc )
• Data Pipeline automation

7) Good experience with ETL Frameworks