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

Key Responsibilities:

• 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

Technical Requirements:

• Mandatory skills Snowflake
• Desired skills Teradata Python Not Mandatory
• Domain Data Warehousing Business Intelligence
• Precise Work Location Bhubaneswar Bangalore Hyderabad Pune

Additional Responsibilities:

• 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

Preferred Skills: