Only on W2

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 10 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 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.