Snowflake Developer (10+ Years Experinece)

Hi

Role- Snowflake Developer (Locals only)

Location: San Francisco/San Roman, CA (Onsite role)

JD-

We are looking for a Senior Snowflake Developer with a minimum of 10 years of experience in database development and 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 in SQL language and cloud-based technologies.
• Extensive experience in T-SQL stored procedures and complex query development.
• Deep knowledge and hands-on experience with Snowflake 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 Snow SQL, Snow Pipes, 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 and reporting 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 in Azure cloud services including Azure SQL MI, ADLS and ADF, particularly in database and data management contexts.
• Familiarity with tools such as Jira, ServiceNow, Confluence, Azure Devops.
• Excellent communication skills and the ability to work effectively with various technical and business teams.

Regards