Snowflake Developer at Tata Consultancy Services
San Ramon, CA 94583
About the Job
Job Role: Snowflake Developer
Job Location: San Ramon, CA 94583//San Francisco, CA 94104
- 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
- Experience in integrating Snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.
- 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 Azure cloud services including Azure SQL MI and ADF, particularly in database and data management
Salary
116,000 - 120,000 /year