Test Automation Lead Snowflake Data Warehouse

As a Test Automation Lead a typical day involves spearheading the evolution of testing practices to establish a seamless and efficient quality engineering process. This role focuses on enhancing the overall control accuracy and integrity of testing activities by integrating advanced tools and methodologies. The position requires driving continuous improvements and fostering innovation in testing approaches ensuring that the quality function remains predictive and intelligent. Collaboration with various teams to implement cutting-edge testing solutions and maintain high standards throughout the software development lifecycle is a key aspect of daily responsibilities. Roles & Responsibilities: - Expected to be an SME collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Provide solutions to problems for their immediate team and across multiple teams.- Lead the adoption of innovative testing tools and methodologies to enhance automation efficiency.- Mentor and guide team members to develop their skills and improve overall team performance.- Coordinate cross-functional efforts to ensure alignment of testing strategies with project Area Skill DescriptionSQL - Advanced Complex Joins Ability to write multi-table joins with efficiencySQL - Advanced Window Functions Expertise in ranking partitioning and analytics functionsSQL - Advanced CTEs & Subqueries Writing optimized nested queriesSQL - Advanced Query Optimization Ability to reduce execution time and costSQL - Advanced Data Aggregation Advanced grouping and aggregation techniquesSnowflake Core Architecture Understanding of Snowflake architecture and storageSnowflake Core Warehousing Virtual warehouse sizing and usageSnowflake Core Performance Tuning Clustering pruning caching techniquesData Modeling Schema Design Star/Snowflake schema design Professional & Technical Skills: - Must To Have Skills: Proficiency in Snowflake Data Warehouse.- Strong knowledge of test automation frameworks and continuous integration/continuous deployment pipelines.- Experience in designing and implementing end-to-end quality engineering processes.- Ability to analyze complex systems and develop predictive testing models.- Familiarity with scripting languages and automation tools to support testing activities.- Excellent problem-solving skills and the ability to innovate within the testing domain. Additional Information: - The candidate should have minimum 5 years of experience in Snowflake Data Warehouse.- This position is based at our Hyderabad office.- A 15 years full time education is required.