Snowflake DBT Developer

TCS is Hiring Snowflake DBT Developer For Bangalore, Pune, Hyderabad, Bhubaneswar, Chennai, Kochi location

Experience : 6 - 8 years

Mode of interview : Virtual

Location : Bangalore, Pune, Hyderabad, Bhubaneswar, Chennai, Kochi

JOB DESCRIPTION : Must have :

Technical Skills

• 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