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
3.6

based on 15.9k Reviews

Filter interviews by

LTIMindtree Data Engineering Specialist Interview Questions, Process, and Tips

Updated 14 Nov 2024

Top LTIMindtree Data Engineering Specialist Interview Questions and Answers

  • Q1. Data projects carried out. How to create pipeline How to process millions of request Web crawler and scraping technologies How to read large CSV python
  • Q2. Write a query to identify the duplicate record and delete it using SQL.
  • Q3. How do you handle incremental data?
View all 13 questions

9 LTIMindtree Data Engineering Specialist Interview Experiences

35 questions found

Sort by: Popular
Interview experience
2
 Poor
Difficulty level
 Easy
Duration
 2-4 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Aug 2024.

1 Interview Round

1

Technical Round (7 Questions)

  • Q1. Write a query to identify the duplicate record and delete it using SQL.
  • Q2. Spark Architecture ?
  • Q3. Optimisation techniques used in your project?
  • Q4. What Is AWS Lambda? How does it work?
  • Q5. How do you handle incremental data?
  • Q6. Project Architecture?
  • Q7. What is a Catalyst optimiser?

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Approached by Company and was interviewed in Sep 2024.

3 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Spark memory management
  • Q2. Performance optimization in spark
2

Technical Round (2 Questions)

  • Q1. Transformations and actions in spark
  • Q2. Glue context and spark context
3

HR Round (2 Questions)

  • Q1. About your career so far
  • Q2. Previous organizations and projects worked

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well before appearing for interview

Skills evaluated in this interview

Get interview-ready with top interview questions

Interview experience
5
 Excellent
Difficulty level
 Hard
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Approached by Company and was interviewed in Apr 2024.

2 Interview Rounds

1

Coding Test Round

Conducted by CITI Karat. 2 SQL coding was there. Total interview was 1 hr. First 15 min was introduction. 25 min for 1st question and 20 min for 2nd question. The questions are little bit tricky.

2

Technical Round (4 Questions)

  • Q1. Types of indexes and uses
  • Q2. Query optimization and performance tuning
  • Q3. Ddl, dml, TCL, scl, dql
  • Q4. Views, function, sp, trigger

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare as much as you can.
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed in Feb 2024.

2 Interview Rounds

1

One-on-one Round (2 Questions)

  • Q1. Explain you last project end to end
  • Q2. Spark and sql questions
2

Technical Round (2 Questions)

  • Q1. Sql and pyspark coding questions
  • Q2. Spark Architecture questions

Interview Preparation Tips

Topics to prepare for LTIMindtree Data Engineering Specialist interview:
  • Spark
  • SQL
  • pyspark
  • Adf
  • Databricks

LTIMindtree interview questions for designations

 Software Engineering Specialist

 (34)

 Data Specialist

 (1)

 Data Science Specialist

 (1)

 Specialist Data Analyst

 (1)

 Senior Data Specialist

 (1)

 Engineering Intern

 (1)

 Specialist

 (14)

 Testing Engineering Analyst

 (1)

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Approached by Company and was interviewed in Aug 2023.

3 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Python concepts and coding question
  • Q2. Complete your code properly
2

Technical Round (1 Question)

  • Q1. Write the logic of map(), reduce()
3

HR Round (1 Question)

  • Q1. Salary discussion

Skills evaluated in this interview

Data Engineering Specialist Interview Questions

user image Nanda Kumar Totantila

posted on 4 Sep 2023

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed in Aug 2023.

3 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (1 Question)

  • Q1. Data projects carried out. How to create pipeline How to process millions of request Web crawler and scraping technologies How to read large CSV python
3

Technical Round (1 Question)

  • Q1. Scrum role. Daily activities of a development Automation framework

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Referral and was interviewed before Feb 2023.

2 Interview Rounds

1

Coding Test Round

Sl query based questions

2

HR Round (2 Questions)

  • Q1. Asked my full academics and professional details
  • Q2. Personal details

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare wth l1 and l2 round interviews for this company
Interview experience
4
 Good
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed before Nov 2023.

2 Interview Rounds

1

Coding Test Round

Average test, I joined when it was Mindtree only.

2

HR Round (2 Questions)

  • Q1. Expected salary
  • Q2. Past projects and expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Company has went downhill since the merger, Better no one joins this company now
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Referral and was interviewed before Sep 2022.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Technical Round (2 Questions)

  • Q1. Types of project you worked on
  • Q2. Optimization of the report
3

Technical Round (1 Question)

  • Q1. Types of filter, dax calculation
4

HR Round (1 Question)

  • Q1. Basic salary details and why looking for a change

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic concepts should be clear

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (5 Questions)

  • Q1. Technical Experience
  • Q2. Challenged faced
  • Q3. Solutions provided
  • Q4. Toughest Project Handled
  • Q5. Other Technical languages

Interview Preparation Tips

Interview preparation tips for other job seekers - If they feel you can fill their need then u r in

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree Data Engineering Specialist interview?
LTIMindtree interview process usually has 2-3 rounds. The most common rounds in the LTIMindtree interview process are Technical, HR and Coding Test.
How to prepare for LTIMindtree Data Engineering Specialist 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 Analytical Skills, Automation Testing, Bigquery, Cloud Computing and Data Warehousing.
What are the top questions asked in LTIMindtree Data Engineering Specialist interview?

Some of the top questions asked at the LTIMindtree Data Engineering Specialist interview -

  1. Data projects carried out. How to create pipeline How to process millions of ...read more
  2. Write a query to identify the duplicate record and delete it using S...read more
  3. How do you handle incremental da...read more
How long is the LTIMindtree Data Engineering Specialist interview process?

The duration of LTIMindtree Data Engineering Specialist interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Interview Process at LTIMindtree Data Engineering Specialist

based on 7 interviews in last 1 year

2 Interview rounds

  • Technical Round 1
  • Technical Round 2
View more

People are getting interviews through

based on 9 LTIMindtree interviews
Job Portal
Referral
44%
22%
34% candidates got the interview through other sources.
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10k Interviews
Accenture Interview Questions
3.9
 • 7.8k Interviews
Infosys Interview Questions
3.7
 • 7.3k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Wipro Interview Questions
3.7
 • 5.2k Interviews
Capgemini Interview Questions
3.8
 • 4.6k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
Genpact Interview Questions
3.9
 • 2.9k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
LTIMindtree Data Engineering Specialist Salary
based on 713 salaries
₹8.5 L/yr - ₹31 L/yr
At par with the average Data Engineering Specialist Salary in India
View more details

LTIMindtree Data Engineering Specialist Reviews and Ratings

based on 47 reviews

2.9/5

Rating in categories

3.2

Skill development

2.9

Work-Life balance

2.8

Salary & Benefits

3.0

Job Security

2.9

Company culture

2.2

Promotions/Appraisal

2.8

Work Satisfaction

Explore 47 Reviews and Ratings
Senior Software Engineer
22k salaries
unlock blur

₹4.8 L/yr - ₹18.2 L/yr

Software Engineer
15.9k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Module Lead
7.6k salaries
unlock blur

₹7 L/yr - ₹25.2 L/yr

Technical Lead
7.1k salaries
unlock blur

₹9.4 L/yr - ₹36.6 L/yr

Senior Engineer
4.7k salaries
unlock blur

₹4.2 L/yr - ₹17.3 L/yr

Explore more salaries
Compare LTIMindtree with

Cognizant

3.8
Compare

Capgemini

3.8
Compare

Accenture

3.9
Compare

TCS

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview