Hiring for Snowflake DBT developer

Dear Tech Professional

Greetings 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 developer

Location : Chennai / Bengaluru / Hyderabad / Pune / Kochi / Bhubaneshwar

Interview Mode : Virtual mode (Microsoft Teams)

Exp : 10-15 Years

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

Regards,

Prashaanthini