A software services company in Bengaluru is seeking a candidate with 6-10 years of experience in Snowflake implementations and expertise in SQL and query optimization. The ideal candidate will possess strong problem-solving and communication skills, and the ability to join immediately or within a 30-day notice period.
Qualifications
Minimum 6-10 years of work experience with at least two implementations leveraging Snowflake.
Expert level knowledge in SQL, SnowSQL, query optimization.
In-depth knowledge of Snowflake Virtual Warehouse.
Deep Snowflake features: RBAC, SnowPipe, time travel, data sharing, zero copy cloning, and more.
Exposure to Cortex AI features, data ingestion and ETL processes.
Experience with Jira, Confluence and Agile practices.
Skills
SQL
SnowSQL
Data Modelling
Snowflake concepts
Python
Pyspark
Agile practices
Jira
Confluence
Tools
Jira
Confluence
Job description
Description:
Minimum 6 – 10 years of work experience with at least two projects implementation leveraging Snowflake - either migration from traditional DWHs or a fresh implementation
Expert level knowledge in SQL, SnowSQL, query optimization, performance tuning etc.
Data Modelling: Knowledge of data modelling principles and techniques.
Expertise in Snowflake concepts like setting up Data Masking, Tagging, SnowPipe, RBAC controls, virtual warehouse sizing, zero copy clone, data sharing, Streams & Tasks, Time travel, Secure Data sharing, DMF, iceberg tables, Dynamic Tables, Micro Partition, Query Profiler etc.
Good to have Snowflake advanced concepts on Cortex AI features, search mechanism etc.
Cloud best Practice adoption, strategy development
In depth knowledge of Snowflake Virtual Warehouse, Monitoring Warehouse, Table Structures, Views, Materialized Views, Cloning etc.
Knowledge on Integration (ETL) and Data Ingestion, Data Conversion, and Data Migration.
Technically strong in Python, Pyspark
Exposure to tools like Jira, Confluence and Agile practices
Good to have skills:
Good to have Snowflake Certification
Good to have working experience on DBT
Has peer reviewed documentation
Good analytical, problem-solving and synthesizing skills.
Good Communication and interpersonal skills
Client facing experience required
Has reviewed Functional Specification document and written technical specification document
Well-developed business acumen
Strong problem-solving skills
Strong sense of ownership and accountability of tasks with attention to detail
Priority would be resources who can join immediately or max30 days’ notice period.