Snowflake Developer

• Has good knowledge on Snowflake Architecture
• Understanding Virtual Warehouses multi cluster warehouse autoscaling
• Metadata and system objects query history grants to users grants to roles users
• Micro partitions
• Table Clustering Auto Reclustering
• Materialized Views and benefits
• Data Protection with Time Travel in Snowflake extremely imp
• Analyzing Queries Using Query Profile extremely important Explain plan
• Cache architecture
• Virtual Warehouse VW
• Named Stages
• Direct Loading
• SnowPipe Data Sharing Streams JavaScript Procedures Tasks
• Strong ability to design and develop workflows in Snowflake in at least one cloud technology preferably AWS
• Apply Snowflake programming and ETL experience to write Snowflake SQL and maintain complex internally developed Reporting system
• Preferable knowledge in ETL Activities like data processing from multiple source systems
• Extensive Knowledge on Query Performance tuning
• Apply knowledge of BI tools
• Manage time effectively
• Accurately estimate effort for tasks and meet agreed upon deadlines
• Effectively juggle ad hoc requests and longer term projects
• Snowflake performance specialist
• Familiar withzero copy cloningand usingtime travelfeatures to clone table
• Familiar in understandingSnowflake query profileand what each step does andidentifying performance bottlenecks from query profile
• Understanding of when a table needs to be clustered
• Choosing the right cluster keyas a part of table design to help query optimization
• Working with materialized views andbenefits vs cost scenario
• How Snowflake micro partitions are maintained and what are the performance implications wrt micro partitions pruningetc
• Horizontal vs vertical scaling
• When to do what
• Concept of multi cluster warehouse and autoscaling
• Advanced SQL knowledge including window functions recursive queriesand ability to understand and rewritecomplex SQLs as a part of performance optimization

Key Responsibilities:

• Has good knowledge on Snowflake Architecture
• Understanding Virtual Warehouses multi cluster warehouse autoscaling
• Metadata and system objects query history grants to users grants to roles users
• Micro partitions
• Table Clustering Auto Reclustering
• Materialized Views and benefits
• Data Protection with Time Travel in Snowflake extremely imp
• Analyzing Queries Using Query Profile extremely important Explain plan
• Cache architecture
• Virtual Warehouse VW
• Named Stages
• Direct Loading
• SnowPipe Data Sharing Streams JavaScript Procedures Tasks
• Strong ability to design and develop workflows in Snowflake in at least one cloud technology preferably AWS
• Apply Snowflake programming and ETL experience to write Snowflake SQL and maintain complex internally developed Reporting system
• Preferable knowledge in ETL Activities like data processing from multiple source systems
• Extensive Knowledge on Query Performance tuning
• Apply knowledge of BI tools
• Manage time effectively
• Accurately estimate effort for tasks and meet agreed upon deadlines
• Effectively juggle ad hoc requests and longer term projects
• Snowflake performance specialist
• Familiar withzero copy cloningand usingtime travelfeatures to clone table
• Familiar in understandingSnowflake query profileand what each step does andidentifying performance bottlenecks from query profile
• Understanding of when a table needs to be clustered
• Choosing the right cluster keyas a part of table design to help query optimization
• Working with materialized views andbenefits vs cost scenario
• How Snowflake micro partitions are maintained and what are the performance implications wrt micro partitions pruningetc
• Horizontal vs vertical scaling
• When to do what
• Concept of multi cluster warehouse and autoscaling
• Advanced SQL knowledge including window functions recursive queriesand ability to understand and rewritecomplex SQLs as a part of performance optimization

Technical Requirements:

• Mandatory skills Snowflake
• Desired skills Teradata Python Not Mandatory

Additional Responsibilities:

• Domain Data Warehousing Business Intelligence
• Precise Work Location Bhubaneswar Bangalore Hyderabad Pune

Preferred Skills: