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

Clear (1)

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 was interviewed 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

 (45)

 Software Developer

 (499)

 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 Resume 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

Interview Questionnaire 

2 Questions

  • Q1. What is precompilaion unit?
  • Ans. 

    Precompilation unit is a compiled code that can be reused by multiple source files.

    • Precompilation unit is created by the compiler from the source code.

    • It contains the compiled code of header files and other dependencies.

    • It can be reused by multiple source files, reducing compilation time.

    • It is also known as precompiled header or PCH.

    • Example: stdafx.h in Visual Studio is a precompiled header file.

  • Answered by AI
  • Q2. About ur future,ur short term goal,why this company

Interview Preparation Tips

Skills: Resume, CGPA
College Name: IIT Kharagpur

Interview Questionnaire 

3 Questions

  • Q1. First 50 Prime Number
  • Ans. 

    The first 50 prime numbers are...

    • Start with 2, the first prime number

    • Check each odd number greater than 2

    • Use trial division to check if a number is prime

    • Stop when you have found 50 prime numbers

  • Answered by AI
  • Q2. How to sort the file in the range (hint provided)
  • Ans. 

    Sorting a file within a range

    • Use a sorting algorithm like quicksort or mergesort

    • Read the file and store the data in an array or list

    • Sort the array or list within the given range

    • Write the sorted data back to the file

  • Answered by AI
  • Q3. Tell me about yourself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications using various technologies.

    • Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

    • Proficient in backend development with Node.js, Express, and MongoDB

    • Familiar with version control systems like Git and project management tools like Jira

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Shortlist cut was 0.0 cgpa
Tips: Need to mention Programming skill in any one of three language C , C++ ,Java

Round: Test
Experience: Test was Average, Many question were from INDIABIX.COM , computer network, operating system ,data structure, c , c++ language
Tips: Understand Data Structure and Algorithm deeply, At least read about computer networks, operating system , DBMS 3-4 times for basic good understand, refer various site
Duration: 180 minutes

Round: Test
Experience: Two question were given , we have to write the code on A4 size sheet
Tips: Deep understanding of STACK AND QUEUE
Duration: 60 minutes

Round: Technical Interview
Experience: Previous Test (2 Questions on A4 size sheet) were discussed and is there any improvement that can be done, discussed each and every step.
Tips: Comments is important using programming
present with demo example (various cases)

Round: HR Interview
Experience: Be calm and show your interest in the company,
ask question about company, what are activity other than techincal technical stuff
Tips: Smile , if possible talk in Hindi - English,Try to Make the interview in discussion

General Tips: Practice Daily , Understand Each and Every Step in Detail , Try to code in A4 size paper then computer
Skill Tips: Read Good Books , Practice Daily

Skills: Algorithms And Data Structures
College Name: IIT Kharagpur

Skills evaluated in this interview

Interview Questionnaire 

