Apply in 3 Minutes Senior Data Architect

SNOWFLAKE ARCHITECT Location: Bengaluru, Pune, Gurugram, Kolkata, Chennai and Hyderabad Primary Roles and Responsibilities: - Working experience in Snowflake; use of Snow SQL CLI, Snow Pipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc. - Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts - Extensive experience in DBT CLI, DBT Cloud, GitHub version control and repository knowledge, and DBT scripting to design & develop SQL processes to perform complex ELT processes and data pipeline build. - Ability to independently envision and develop innovative ETL and reporting solutions and execute them through to completion. - Triage issues to find gaps in existing pipelines and fix the issues - Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines - Develop and maintain data pipelines using DBT - Provide advice, guidance, and best practices around Snowflake - Provide guidance on moving data across different environments in Snowflake - Create relevant documentation around database objects - Troubleshoot production support issues post-deployment and come up with solutions as required - Good Understanding and knowledge of CI/CD process and GitHub->DBT-> Snowflake integrations. - Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge of stored procedures. - Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel and understanding how to use these features - Help joiner team members to resolve issues and technical challenges. - Drive technical discussions with client architect and team members - Good experience in developing scripts for data auditing and automating various database platform manual activities. - Understanding of the full software lifecycle and how development teams should work with DevOps to create more software faster. Excellent communication, working in Agile Methodology/Scrum. Skills and Qualifications: - Bachelor's and/or master’s degree in computer science or equivalent experience. - Must have total 13+ yrs. of IT experience and 5+ years' experience in data Integration, ETL/ETL development, and database design or Datawarehouse design - Deep understanding of Star and Snowflake dimensional modelling. - Strong knowledge of Data Management principles - Working experience in Snowflake; use of Snow SQL CLI, schema modelling, performance tuning etc. - Develop and maintain data pipelines using DBT - Experience with writing complex SQL queries, especially dynamic SQL - Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts - Experience with performance tuning and optimization of SQL queries - Experience of working with Retail Data - Experience with data security and role-based access controls - Comfortable working in a dynamic, fast-paced, innovative environment with several ongoing concurrent projects - Should have experience working in Agile methodology - Strong verbal and written communication skills. Strong analytical and problem-solving skills with high attention to detail.