Team Lead

Dear All,

we are looking strong candidates for snowflake developer with SQL.

1. Snowflake (Cloud Data Warehouse):
2. Good understanding of Snowflake ECO system
3. Good experience on Data modeling and Dimensional Modeling and techniques and will be able to drive the Technical discussions with IT & Business and Architects / Data Modelers
4. Need to guide the team and provide the technical solutions
5. Need to prepare the technical solution and architectures as part of project requirements
6. Virtual Warehouse (Compute) - Good Understanding of Warehouse creation & manage
7. Data Modeling & Storage - Strong knowledge on LDM/PDM design
8. Data Loading/Unloading and Data Sharing- Should have good knowledge
9. SnowSQL (CLI)- Expertise and excellent understanding of Snowflake Internals and Integration
10. Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques
11. Good knowledge on SNOWSQL Scripts preparation the data validation and Audits
12. SnowPipe – Good knowledge of Snow pipe implementation
13. Expertise and excellent understanding of S3 - Internal data copy/movement
14. Good knowledge on Security & Readers and Consumers accounts
15. Good knowledge and hands on experience on Query performance tuning implementation techniques
16. DBT ( Data Build Tool) hands on experience with all modules :
17. In depth hands on experience in DBT CLI and DBT Cloud and GitHub version control and code repository knowledge.
18. Design and develop DBT models and build the data pipeline processes to perform complex ELT processes as per DBT scripting.
19. Good knowledge and hands on experience on dbt concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses, write complex SQL queries.

Total experience - 5-11 Yrs.

Location- Bangalore /Hyderabad/ Pune.

Notice period - Immediate /10 Days

Skills Required
Performance Tuning, Data Modeling, Github, S3, Dimensional Modeling, Data Loading, Sql, data sharing , Snowpipe, Stored Procedures