Snowflake Data Engineer

Job description

Must Have - 5-7 Years Overall experience - Sound knowledge on database concepts like Entity-relationship, Data modeling, DDL and DML statements etc. - Good experience in writing complex SQL queries, Analytical functions, Joins, Indexes, functions and stored procedures. - 4+ years of proven experience in Snowflake in data modelling, data pipelines, data governance and performance tuning. - Understanding of Snowflake capabilities like Snowpipe, STREAMS, etc. - Strong understanding of the Snowflake architecture - Understand of Snowflake roles and user security - Understanding of migration, dev/ops, ETL/ELT, and BI required - Understanding of data lineage and good in building such frameworks - Works closely with all business units and engineering teams to develop strategy for long term data platform architecture - Experience in various data cleansing techniques Good to have : - Works closely with a team of frontend and backend engineers, product managers, and analysts - Good to have knowledge of Power Bi in developing dashboard. - Good in analyzing and organizing raw data - Good working experience in Integrating various data sources - Good in building scalable data pipelines using ADF, Databricks including full load and incremental loads - Great numerical and analytical skills - Sound knowledge and proven experience in SQL and PL/SQL including CTEs (Common Table Expressions), Aggregate Functions, sub-queries, cursors, anonymous blocks etc.