Job Description

:

--------------------



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:

---------------------------



Primary skills Cloud Platform Snowflake Technology Database Teradata Technology OpenSystem Python OpenSystem

Additional Responsibilities:

--------------------------------



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

Preferred Skills:

---------------------


Cloud Platform->Snowflake,Technology->OpenSystem->Python - OpenSystem,Technology->Database->Teradata