Overview:
We are seeking a skilled Snowflake Developer to design, develop, and manage scalable data solutions using the Snowflake cloud data platform. The ideal candidate will have deep experience in data warehousing, SQL development, ETL processes, and cloud data architecture. Understanding of Control M and Tableau will be an added advantage.
Responsibilities:
- Design, develop, and manage scalable data solutions using Snowflake.
- Drive technical discussions on Data modeling and Dimensional Modeling and techniques with IT, Business, Architects, and Data Modelers.
- Guide the team and provide technical solutions.
- Prepare technical solutions and architectures as part of project requirements.
- Manage and understand Snowflake Virtual Warehouses.
- Design LDM/PDM.
- Handle Data Loading/Unloading and Data Sharing.
- Develop and optimize SNOWSQL queries and Stored procedures.
- Prepare SNOWSQL scripts for data validation and Audits.
- Implement SnowPipe.
- Understand and utilize S3 for internal data copy/movement.
- Understand Snowflake Security, Readers, and Consumers accounts.
- Implement Query performance tuning techniques.
- Write complex SQL queries using Analytical functions.
- Troubleshoot, problem solve, and performance tune SQL queries accessing data warehouse.
Requirements:
- Good understanding of Snowflake ECO system.
- Good experience on Data modeling and Dimensional Modeling.
- Strong knowledge on LDM/PDM design.
- Good knowledge on Data Loading/Unloading and Data Sharing.
- Expertise and excellent understanding of Snowflake Internals and Integration.
- Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques.
- Good knowledge on SNOWSQL Scripts preparation for data validation and Audits.
- Good knowledge of Snow pipe implementation.
- Expertise and excellent understanding of S3.
- Good knowledge on Security & Readers and Consumers accounts.
- Good knowledge and hands on experience on Query performance tuning implementation techniques.
- Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions.
- Strong knowledge on stored procedures.
- Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse.
- (Added Advantage): Understanding of Control M and Tableau.