Lead Consultant - Snowflake

Responsibilities

 • Should have good experience in DBT
 • Strong experience in building/designing the data warehouse, data lake, and data mart end-to-end implementation experience focusing on large enterprise scale and Snowflake implementations on any of the hyper scalers.
 • Strong understanding on Snowflake Architecture
 • Able to create the design and data modelling independently.
 • Able to create the high level and low-level design document based on requirement.
 • Strong experience with building productionized data ingestion and data pipelines in Snowflake
 • Should have strong experience in migration/greenfield projects in Snowflake.
 • Should have experience in implementing Snowflake best practices for network policy , Storage integration, data governance, cost optimization, resource monitoring, data ingestion, transformation, consumption layers
 • Should have good exp on Snowflake RBAC and data security
 • Should have good experience in implementing strategy for CDC or SCD type 2
 • Strong experience in Snowflake features like Bulk Copy, Snowpipe, Snowpark, SnowSQL, stages, file format, virtual warehouses, time travel, cloning, tables, store procedures, UDFs, Data Sharing, SnowSight.
 • Should have good understanding on ETL processes.
 • Should have good experience in Python.
 • Should have experience in AWS services (S3, Glue, Lambda, Secrete Manager, DMS) and few Azure services (Blob storage, ADLS, ADF)
 • Should have some experience/knowledge in orchestration and scheduling tools experience.
 • Good understanding of agile methodology.
 • Good to have exposure to on-prem databases such as SQL Server, Oracle, PostgreSQL
 • Must to have Snowflake SnowPro Core or SnowPro Advanced Architect certification.
 • Able to create POCs, roadmaps, solution architecture, estimations & implementation plan Experience for Snowflake integrations with other data processing.
 

Minimum Qualifications