LTIMindtree Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 76 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at LTIMindtree.
LTIMindtree
Data Engineer
Mid Average Positive experience Decline offer 3 rounds
Interview process
Recruiter call Technical screen Onsite Background check Offer
Interview formats
Technical Coding
The interview process involves 2 levels of interviews, plus a surprise interview after the HR round to weed out fake candidates. These first 2 levels, with both the company and the client, happen after hiring. The whole process is long and can be quite exhausting. Sometimes the feedback isn't great and they'll ask you to reschedule the interview.
Confirmed questions1 question
- Can you explain SQL stored procedures?
LTIMindtree
Data Engineer
Mid Easy Negative experience No offer 3 rounds
Interview process
Recruiter call Technical screen Onsite
Interview formats
Technical Behavioral
So I had L1, L2, and an HR round, and I was feeling pretty good about it all. But then, bam, rejected. I dug into it and found out it was because they said I'm from a non-technical background and don't have 4 years of experience. Seriously? I have a BCA and an MSC in BigData and Analytics, and they knew I had 3 years of experience from the first phone screening. It feels like these HR people are just a waste of time, and honestly, it's why people dislike HR folks. They even made me travel to the Bangalore office just to check my ID card. Total waste of my time and such a unprofessional way to handle things.
Confirmed questions3 questions
- Questions about the tool for which I was hired.
- How were projects handled and how were issues solved?
- Mainly about data engineering and real-time data streaming.
LTIMindtree
Senior Data Engineer
Senior Average Neutral experience Accept offer 3 rounds
Interview process
Recruiter call Technical screen Technical screen Background check
Interview formats
Technical Coding Behavioral
So first an HR will call you and guide you through the whole process. Then there will be 2 rounds of technical interviews. The very last round is an HR ROUND. The first two rounds will be focused on the tech stack required for the role and what you've mentioned in your resume. In my case, they mostly focused on SQL and Python and FastAPI. And they will ask you to write some code related to Python DSA or SQL.
Confirmed questions6 questions
- Can you tell me about your background and skills?
- What is your availability to join?
- Could you write some Python DSA code?
LTIMindtree Data Engineer Interview Questions
Quoted word for word from LTIMindtree interview reports.
“Given a dictionary with keys, how would you create a dataframe?”
Read reports →“Compare truncate and delete commands in SQL, specifically regarding table structure preservation. To which category (DDL, DQL, DML, DCL) does each belong?”
Read reports →“What are the differences between UNION and UNION ALL operators in SQL? Does UNION include duplicate values?”
Read reports →“What is the count of records after performing an inner join on two tables?”
Read reports →“What is the query to find the second highest salary using Spark SQL?”
Read report →“What is the difference between Rank, Row Number, and Rank Dense functions?”
Read report →“Given three tables, identify the customer who placed the largest order and calculate their total sales.”
Read report →“What's the query to find the second highest salary in each department?”
Read report →“How would you retrieve the second highest salary from an employee table using SQL?”
Read report →Formats, difficulty and experience
Across all 76 LTIMindtree interview reports.