Upload Button Icon Add office photos
Engaged Employer

i

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

LTIMindtree Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

LTIMindtree Snowflake Developer Interview Questions and Answers

Updated 4 Oct 2024

LTIMindtree Snowflake Developer Interview Experiences

3 interviews found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Sentimental Analysis in snowflake
  • Ans. 

    Sentiment analysis in Snowflake involves analyzing text data to determine the sentiment expressed.

    • Use Snowflake's text functions to extract and analyze text data

    • Leverage machine learning models to classify sentiment as positive, negative, or neutral

    • Consider using external sentiment analysis tools or libraries for more advanced analysis

  • Answered by AI
  • Q2. S|n|o|w|f|l|a|k|e - how do you print letters one below the other without the pipeline

Interview Preparation Tips

Topics to prepare for LTIMindtree Snowflake Developer interview:
  • SQL
  • Snowpipe
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Snowflake Architecture
  • Q2. Snowflake scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - One of the quickest interview ever (10 mins) . I felt that interviewer was not interested. Asked few questions I answered all of them. And the response was thank you see you again.
Interviewer was in hurry.

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
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 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 

(2 Questions)

  • Q1. What is time travel ?
  • Ans. 

    Time travel refers to the concept of moving between different points in time.

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

    • It involves the idea of traveling to the past or future using advanced technology or supernatural means.

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

    • Examples of time travel in popular culture include movies like Back...

  • Answered by AI
  • Q2. What is cloning in snowflake?
  • Ans. 

    Cloning in Snowflake is the process of creating a copy of a database, schema, table, or view.

    • Cloning allows users to quickly duplicate objects without having to recreate them from scratch.

    • Cloning is a metadata-only operation, meaning it does not copy the actual data.

    • Cloning can be useful for creating backups, testing changes, or creating development environments.

    • Example: CLONE TABLE original_table TO cloned_table;

  • Answered by AI

Interview Preparation Tips

Topics to prepare for LTIMindtree Snowflake Developer interview:
  • Snowflake
  • SQL
  • AWS
  • DBT
Interview preparation tips for other job seekers - Please go through snowflake documentation

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 before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Simple program
  • Q2. I wrote a simple program in C

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident

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

I applied via Naukri.com and was interviewed before Oct 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What technical challenges have you faced in your work till now and how did you overcome it?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be truthful and give detailed explanation of the issues and how it was resolved. Explain the severity of the problem and what blockage it had caused in your daily work. How did you chose a solution and how fast was it implemented.

I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic coding questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident , easy to crack

Interview Questionnaire 

1 Question

  • Q1. Mostly related to the technology I applied for. Some coding related questions. Questions related to our expertise to test us.

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree Snowflake Developer interview?
LTIMindtree interview process usually has 1-2 rounds. The most common rounds in the LTIMindtree interview process are Technical and Resume Shortlist.
How to prepare for LTIMindtree 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 LTIMindtree. The most common topics and skills that interviewers at LTIMindtree expect are ETL and Python.
What are the top questions asked in LTIMindtree Snowflake Developer interview?

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

  1. What is cloning in snowfla...read more
  2. What is time trave...read more
  3. Sentimental Analysis in snowfl...read more

Tell us how to improve this page.

LTIMindtree Snowflake Developer Interview Process

based on 3 interviews

Interview experience

2.7
  
Poor
View more
LTIMindtree Snowflake Developer Salary
based on 70 salaries
₹3.9 L/yr - ₹15 L/yr
18% more than the average Snowflake Developer Salary in India
View more details

LTIMindtree Snowflake Developer Reviews and Ratings

based on 5 reviews

3.3/5

Rating in categories

4.5

Skill development

2.6

Work-life balance

3.0

Salary

4.0

Job security

2.9

Company culture

2.7

Promotions

2.9

Work satisfaction

Explore 5 Reviews and Ratings
Senior Software Engineer
21.4k salaries
unlock blur

₹5.1 L/yr - ₹19 L/yr

Software Engineer
16.2k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Technical Lead
6.4k salaries
unlock blur

₹9.4 L/yr - ₹36 L/yr

Module Lead
5.9k salaries
unlock blur

₹7 L/yr - ₹25 L/yr

Senior Engineer
4.4k salaries
unlock blur

₹4.2 L/yr - ₹16.5 L/yr

Explore more salaries
Compare LTIMindtree with

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Accenture

3.8
Compare

TCS

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