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

Clear (1)

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 Resume 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 Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. .net questions - routing in asp.net MVC ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing . Prepare well for interview on .Net technology stack

I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical 

(1 Question)

  • Q1. 2nd round included tr and mr round went quite enegritic

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Good

Round 2 - Technical 

(1 Question)

  • Q1. Basic question from C++.Some questions from Data structure and computer architecture.

Interview Preparation Tips

Topics to prepare for TCS Software Engineer interview:
  • C++
Interview preparation tips for other job seekers - Prepare well. Aptitude is not very easy so you have to prepare well.

I was interviewed in Sep 2016.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about Your project
  • Ans. 

    Developed a web-based project management tool for a software development company.

    • Used Agile methodology for development

    • Implemented features like task assignment, progress tracking, and team collaboration

    • Integrated with third-party tools like GitHub and Slack

    • Designed a user-friendly interface with responsive design

    • Deployed on AWS using EC2 and RDS

  • Answered by AI
  • Q2. Tell me about your CV!
  • Ans. 

    My CV showcases my experience in software development, including projects in Java, Python, and web development.

    • Experience in Java, Python, and web development

    • Worked on projects involving database management systems

    • Familiar with Agile development practices

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Tough! But manuplative ,yes manuplative ,I feel that your test scores are manuplated by the company! You score full marks in the test , but you are mechanical engineer you might not qualify for the next round! I say this as per ny experience . POINTER ,BRANCH and then score in this test describe the overall perfomance!
Tips: The company is totally for IT engineers if you are from other branch fonnot hope much, have a backup.
Duration: 1 hour 20 minutes
Total Questions: 80

Round: Technical + HR Interview
Experience: They Play with your minds,yes they do! Believe me donot show tough expressions!
Tips: Stay Calm ,they are not to scare you!

Skills: Technical, knowledge, gritt, Behavioural Skills
College Name: Atharva College Of Engineering
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

SALARIES

DXC Technology

SALARIES

LTIMindtree

INTERVIEWS

Tricon Infra Buildtech pvt.Ltd

No Interviews

INTERVIEWS

Capgemini

No Interviews

INTERVIEWS

Cognizant

No Interviews

INTERVIEWS

Accenture

No Interviews

INTERVIEWS

KMV Projects Limited

No Interviews

INTERVIEWS

Gainwell CAT

No Interviews

COMPANY BENEFITS

Capgemini

No Benefits

SALARIES

Saksoft

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 66 salaries
₹3 L/yr - ₹13.1 L/yr
At par with 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.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
16.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
6.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead
5.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Engineer
4.4k salaries
unlock blur

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