Snowflake Consultant in SFO/San Ramon, CA

Overview

Hybrid
$0+
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Snowflake
Snow SQL
Snow Pipes
Streams
Dynamic tables
SQL
T-SQL
Azure SQL MI
ADLS and ADF
Jira
ServiceNow
Confluence
Azure Devops

Job Details

Greetings!

Role: Snowflake Consultant

Location: SFO /San Ramon, CA

Duration: 12+ months

Job description:

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

Thanks & Regards

Nitish

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About FSTONE Technologies