i
LTIMindtree
Filter interviews by
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.
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.
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
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
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
Codility test on SQL, Spark and Python
Technical interviewer asked on Spark, Python and SQL
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
What people are saying about LTIMindtree
LTIMindtree interview questions for designations
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
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
Get interview-ready with Top LTIMindtree Interview Questions
I applied via Approached by Company
Aptitude test and 2 coding questions
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
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
DWT concept based questions, even though questions were perefectly answered, and the interviewer gave a promise note, no call back from them
Spark and Big data related questions
The duration of LTIMindtree Senior Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 66 interviews
4 Interview rounds
based on 333 reviews
Rating in categories
Senior Software Engineer
21.3k
salaries
| ₹4.6 L/yr - ₹18.6 L/yr |
Software Engineer
16.2k
salaries
| ₹2 L/yr - ₹10 L/yr |
Module Lead
6.7k
salaries
| ₹7 L/yr - ₹25.5 L/yr |
Technical Lead
6.4k
salaries
| ₹9.4 L/yr - ₹36 L/yr |
Senior Engineer
4.4k
salaries
| ₹4.2 L/yr - ₹16.4 L/yr |
Cognizant
Capgemini
Accenture
TCS