Snowflake architect
- Tredence
- 13 - 20 years
- Pune
- 3 months ago
- Email to a friend
- Report this job
Job Description
Role & 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
Preferred candidate profile
- Bachelor's and/or masters degree in computer science or equivalent experience.
- Must have total 13+ yrs. of IT experience and 7+ 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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Solution ArchitectEmployement Type: Full timeContact Details:
Company: TredenceLocation(s): Pune+ View Contact
Keyskills: Snowflake Data Build Tool DBT
Fraud Alert to job seekers!
₹ 45-60 Lacs P.A
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in