Hiring for Snowflake DBT developer

Dear Tech ProfessionalGreetings from Tata Consultancy Services (TCS)TCS has always been in the spotlight for being adept in “the next big technologies”. What we can offer you is a space to explore varied technologies and quench your techie soul.What we are looking for : Snowflake DBT developerLocation : Chennai / Bengaluru / Hyderabad / Pune / Kochi / BhubaneshwarInterview Mode : Virtual mode (Microsoft Teams)Exp : 10-15 YearsProficiency 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 flattenDBT (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 controlIdentify and fix performance issues in Snowflake and DBTExperience 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 pointsRegards,Prashaanthini