Snowflake Architect Job in Ideas2it

LocationFull Time, Chennai

Requirements

• Must have total 7+ yrs. in IT and 2+ years experience working as a snowflake Data Architect and 4+ years in Data warehouse, ETL, BI projects
• Must have experience at least one complex implementation of a Snowflake 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 and understand how to use these features
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe and 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)
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Expertise in AWS, Azure or GCP Platform as a Service (PAAS) components is a plus
• Should be able to develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences
• Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling