Tata Consultancy Services
Developer
Tata Consultancy Services, San Ramon, California, United States, 94583
Role: Snowflake Developer
Responsibilities: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 and 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 contexts is a plus.
#J-18808-Ljbffr
Responsibilities: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 and 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 contexts is a plus.
#J-18808-Ljbffr