Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by TCS Team. If you also belong to the team, you can get access from here

TCS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

TCS Snowflake Developer Interview Questions, Process, and Tips

Updated 5 Nov 2024

Top TCS Snowflake Developer Interview Questions and Answers

View all 12 questions

TCS Snowflake Developer Interview Experiences

7 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I appeared for an interview in May 2024.

Round 1 - Technical 

(8 Questions)

  • Q1. Self Intro and current project
  • Q2. Snowflake architecture
  • Q3. Stream and task
  • Q4. How to optimize sql query
  • Ans. 

    Optimizing SQL queries involves using indexes, minimizing data retrieval, and avoiding unnecessary joins.

    • Use indexes on columns frequently used in WHERE clauses

    • Minimize data retrieval by selecting only necessary columns

    • Avoid unnecessary joins by using subqueries or temporary tables

  • Answered by AI
  • Q5. Purpose of time travel
  • Ans. 

    Time travel is a theoretical concept that involves moving between different points in time.

    • Time travel is a popular theme in science fiction literature and movies.

    • The concept of time travel raises questions about causality and the nature of time.

    • Some theories suggest that time travel could be possible through wormholes or time machines.

  • Answered by AI
  • Q6. What will happen to cache if the query has changed
  • Ans. 

    The cache will be invalidated and refreshed when the query changes.

    • When the query changes, the cache will be invalidated to ensure accurate results.

    • The system will refresh the cache with the updated query results.

    • This helps prevent outdated or incorrect data from being served from the cache.

  • Answered by AI
  • Q7. Rate urself in sql out of 10
  • Ans. 

    I would rate myself 8 out of 10 in SQL. I have strong knowledge and experience in writing complex queries and optimizing database performance.

    • Strong understanding of SQL syntax and commands

    • Experience in writing complex queries involving multiple tables and joins

    • Knowledge of database optimization techniques

    • Familiarity with Snowflake specific SQL functions and features

  • Answered by AI
  • Q8. One scenario based question from sql

Skills evaluated in this interview

Snowflake Developer Interview Questions & Answers

user image Ankita Agrawal

posted on 11 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Cache concept and type of cache
  • Ans. 

    Cache is a hardware or software component that stores data to reduce future data retrieval time.

    • Cache is used to store frequently accessed data for quick retrieval.

    • Types of cache include CPU cache, web cache, and browser cache.

    • Cache helps improve performance by reducing the need to access data from slower storage mediums.

    • Examples of cache include L1, L2, and L3 caches in CPUs, and caching mechanisms in web browsers.

    • Cac...

  • Answered by AI
  • Q2. Row level security and streams

Skills evaluated in this interview

Snowflake Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. While creating a custom role which role should have the access to ... read more
asked in Cognizant
Q2. What feature in Snowflake's architecture and pricing model set is ... read more
asked in TCS
Q3. in bulk loading what is the size data gets loaded
asked in Infosys
Q4. How snowflake differs from industry competetors? What is the extr ... read more
asked in TCS
Q5. What is varient data type
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Data warehouse concepts and snowflake architecture
  • Q2. Snowflake functionalities
  • Ans. 

    Snowflake is a cloud-based data warehousing platform that offers features like data sharing, scalability, and performance.

    • Snowflake allows for easy data sharing between organizations and departments.

    • It offers scalability by allowing users to easily resize their computing resources based on their needs.

    • Snowflake provides high performance through its unique architecture that separates storage and compute.

    • It supports vari...

  • Answered by AI
  • Q3. Types of caches
  • Ans. 

    Types of caches include memory cache, disk cache, and browser cache.

    • Memory cache stores data in memory for quick access.

    • Disk cache stores data on disk for faster retrieval than from the original source.

    • Browser cache stores web page elements locally to reduce loading times.

    • Other types include CPU cache, page cache, and object cache.

  • Answered by AI
  • Q4. Tasks and functions

Interview Preparation Tips

Interview preparation tips for other job seekers - revise concepts

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL query on joins
  • Q2. Query on Lag function

TCS interview questions for designations

 Developer

 (46)

 Software Developer

 (501)

 Java Developer

 (184)

 Salesforce Developer

 (35)

 Web Developer

 (33)

 Python Developer

 (28)

 Application Developer

 (18)

 Plsql Developer

 (16)

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Snowflake architecture, snowpipe, zero copy clone

Get interview-ready with Top TCS Interview Questions

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Good questions with detailed interview

Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain Snowflake architecture
  • Ans. 

    Snowflake architecture is a cloud-based data warehousing platform that separates storage and compute resources for scalability and performance.

    • Snowflake uses a unique architecture with separate storage and compute layers.

    • Data is stored in scalable and durable storage, while compute resources can be scaled independently for processing.

    • Snowflake's architecture allows for automatic scaling, high performance, and concurren...

  • Answered by AI
  • Q2. Contains 3 layers

