Snowflake AdministratorAs a Snowflake Administrator, you will be involved in setting up, deploying and maintaining Snowflake cloud platform, you may look forward to collaborating with some of the best talent in the industry to create innovative high quality and defect-free solutions to meet our clients’ business needs. We drive a learning culture, where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.2+ years of supporting and setup of Snowflake platform, Accounts, Users etcDefine standard methodologies and processHelp with performance optimizationsTune both storage and compute platformGuide team on Snowflake usageSnowflake certified would be a plusMaintain deep understanding of complementary technologies and help organizations leverage Snowflake as part of their larger technology stackProvide guidance on how to resolve customer-specific technical challengesBuild, design, architect and implement high-volume, high-scale data analytics and machine learning Snowflake solutions in the cloud.Design and develop features, understand customer requirements and meet business goals.Build high quality and highly reliable software to meet the needs to the largest customers. Implement, monitor & maintain complex Snowflake solutionsMinimum 8 years of experience in ETL design and development utilizing ETL tools alongside Snowflake (FiveTran, Workato, Stitch / Talend, Matillion)Should have knowledge of on how data get processed and consumed in Snowflake and how to automate the completed process.Adding Servers /Clusters to warehouses when needed to improve performanceCreating Roles with Access control privileges (DML/DDL/DCL) to access the database to work on.Creating users to access snowflake warehouses from both UI and SNOWSQLTuning SQL queriesProviding JDBC/ODBC drivers to connect BI tools(Tableau, Qlickview)Training sessions and documentation related to error handling.Experience in building Snowpipe.In-depth knowledge of Data Sharing in Snowflake.In-depth knowledge of Snowflake Database, Schema and Table structures.Experience in using Snowflake Clone and Time Travel.In-Depth knowledge of Automatic ClusteringPerformance tuning of SQL queries using different services provided by Snowflake.Worked with both Maximized and Auto-scale functionality.Used Temporary and Transient tables on diff datasets.Work closely with application developers to create and improve data flows between internal/external systems and the data warehouse.Monitor the system performance by performing regular tests, troubleshooting and integrating new features.Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controlsWorked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.Experience with AWS data storage and management technologies such as S3 and ADLSExperience in Data Migration from RDBMS to Snowflake cloud data warehouse.Provide troubleshooting and diagnostic support at L2/L3 level for DB.Confidence training and guiding colleagues through complex technical challenges and best practice.