Snowflake Architect - REMOTE
Data warehouse
Strategy/implementation
Snowflake
Techno functional
Job Description
· Bachelor's degree in Computer science or equivalent, with minimum 12+ Years of experience in relevant field.
· Should have experience in understanding & architecting and end to end data ecosystem comprising Data Ingestion, Data Quality, Data Processing, Data Consumption & Data Storage
· Participate in the development of cloud data warehouses (Snowflake) and business intelligence solutions
· Should have 3+ years' experience working in snowflake and Data warehouse, ETL, BI projects
· Must have experience in ETL tool such as Informatica, Talend, Matillion etc.
· Preferred experience of one end to end implementation of Snowflake cloud data warehouse and on-premise preferably on RDBMS or NOSQL.
· Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures.
· 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
· Hands-on experience with Snowflake utilities, SnowSQL and SnowPipe
· Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
· Should have experience on working on REST APIs, MuleSoft connector
· Must be able to communicate with business and Sr. Architects and pass the details to team for timely deliverables
· Should have experience in solutioning of complex business requirements