19 Questions

  • Q1. Tell me about yoruself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

    • Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React

    • Strong background in computer science with knowledge in algorithms and data structures

    • Passionate about learning new technologies and solving complex problems

  • Answered by AI
  • Q2. Tell me about your projects
  • Ans. 

    I have worked on various projects including a web application for inventory management and a mobile app for fitness tracking.

    • Developed a web application using React for inventory management

    • Created a mobile app using Flutter for fitness tracking

    • Implemented RESTful APIs for communication between frontend and backend systems

  • Answered by AI
  • Q3. Area of interest
  • Ans. 

    My area of interest is artificial intelligence and machine learning.

    • I have experience in developing machine learning models for predictive analytics.

    • I am interested in natural language processing and computer vision applications.

    • I enjoy exploring deep learning algorithms and neural networks.

    • I have worked on projects involving recommendation systems and image recognition.

  • Answered by AI
  • Q4. What are features of C++?
  • Ans. 

    C++ is a high-level programming language with features like object-oriented programming, templates, and memory management.

    • C++ supports object-oriented programming concepts like encapsulation, inheritance, and polymorphism.

    • Templates allow generic programming and code reusability.

    • C++ provides low-level memory manipulation through pointers.

    • Standard Template Library (STL) provides a collection of classes and functions for ...

  • Answered by AI
  • Q5. What is Big Data?
  • Ans. 

    Big Data refers to large and complex data sets that cannot be processed using traditional data processing methods.

    • Big Data is characterized by the 3Vs - Volume, Velocity, and Variety.

    • It requires specialized tools and technologies such as Hadoop, Spark, and NoSQL databases.

    • Examples of Big Data include social media data, sensor data, and financial market data.

  • Answered by AI
  • Q6. Write a program for reversing a string without using string function
  • Ans. 

    Program to reverse a string without using string function

    • Iterate through the string from end to start and append each character to a new string

    • Use a loop to swap the first and last characters, then move towards the middle until the entire string is reversed

    • Convert the string to a character array, then swap the first and last elements until the entire array is reversed

  • Answered by AI
  • Q7. What is your role in final year project?
  • Ans. 

    I was responsible for designing and implementing the project's database and backend functionality.

    • Designed the database schema and created the necessary tables

    • Implemented the backend functionality using Java and Spring framework

    • Collaborated with team members to integrate the frontend and backend components

    • Tested the application and fixed any bugs or issues that arose

    • Presented the project to the faculty and received pos

  • Answered by AI
  • Q8. What are keys in database and why do we use them?
  • Ans. 

    Keys in a database are unique identifiers used to establish relationships between tables and ensure data integrity.

    • Keys are used to uniquely identify records in a database table.

    • Primary keys are used to uniquely identify each record in a table.

    • Foreign keys establish relationships between tables.

    • Keys help enforce data integrity and maintain consistency in the database.

    • Examples of keys include primary keys, foreign keys,

  • Answered by AI
  • Q9. What are issues in cloud?
  • Ans. 

    Issues in cloud include security, downtime, vendor lock-in, and data privacy.

    • Security concerns such as data breaches and unauthorized access

    • Downtime and service interruptions affecting business operations

    • Vendor lock-in and limited flexibility in choosing cloud providers

    • Data privacy and compliance with regulations such as GDPR and HIPAA

  • Answered by AI
  • Q10. Brief introduction of your project and algorithms used in project
  • Ans. 

    Developed a web application for online shopping using React and Node.js

    • Implemented user authentication and authorization using JSON Web Tokens (JWT)

    • Used MongoDB as the database to store user and product information

    • Implemented a search feature using Elasticsearch to provide fast and accurate search results

    • Integrated Stripe payment gateway for secure online transactions

  • Answered by AI
  • Q11. Flow diagram of final year project
  • Ans. 

    The flow diagram of my final year project showcases the step-by-step process of its execution.

    • The flow diagram illustrates the sequence of activities and their dependencies.

    • It helps in understanding the overall structure and logic of the project.

    • Each step in the diagram represents a specific task or action.

    • Arrows indicate the flow of control or data between different steps.

    • Decision points are represented by diamond-sha...

  • Answered by AI
  • Q12. Why do we normalise our database?
  • Ans. 

    Normalisation reduces data redundancy and improves data integrity in a database.

    • Prevents data duplication and inconsistencies

    • Simplifies database maintenance and updates

    • Improves query performance

    • Enforces data integrity and consistency

    • Follows best practices for database design

    • Examples: breaking down a customer table into separate tables for orders, addresses, and payments

    • Examples: creating a separate table for product ca...

  • Answered by AI
  • Q13. Tell me about yourself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

    • Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React

    • Strong background in computer science with knowledge of algorithms and data structures

    • Familiar with agile development methodologies and version control systems like Git

  • Answered by AI
  • Q14. Tell me your 5 qualities so that i should hire you
  • Ans. 

    I am a problem solver, team player, quick learner, detail-oriented, and have strong communication skills.

    • Problem solver - I enjoy tackling complex problems and finding innovative solutions.

    • Team player - I work well with others and value collaboration in achieving goals.

    • Quick learner - I am able to pick up new technologies and concepts quickly.

    • Detail-oriented - I pay attention to the smallest details to ensure high-qual...

  • Answered by AI
  • Q15. Do you have any engineering background
  • Ans. 

    Yes, I have a Bachelor's degree in Computer Engineering.

    • Bachelor's degree in Computer Engineering

    • Experience in software development

    • Knowledge of engineering principles applied to software design

  • Answered by AI
  • Q16. How was your day?
  • Ans. 

    My day was productive and challenging, with a lot of problem-solving and collaboration.

    • Completed a major coding project ahead of schedule

    • Participated in a brainstorming session with team members

    • Solved a tricky bug in the codebase

    • Attended a virtual meeting with stakeholders

  • Answered by AI
  • Q17. Do you have relatives in Pune? or what about your accomodation?
  • Ans. 

    No, I do not have any relatives in Pune. I have arranged for my accommodation in a rented apartment near the office.

    • No relatives in Pune

    • Accommodation arranged in a rented apartment near the office

  • Answered by AI
  • Q18. Do you know about My Passion Challenge test?
  • Ans. 

    Yes, My Passion Challenge test is a coding competition for software engineers.

    • My Passion Challenge test is a coding competition that evaluates the coding skills of software engineers.

    • It is designed to test problem-solving abilities, algorithmic thinking, and coding proficiency.

    • Participants are given a set of coding challenges to solve within a specified time limit.

    • The challenges can range from simple to complex, coveri...

  • Answered by AI
  • Q19. Any higher studies plan?
  • Ans. 

    Considering pursuing a Master's degree in Computer Science to deepen knowledge and advance career.

    • Considering pursuing a Master's degree in Computer Science

    • To deepen knowledge and advance career

    • Examples: MS in Computer Science at XYZ University, online courses in AI and Machine Learning

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: In this section, you will find questions from all technical subjects like data structures,design and analysis of algorithms, software testing and quality assurance , computer networks, database management , C , C++ , C# and java. The difficulty level is moderate.
For this section you can study from indiabix.com
In the 2nd section, we have to write a program and also have to follow constraints mentioned in the problem statement. Programs are based on file handling, structure and union , string operations,etc.
In 3rd round, you have to write an essay of about 10 lines. Essay topics are general issues like I had 'Traffic issues in India'.
Tips: Stick to your basics.
All the concepts should be clear.
Programs should be syntactically correct. Try to mention comments and also display output as expected. It adds up to your representation even if your logic goes wrong. :)
For essay writing round, there should be no grammatical mistakes.
Time management is very important.

Duration: 90 minutes
Total Questions: 75

Round: Technical Interview
Experience: My first technical round really went well. So I was qualified for Hr round.
But some candidates had to appear for 2 technical interviews.

Tips: Stay confident about your answers and also mention area of interest in your resume and go through your resume before going to interview. 60% of technical interview is on projects. They are really interested in ideas used in your projects. Explain all the projects in detail like which front end and back end used.
Every round is an elimination round. So give your best and stay confident.


Round: HR Interview
Experience: Hr round is also elimination round. And you should have good communication skills.
There is always backfiring so you have to be attentive and confident.
Always try to reply in a positive way.
Tips: You should read about the history of company and also the domains on which they are working and their recent projects.

Skills: Verbal Communication Skills
College Name: Jawaharlal Nehru Engineering College

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

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, Coding Test and One-on-one Round.
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 ETL Tool.
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

Recently Viewed

COMPANY BENEFITS

Capgemini

No Benefits

SALARIES

HCL Group

DESIGNATION

JOBS

Infosys

No Jobs

INTERVIEWS

VBRI Innovation

No Interviews

SALARIES

Infosys

REVIEWS

Infosys

No Reviews

INTERVIEWS

Gainwell CAT

No Interviews

REVIEWS

Capgemini

No Reviews

REVIEWS

Capgemini

No Reviews

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 301 salaries
₹2.6 L/yr - ₹10 L/yr
21% less than the average Snowflake Developer Salary in India
View more details

TCS Snowflake Developer Reviews and Ratings

based on 10 reviews

4.1/5

Rating in categories

4.1

Skill development

4.3

Work-life balance

3.1

Salary

4.8

Job security

4.3

Company culture

2.4

Promotions

3.5

Work satisfaction

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

₹0 L/yr - ₹0 L/yr

IT Analyst
66.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

AST Consultant
51.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
29.5k salaries
unlock blur

₹0 L/yr - ₹0 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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent