Proficiency in Snowflake scripting - stored procedures (SQL), user defined functions, Common Table expressions, Window functions.
Experience in creation of Snowpark python procedures and user defined functions.
Knowledge of Snowpark architecture, creation of Snowpark data frames, data transformations in Snowpark.
Process Parquet, JSON semi structured data in Snowflake using parse_json, lateral flatten
DBT (Data build tool) DBT Cloud and DBT core hands on experience in creating models as per requirements.
DBT experience in creating and using macros, jinja scripting, hooks, automated tests, snapshots, DBT packages.
Experience implementing data sharing, replication, dynamic data masking using masking policies, secure views, row access policies.
Usage of tags, streams, tasks, external tables, time travel, clone, storage integration, stages, file format, clustering of larger tables on clustering keys, role-based access control
Identify and fix performance issues in Snowflake and DBT
Experience working Visual Studio Code IDE.
Familiarity with git concepts like creation of branches, cloning of repo, creation of pull requests.
Knowledge of Apache airflow to schedule pipelines.
Ability to create DB models to load dimensional models consisting of facts, dimensions.
Knowledge of Azure Devops pipelines, agents, repos.
Understanding of AWS services S3, Private link, IAM roles, security groups, VPC end points
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT SecurityRole: IT Security - OtherEmployement Type: Full time