Dear All,
we are looking strong candidates for snowflake developer with SQL.
- Snowflake (Cloud Data Warehouse) :
- Good understanding of Snowflake ECO system
- 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
- Need to guide the team and provide the technical solutions
- Need to prepare the technical solution and architectures as part of project requirements
- Virtual Warehouse (Compute) - Good Understanding of Warehouse creation & manage
- Data Modeling & Storage - Strong knowledge on LDM / PDM design
- Data Loading / Unloading and Data Sharing- Should have good knowledge
- SnowSQL (CLI)- Expertise and excellent understanding of Snowflake Internals and Integration
- Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques
- Good knowledge on SNOWSQL Scripts preparation the data validation and Audits
- SnowPipe – Good knowledge of Snow pipe implementation
- Expertise and excellent understanding of S3 - Internal data copy / movement
- Good knowledge on Security & Readers and Consumers accounts
- Good knowledge and hands on experience on Query performance tuning implementation techniques
- DBT ( Data Build Tool) hands on experience with all modules :
- In depth hands on experience in DBT CLI and DBT Cloud and GitHub version control and code repository knowledge.
- Design and develop DBT models and build the data pipeline processes to perform complex ELT processes as per DBT scripting.
- 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