Experience with sound knowledge on database concepts like Entity-relationship, Data modeling, DDL and DML statements etc.
proven experience in Snowflake in data modelling, data pipelines, data governance and performance tuning.
3+ years of SQL performance tuning, SQL / PL-SQL programing, UDF and Packages
Good exposure to Azure SQL server and SQL data warehouse.
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
Leading a team of data engineers and data visualization experts
Leading a team of frontend and backend engineers, product managers, and analysts
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.
Knowledge of Power Bi
Soft Skills
Good Communication and Self-starter, Strong sense of ownership
Managing stakeholder’s expectations and managing good relationship with the working team.
Proven experience in working with on-shore / off-shore Model