1. Expertise in Snowflake - ELT using Snowflake SQL, implementing complex stored Procedures and build data pipelines using DBT(Data Build Tool)
2. Hands-on experience with Snowflake utilities, SnowSQL, DBT and Datastage
Positive to Have:
1. Exposure to job scheduling/monitoring environments(Eg. Control-M)
2. Any Big data tools Hadoop, Spark.
3. Cloud migration experience
Role & responsibilities :
- Work with Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone and understand how to use these features
- Ability to provide resolution to an extensive range of complicated data pipeline related problems using DBT
- Build processes supporting data transformation, data structures, metadata, dependency and workload management