Senior Architect

Senior Solutions architect(Snowflake)

Location-Pune, Bengaluru, Hyderabad, Gurugram, Chennai and Kolkata

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.