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 Senior Data Engineer Interview Questions, Process, and Tips

Updated 14 Jan 2025

Top LTIMindtree Senior Data Engineer Interview Questions and Answers

View all 36 questions

LTIMindtree Senior Data Engineer Interview Experiences

52 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Sql query to write max salary
  • Ans. 

    Use SQL query with MAX function to find the highest salary in a table.

    • Use SELECT MAX(salary) FROM table_name;

    • Make sure to replace 'salary' with the actual column name in the table.

    • Ensure proper permissions to access the table.

  • Answered by AI
  • Q2. What is dense rank in sql
  • Ans. 

    Dense rank in SQL assigns a unique rank to each distinct row in a result set, with no gaps between the ranks.

    • Dense rank is used to assign a rank to each row in a result set without any gaps.

    • It differs from regular rank in that it does not skip ranks if there are ties.

    • For example, if two rows have the same value and are ranked 1st, the next row will be ranked 2nd, not 3rd.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. What is spark cluster
  • Ans. 

    Spark cluster is a group of interconnected computers that work together to process large datasets using Apache Spark.

    • Consists of a master node and multiple worker nodes

    • Master node manages the distribution of tasks and resources

    • Worker nodes execute the tasks in parallel

    • Used for processing big data and running distributed computing jobs

  • Answered by AI
  • Q2. How hive works in hdfs
  • Ans. 

    Hive is a data warehouse system built on top of Hadoop for querying and analyzing large datasets stored in HDFS.

    • Hive translates SQL-like queries into MapReduce jobs to process data stored in HDFS

    • It uses a metastore to store metadata about tables and partitions

    • HiveQL is the query language used in Hive, similar to SQL

    • Hive supports partitioning, bucketing, and indexing for optimizing queries

  • Answered by AI

Skills evaluated in this interview

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

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Database related questions
  • Q2. Sql queries and performance tuning questions.

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Codility test on SQL, Spark and Python

Round 2 - Coding Test 

Technical interviewer asked on Spark, Python and SQL

Round 3 - HR 

(1 Question)

  • Q1. What skills will you bring to this position?
  • Ans. 

    I will bring strong programming skills, experience with big data technologies, and a deep understanding of data processing and analysis.

    • Strong programming skills in languages like Python, Java, or Scala

    • Experience with big data technologies such as Hadoop, Spark, and Kafka

    • Deep understanding of data processing and analysis techniques

    • Ability to design and implement scalable data pipelines

    • Experience with cloud platforms li

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell us about yourself
  • Q2. Python use case and sql use cases

LTIMindtree interview questions for designations

 Data Engineer

 (61)

 Senior Data Specialist

 (1)

 Big Data Engineer

 (1)

 Data Specialist

 (2)

 Data Architect

 (2)

 Senior Data Scientist

 (1)

 Data Science Engineer

 (1)

 Gcp Data Engineer

 (1)

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(2 Questions)

  • Q1. How to handle missing data in pyspark dataframe.
  • Ans. 

    Handle missing data in pyspark dataframe by using functions like dropna, fillna, or replace.

    • Use dropna() function to remove rows with missing data

    • Use fillna() function to fill missing values with a specified value

    • Use replace() function to replace missing values with a specified value

  • Answered by AI
  • Q2. Shared some table details and asked to get get maximum salary paid customer for all department from the table using pyspark

Interview Preparation Tips

Topics to prepare for LTIMindtree Senior Data Engineer interview:
  • pyspark
  • aws glue
  • Python

Skills evaluated in this interview

Get interview-ready with Top LTIMindtree Interview Questions

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-

I applied via Approached by Company

Round 1 - Technical 

(2 Questions)

  • Q1. What is Lambda?
  • Q2. Read and write?

Senior Data Engineer Interview Questions & Answers

user image Kavya sri Vemula

posted on 6 Jul 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude test and 2 coding questions

Round 2 - Technical 

(2 Questions)

  • Q1. What is the oops of java
  • Ans. 

    Object-oriented programming concepts in Java

    • Encapsulation: bundling data and methods that operate on the data into a single unit

    • Inheritance: allows a class to inherit properties and behavior from another class

    • Polymorphism: ability of a method to do different things based on the object it is acting upon

    • Abstraction: hiding the implementation details and showing only the functionality to the user

  • Answered by AI
  • Q2. On your self intrest on technologiea
Round 3 - HR 

(2 Questions)

  • Q1. Talk something about your best frds
  • Q2. What do you heard about mindtree

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Case Study 

DWT concept based questions, even though questions were perefectly answered, and the interviewer gave a promise note, no call back from them

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Spark and Big data related questions

Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall process is gud for the interview
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic questions on SQL joins, groupby, window function.
  • Q2. Spark related question - basic

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL weightage is more, be thorough with that. Databricks project related question.

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree Senior Data Engineer 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 Senior Data Engineer 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 PLSQL, Performance Tuning, SDLC, SQL and Adf.
What are the top questions asked in LTIMindtree Senior Data Engineer interview?

Some of the top questions asked at the LTIMindtree Senior Data Engineer interview -

  1. 7) How does query acceleration speed up query processi...read more
  2. SQL what are the condition used in sql? when we have table but we want cre...read more
  3. How to handle missing data in pyspark datafra...read more
How long is the LTIMindtree Senior Data Engineer interview process?

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

Tell us how to improve this page.

LTIMindtree Senior Data Engineer Interview Process

based on 66 interviews

4 Interview rounds

  • Technical Round - 1
  • Technical Round - 2
  • HR Round - 1
  • HR Round - 2
View more
LTIMindtree Senior Data Engineer Salary
based on 3.7k salaries
₹5 L/yr - ₹18.5 L/yr
41% less than the average Senior Data Engineer Salary in India
View more details

LTIMindtree Senior Data Engineer Reviews and Ratings

based on 333 reviews

3.3/5

Rating in categories

3.3

Skill development

3.5

Work-life balance

2.8

Salary

3.4

Job security

3.2

Company culture

2.4

Promotions

3.1

Work satisfaction

Explore 333 Reviews and Ratings
Senior Software Engineer
21.3k salaries
unlock blur

₹4.6 L/yr - ₹18.6 L/yr

Software Engineer
16.2k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Module Lead
6.7k salaries
unlock blur

₹7 L/yr - ₹25.5 L/yr

Technical Lead
6.4k salaries
unlock blur

₹9.4 L/yr - ₹36 L/yr

Senior Engineer
4.4k salaries
unlock blur

₹4.2 L/yr - ₹16.4 L/yr

Explore more salaries
Compare LTIMindtree with

Cognizant

3.8
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