Cloud Data Architect (Snowflake / DBT)

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

Looking for Quick Joiners

• 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