We are seeking a Senior Snowflake Developer. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.
Location : Hybrid
- Sacramento, CA (3 days in office)
Visa Status :
USC / GC / GC-EAD / H4-EAD acceptedW2 only (No visa sponsorship available)No 3rd party or C2C candidatesResponsibilities :
Design and implement features for identity and access management.Implement novel query optimization, major security competencies with encryption.Solve performance issues and scalability issues in the system.Create, test, and implement enterprise-level apps with Snowflake.Data warehousing concepts, data modeling, metadata managementMandatory Qualifications :
10 years of experience in database development5 years of experience in Snowflake development and administrationBachelors degree or 7 yrs hands-on experiencePreferred Qualifications :
Knowledge of SQL language and cloud-based technologiesProfound knowledge and hands-on experience in Snowflake Platform Architecture.Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake.Extensive experience in T-SQL stored procedures and complex query development.Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans.Experience with productionized data ingestion and processing pipelines using Snow SQLStrong understanding of CI / CD workflows, unit testing and integration testing, and deployment patterns.Strong ability in documenting design solutions effectively.Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway.Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is a plus.