Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Required:

• Must have at least 5+ years of experience working as a Snowflake Data Architect and 10+ years of experience in Data Warehouse, ETL, and BI projects area.
• Must have prior experience in end-to-end implementation of multi account Snowflake architecture, including deployment model.
• Data governance expertise in snowflake, including column-level data security, and dynamic data masking features.
• Expertise in design and development of secure access to objects in Snowflake with Role-Based Access Control (RBAC), including data access and functional roles.
• Expertise in deploying Snowflake features such as data sharing, zero copy cloning, streamlit, Snowpark, Stored procedures, materialized views etc.
• Expertise in recovery methods and agile development with Time Travel & Cloning.
• Experience in establishing CICD pipeline automation to deploy and manage snowflake code/objects using GitHub, Schema Change etc.
• Experience is setting up monitoring of snowflake accounts, including user activities, credits consumption, warehouses utilization, workloads etc.
• Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
• Experience in re-clustering of the data in Snowflake with good understanding of micro-Partitions.
• Experience in Data Migration from on premise 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 AWS data storage and management technologies such as S3, EC2, Lambda, Redshift, RDS.
• Certified Snowflake Architect (Desirable).
• Should be able to troubleshoot problems across infrastructure, platform, and applications.
• Must have experience of Agile development methodologies.
• Strong verbal and written communication skills.