Snowflake Data Engineer

Snowflake Data Engineer

· Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design of the solution, including class, sequence, and deployment infrastructure diagrams.

· Take ownership of technical solutions from design perspective for on-going projects.

· Prior experience with application delivery using an Onshore/Offshore model

· Experience with gathering end user requirements and writing technical documentation

· Suggest innovative solutions based on new technologies and latest trends to sales team.

· Work closely with sales team and clients to understand their business, capture requirements, identify pain areas, accordingly, propose an ideal solution and win business.

· Must have total 5+ years of experience working as a Snowflake Data Engineer and 8 years in Data Warehouse, ETL, BI projects.
· Must have prior experience with end to end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premise preferably on Oracle.
· 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 and understand how to use these features
· Expertise in deploying Snowflake features such as data sharing.
· Hands-on experience with Snowflake utilities, SnowSQL, Snow Pipe, Big Data model techniques using 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 expertise in AWS or Azure Platform as a Service (PAAS).
· Certified Snowflake cloud data warehouse Architect (Desirable).
· Should be able to troubleshoot problems across infrastructure, platform and application domains.
· Must have experience of Agile development methodologies
· Strong written communication skills. Is effective and persuasive in both written and oral communication