I applied via LinkedIn and was interviewed in Oct 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(5 Questions)

  • Q1. What is varient data type
  • Ans. 

    Variant data type is a flexible data type in Snowflake that can store semi-structured and nested data.

    • Variant data type can store JSON, Avro, ORC, and Parquet data formats.

    • It allows for querying and manipulating semi-structured data without the need for schema changes.

    • Example: A variant column can store a JSON object with nested arrays and objects.

  • Answered by AI
  • Q2. Difference between union and join
  • Ans. 

    Union combines rows from two or more tables, while join combines columns from two or more tables.

    • Union appends the rows of one table to another, while join combines columns of two tables based on a common column.

    • Union does not require a common column, while join requires a common column to match the rows.

    • Union removes duplicates, while join retains duplicates.

    • Union can be used to combine tables with different columns, ...

  • Answered by AI
  • Q3. Explain snowflake architecture
  • Ans. 

    Snowflake architecture is a cloud-based data warehousing solution that separates storage, compute, and services.

    • Snowflake uses a unique multi-cluster, shared data architecture.

    • It separates storage, compute, and services, allowing for independent scaling.

    • Data is stored in a columnar format, allowing for efficient querying and analysis.

    • Snowflake also offers automatic scaling and concurrency control.

    • It supports multiple c...

  • Answered by AI
  • Q4. In bulk loading what is the size data gets loaded
  • Ans. 

    The size of data loaded in bulk loading varies based on the file format and compression used.

    • The size of data loaded can range from a few MBs to several GBs.

    • The file format used can impact the size of data loaded.

    • Compression can reduce the size of data loaded.

    • Snowflake supports various file formats like CSV, JSON, Parquet, etc.

    • Examples: A CSV file of 1 GB can be loaded in a few minutes.

    • A compressed Parquet file of 10 G

  • Answered by AI
  • Q5. While creating a custom role which role should have the access to it
  • Ans. 

    The role with the highest level of access should create the custom role.

    • The role with the highest level of access should have the ability to manage roles and grant permissions.

    • This ensures that the custom role is created with the appropriate level of access and permissions.

    • For example, if the custom role is for a specific department, the department manager role should create it.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for TCS Snowflake Developer interview:
  • Snowflake
  • SQL
Interview preparation tips for other job seekers - Focus more on basic like architecture , how unstructured data is loaded etc

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

    • Use the ORDER BY clause to sort the table in descending order.

    • Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.

Interview Preparation Tips

General Tips: This interview was a technical one but was majorly a stress test. It lasted for about 1 hour 10 minutes. The interviewer wanted to test both my knowledge and communication skills. Most of the questions asked to me were related to my B.Tech curriculum i.e. computer science related topics. He stressed a lot on the basics related to my project topic. Luckily I was able to answer most of the questions correctly. I tried to answer each question with examples and also used props on the table (like pens, paperweights, pen stands etc.) to explain my theories. It was my first offcampus interview, and I think I did pretty well for a fresher.
You need to stay calm and should apply presence of mind. Please go through the job description thoroughly word-by-word and recheck your resume to ensure that you are a best-fit for the position.
Skills: Communication, Body Language, Problem Solving, Leadership, Presentation Skills
Duration: <1 week

TCS Interview FAQs

How many rounds are there in TCS Snowflake Developer interview?
TCS interview process usually has 1-2 rounds. The most common rounds in the TCS interview process are Technical, Resume Shortlist and Coding Test.
How to prepare for TCS Snowflake Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at TCS. The most common topics and skills that interviewers at TCS expect are Data Warehousing, SQL, ETL, AWS and Snowflake.
What are the top questions asked in TCS Snowflake Developer interview?

Some of the top questions asked at the TCS Snowflake Developer interview -

  1. While creating a custom role which role should have the access to...read more
  2. in bulk loading what is the size data gets loa...read more
  3. What is varient data t...read more

Tell us how to improve this page.

TCS Snowflake Developer Interview Process

based on 7 interviews

1 Interview rounds

  • Technical Round
View more
TCS Snowflake Developer Salary
based on 305 salaries
₹2.6 L/yr - ₹10 L/yr
22% less than the average Snowflake Developer Salary in India
View more details

TCS Snowflake Developer Reviews and Ratings

based on 11 reviews

4.1/5

Rating in categories

4.2

Skill development

4.4

Work-life balance

3.3

Salary

4.9

Job security

4.4

Company culture

2.2

Promotions

3.4

Work satisfaction

Explore 11 Reviews and Ratings
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
66.1k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
51.8k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Associate Consultant
30k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹2.2 L/yr - ₹5.8 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview