Snowflake developer

Mandatory skills* Snowflake Desired skills* Teradata/Python(Not Mandatory) Domain* Data Warehousing, Business Intelligence Precise Work Location Bhubaneswar, Bangalore, Hyderabad, Pune A day in the life of an Infoscion As part of the Infosys consulting team, your primary role would be to actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation and design and deployment You will explore the alternatives to the recommended solutions based on research that includes literature surveys, information available in public domains, vendor evaluation information, etc. and build POCs You will create requirement specifications from the business needs, define the to-be-processes and detailed functional designs based on requirements. You will support configuring solution requirements on the products; understand if any issues, diagnose the root-cause of such issues, seek clarifications, and then identify and shortlist solution alternatives You will also contribute to unit-level and organizational initiatives with an objective of providing high quality value adding solutions to customers. If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! 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