LTIMindtree Data Engineer Interview Questions, Process, and Tips

There was an aptitude test of 50 questions approx on SQL , Code outputs, html css , Unix commands

There was a code you can solve in any programming language (python, java, c,c++,etc). This round was of 30 minutes and I got a code on permutations and combinations.

Q1. After coding there was technical interview. I was asked a programming question and I gave 2 ways to tackle the logic. Interview lasted only for 5 mins.
Add your answer
Q2. 1) If you are given a card with 1-1000 numbers and there are 4 boxes. Card no 1 will go in box 1 , card 2 in box 2 and similarly it will go. Card 5 will again go in box 1. So what will be the logic for thi...read more
Ans. 
Logic for distributing cards among 4 boxes in a circular manner.
• Use modulo operator to distribute cards among boxes in a circular manner.

• If card number is divisible by 4, assign it to box 4.

• If card number is divisible by 3, assign it to box 3.

• If card number is divisible by 2, assign it to box 2.

• If card number is not divisible by any of the above, assign it to box 1.
Answered by AI
View 3 more answers

Q1. HR round was normal HR questions and it lasted for about 25 mins. After HR it took 10-12 days for me to receive a congratulations mail.
Add your answer
Q2. Normal basic HR questions like where you see in 5 years , why lti , etc etc
Ans. You'll get answers of such questions on any HR questions list
Answered by Piyush Kanojia
Add your answer

Q1. Hive External vs managed
Ans. 
Hive External vs managed
• Hive External tables store data outside of the Hive warehouse directory

• Managed tables store data in the Hive warehouse directory

• External tables can be used to access data from different storage systems

• Managed tables are easier to manage as Hive takes care of data storage and metadata

• External tables require manual management of data and metadata
Answered by AI
Add your answer
Q2. Perfomance tuning apache spark
Add your answer

It was a basic apti test

Basically coding plus apti were in the round 1 itself.

Q1. Questions were asked from my resume on what domains that i have worked on
Add your answer

LTI conducts Innovator Coding Challenge (ICC) for Campus recruitment.
First coding test was ICC Coding Challenge 1 which was very easy.
It was conducted on Mettl platform.
There were three questions and all three was easy.
I got coding challenge based on Normal Arithmetic Implementation, Array based and Data structure (easy one).
I was able to pass all test cases of 1st and 2nd Question. And partial test cases of 3rd Question.

ICC Round. 2 :-
Based on First round, Some people were shortlisted for round 2.

Questions were Medium Complex and there were 2 questions. One based out of Array and One on Pure Data structure (difficult).

I was able to do 1st question partially and 2nd Question (Basic Test cases pass).

Q1. Technical Interview 1 :- After ICC Round 2, there was Round 3 but I was ineligible for that since I didn't cleared 2nd challenge. If you appear for ICC1- 5LPA, ICC2-6.5 or 7.5 LPA , ICC3- 8 LPA. Based on...read more
Add your answer

Q1. Technical Round 2 : In this Round most of the time interviewer talked about Data Structures and Algorithm. Types of algorithms in DSA. Explain LinkedList and it's need. Explain Difference between Stack ...read more
Add your answer
Q2. Implementation of LinkedList using Array (Only algorithm or different types of ways to implement it).
Add your answer
Q3. Major question: On spot coding of LinkedList based Question. Here I wrote Java Libraries and completed code within 4 lines and Interview was happy with my Java Libraries knowledge. Still I wrote same log...read more
Add your answer

Q1. HR Round : This round of most danger round. Initially I thought I am selected because Tech Interview went very very well. In HR Round, HR asked many basic questions like Why LTI ? Why you don't pursue...read more
Add your answer

Q1. What are the stand out snowflake features?
Ans. 
Snowflake features include automatic scaling, zero-copy cloning, and data sharing.
• Automatic scaling allows for seamless adjustment of compute resources based on workload demands.

• Zero-copy cloning enables quick and efficient creation of copies of data without duplicating storage.

• Data sharing feature allows for secure and controlled sharing of data across different accounts or regions.
Answered by AI
Add your answer

Q1. What are challenges in snowflake?
Ans. 
Challenges in Snowflake include managing costs, data governance, and data integration.
• Managing costs can be a challenge due to the pay-per-second pricing model of Snowflake.

• Ensuring proper data governance and security measures is crucial in Snowflake.

• Data integration can be complex when dealing with multiple data sources and formats in Snowflake.
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer

Quants, psychological questions, basic programming and syntax along with a program to solve

Twelve members groups discussion on general topics

Q1. Questions regarding relocation
Add your answer
Q2. Tel me something interesting about yourself
Ans. 
I am an avid traveler and have visited over 20 countries.
• I love exploring new cultures and experiencing different cuisines.

• Some of my favorite travel destinations include Japan, Italy, and Thailand.

• I enjoy documenting my travel experiences through photography and blogging.

• Traveling has taught me to be adaptable and open-minded, which are valuable skills in the data engineering field.
Answered by AI
View 1 more answer