Snowflake Architect

1. Snowflake Architect –

• Experience working as a snowflake Data Architect and in Data warehouse, ETL, BI projects.
• Must have experience end to end implementation of Snowflake cloud data warehouse as well as on-premises data warehouse.
• Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel.
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns.
• Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, Big Data model techniques using 0 Python.
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
• Experience with data security and data access controls and design
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot.
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.
• Must have knowledge in AWS or Azure or GCP.
• Certified Snowflake cloud data warehouse Architect is preferable.
• Strong organizational and interpersonal skills
• Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on-going projects.
• Experience with gathering end user requirements and writing technical documentation.
• Suggest innovative solutions based on new technologies and latest trends to sales team.
• Review the architectural/ technological solutions for ongoing projects and ensure right choice of solution.

Last updated on Sep 5, 2023