We are looking for a Senior Snowflake Developer with a minimum of 10 years of experience in database development and 3-4 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:
• Knowledge of SQL language and cloud-based technologies
• Profound 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.
• 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
• 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 SQL
• Data warehousing concepts, data modeling, metadata management
• Create, test, and implement enterprise-level apps with Snowflake
• Strong 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 plus.