Sr. Snowflake Developer with Admin experience

Location : San Francisco/San Roman (in client office atleast 4 days/week)

JD-

We are looking for a Senior Snowflake Developer with a minimum of 12 years of experience in database development and 3-5 years of experience in Snowflake development and administration. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.

The following technical skills are required for this role:

• Proficiency inSQL language and cloud-based technologies.
• Extensive experience in T-SQL stored procedures and complex query development.
• Deep knowledge and hands-on experience withSnowflake Platform Architecture
• Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.
• Excellent understanding of Snowflake internals, stages, integrations, and network policies
• Experience in SnowSQL, SnowPipes, Streams, Dynamic tables and Views.
• Ability to design and implement features for identity and access management
• Expertise in query optimization, data masking and major security competencies, including encryption
• Ability to solve performance and scalability issues within the system
• Proficient in SQL query performance tuning, including use of Query Profiler, micro-partition pruning, data spilling, and understanding optimizer and execution plans
• Experience with productionized data ingestion and processing pipelines using Snow SQL.
• Proficient in designing and implementing CI/CD release pipelines using tools like Redgate Flyway for deploying database scripts and objects to Snowflake.
• Data warehousing concepts, data modeling, metadata management
• Create, test, and implement enterprise-level apps with Snowflake
• Experience in integrating snowflake with other data processing andreporting technologies such as SSRS, Tableau reports.
• Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns.
• Strong ability in documenting solutions and architectures effectively.
• Experience inAzure cloud services including Azure SQL MI, ADLS and ADF, particularly in database and data management contexts.
• Familiarity with tools such asJira, ServiceNow, Confluence, Azure Devops.
• Excellent communication skills and the ability to work effectively with various technical and business teams.

  Regards

  Abhi Kaushik (Senior Manager) | Virtusoft Inc