AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
LTIMindtree
Compare
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
LTIMindtree Interview Questions and Answers for Freshers
259 Interview questions
To find the maximum marks from a student table, use SQL's MAX() function to retrieve the highest score.
Use the SQL query: SELECT MAX(marks) FROM student;
Ensure 'marks' is the correct column name for student scores.
This query returns the highest marks from all records in the student table.
You can also use ORDER BY and LIMIT to find the top scorer: SELECT marks FROM student ORDER BY marks DESC LIMIT 1;
The candidate is asked to write code for generating Fibonacci series and finding the second largest number in an array.
For Fibonacci series, start with 0 and 1, then add the previous two numbers to get the next number in the series.
To find the second largest number in an array, sort the array in descending order and return the element at index 1.
HTML is a markup language used for creating and structuring web pages.
HTML stands for HyperText Markup Language.
It is used to create the structure and content of web pages.
HTML uses tags to define elements such as headings, paragraphs, images, links, and more.
Example: <h1>This is a heading</h1>
Example: <p>This is a paragraph</p>
HTML documents are saved with a .html file extension.
OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction. List is mutable while tuple is immutable.
OOPs concepts: inheritance, polymorphism, encapsulation, abstraction
List: mutable, can be modified after creation (e.g. [1, 2, 3])
Tuple: immutable, cannot be modified after creation (e.g. (1, 2, 3))
What people are saying about LTIMindtree
DSA stands for Data Structures and Algorithms. Knapsack is a problem in combinatorial optimization.
DSA is a field of study that involves the design and analysis of data structures and algorithms.
Knapsack problem involves maximizing the value of items in a knapsack without exceeding its capacity.
There are two types of knapsack problems: 0/1 knapsack (where items cannot be broken) and fractional knapsack (where item...
Calculate second highest salary using SQL and pyspark
Use SQL query with ORDER BY and LIMIT to get the second highest salary
In pyspark, use orderBy() and take() functions to achieve the same result
Reverse a given string
Create a character array from the input string
Use two pointers to swap characters from start and end of the array
Continue swapping until the pointers meet in the middle
A closure is a function that has access to its own scope, as well as the scope in which it was defined.
A closure allows a function to access variables from its outer function even after the outer function has finished executing.
Closures are created whenever a function is defined within another function.
Example: function outerFunction() { let outerVar = 'I am outer'; return function innerFunction() { console.log(ou...
A thread is a lightweight process that can run concurrently with other threads within the same process.
Threads allow for parallel execution of tasks within a single process.
Threads share the same memory space and resources of the process that created them.
Threads can be created in programming languages like Java, C++, and Python using built-in libraries or frameworks.
For example, in Java, you can create a thread b...
Data query is the process of retrieving specific data from a database, while data flow is the movement of data from one point to another.
Data query involves writing SQL queries to extract specific data from a database
Data flow refers to the movement of data from source to destination through various transformations
Data query is used to filter and retrieve relevant data, while data flow ensures data is processed an...
LTIMindtree Interview Experiences for Freshers
302 interviews found
Anonymous
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. OOPs Concepts AI Questions React Questions SQL Queries I had a terrible experience. Initially, I was shortlisted for the technical interview, which went well and lasted about 27 minutes. However, I didn’t ...
- Q2. Resume based questions
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(7 Questions)
- Q1. How do you optimize SQL queries?
- Ans.
Optimizing SQL queries involves using indexes, avoiding unnecessary joins, and optimizing the query structure.
Use indexes on columns frequently used in WHERE clauses
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
Use EXPLAIN to analyze query performance and make necessary adjustments
- Q2. How do you do performance optimization in Spark. Tell how you did it in you project.
- Ans.
Performance optimization in Spark involves tuning configurations, optimizing code, and utilizing caching.
Tune Spark configurations such as executor memory, number of executors, and shuffle partitions.
Optimize code by reducing unnecessary shuffles, using efficient transformations, and avoiding unnecessary data movements.
Utilize caching to store intermediate results in memory and avoid recomputation.
Example: In my projec...
- Q3. What is SparkContext and SparkSession?
- Ans.
SparkContext is the main entry point for Spark functionality, while SparkSession is the entry point for Spark SQL.
SparkContext is the entry point for low-level API functionality in Spark.
SparkSession is the entry point for Spark SQL functionality.
SparkContext is used to create RDDs (Resilient Distributed Datasets) in Spark.
SparkSession provides a unified entry point for reading data from various sources and performing ...
- Q4. When a spark job is submitted, what happens at backend. Explain the flow.
- Ans.
When a spark job is submitted, various steps are executed at the backend to process the job.
The job is submitted to the Spark driver program.
The driver program communicates with the cluster manager to request resources.
The cluster manager allocates resources (CPU, memory) to the job.
The driver program creates DAG (Directed Acyclic Graph) of the job stages and tasks.
Tasks are then scheduled and executed on worker nodes ...
- Q5. Calculate second highest salary using SQL as well as pyspark.
- Ans.
Calculate second highest salary using SQL and pyspark
Use SQL query with ORDER BY and LIMIT to get the second highest salary
In pyspark, use orderBy() and take() functions to achieve the same result
- Q6. 2 types of modes for Spark architecture ?
- Ans.
The two types of modes for Spark architecture are standalone mode and cluster mode.
Standalone mode: Spark runs on a single machine with a single JVM and is suitable for development and testing.
Cluster mode: Spark runs on a cluster of machines managed by a cluster manager like YARN or Mesos for production workloads.
- Q7. If you want very less latency - which is better standalone or client mode?
- Ans.
Client mode is better for very less latency due to direct communication with the cluster.
Client mode allows direct communication with the cluster, reducing latency.
Standalone mode requires an additional layer of communication, increasing latency.
Client mode is preferred for real-time applications where low latency is crucial.
(2 Questions)
- Q1. Scenario based. Write SQL and pyspark code for a dataset.
- Ans.
SQL and PySpark code examples for data manipulation and analysis.
Use SQL for structured queries: SELECT, JOIN, GROUP BY.
Example SQL: SELECT name, COUNT(*) FROM patients GROUP BY name;
Use PySpark for big data processing: DataFrame API, RDDs.
Example PySpark: df.groupBy('name').count().show();
Optimize queries with indexing in SQL and caching in PySpark.
- Q2. If you have to find latest record based on latest timestamp in a table for a particular customer(table is having history) , how will you do it. Self join and nested query will be expensive. Optimized query...
Interview Preparation Tips
- SQL
- pyspark
- ETL
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
The aptitude test was successful, covering various topics such as ratios and proportions, percentages, blood relations, boat and stream problems, highest common factor (HCF) and least common multiple (LCM), volume and surface area, time and work, as well as questions related to profit and loss, and speed, distance, and time.
In the coding test 1 question for coding and another 2 for debugging were asked.
(3 Questions)
- Q1. Tell me about yourself?
- Ans.
I am a recent graduate with a degree in Computer Science and a passion for coding and problem-solving.
Recent graduate with a degree in Computer Science
Passionate about coding and problem-solving
Experience with programming languages like Java, Python, and C++
- Q2. What do you mean by polymorphism?
- Ans.
Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).
Example: Inheritance in OOP allows a child class to override a method from its parent class, exhibiting polymo...
- Q3. A puzzle was asked. Probably do all the puzzles from geeks for geeks.
Interview Preparation Tips
Mounika Sanapala
Selected
I applied via Campus Placement
Percentage and averages, number and alphabet series, compound interest (CI) and simple interest (SI).
Basic programs include: 1. A program to perform the addition of two numbers, 2. A program to print a star pattern, and 3. A program to generate a triangle output, among others.
(4 Questions)
- Q1. What challenges did we face?
- Ans.
We faced challenges related to communication, resource allocation, and project timelines.
Communication breakdown between team members
Limited resources available for the project
Struggling to meet project deadlines
- Q2. Where do you see yourself in the next five years?
- Ans.
In five years, I see myself as a senior consultant leading projects and mentoring junior team members.
Advancing to a senior consultant role
Leading projects and teams
Mentoring junior team members
Continuing professional development through training and certifications
- Q3. What strategies can be employed to overcome failures?
- Ans.
Strategies to overcome failures include learning from mistakes, staying positive, seeking feedback, and setting new goals.
Learn from mistakes by analyzing what went wrong and how to improve
Stay positive and maintain a growth mindset to bounce back from setbacks
Seek feedback from mentors or colleagues to gain different perspectives
Set new goals and create a plan to move forward with renewed motivation
- Q4. Are you able to work effectively under pressure?
- Ans.
Yes, I thrive under pressure and can effectively manage my time and priorities to meet deadlines.
I have experience working in fast-paced environments where quick decision-making and adaptability are key.
I am able to stay calm and focused under pressure, allowing me to deliver high-quality work even in challenging situations.
I prioritize tasks effectively to ensure that deadlines are met without compromising on quality.
...
(1 Question)
- Q1. Java Based Questions
Interview Preparation Tips
DHIVAKAR B
Basic aptitude question.
Basic coding question.
(3 Questions)
- Q1. How the skill you specified in resume
- Ans.
I have strong problem-solving skills and attention to detail.
I have experience in root cause analysis to identify and resolve quality issues.
I am proficient in statistical analysis to improve processes and reduce defects.
I have a track record of implementing quality control measures to ensure product reliability.
I pay close attention to detail in all aspects of my work to maintain high quality standards.
- Q2. About the coding language you mention
- Ans.
Quality Engineers use coding languages to automate testing, improve processes, and ensure product quality.
Automation: Languages like Python or Java can be used to write automated test scripts.
Data Analysis: R or Python can analyze test results and identify trends.
Integration: Coding helps integrate testing tools with CI/CD pipelines, enhancing workflow.
Scripting: Shell scripting can automate repetitive tasks in the tes...
- Q3. Asking to slove coding question
(2 Questions)
- Q1. General basic question
- Q2. Scenario based question
Nashrat Jahan
Basic core computer concepts and technology related questions
(4 Questions)
- Q1. Oops, arraylists
- Q2. Tell me about abstraction and interfaces
- Ans.
Abstraction is the concept of hiding complex implementation details and showing only the necessary features. Interfaces define a contract for classes to implement.
Abstraction allows us to focus on what an object does rather than how it does it
Interfaces define a set of methods that a class must implement, without specifying how they are implemented
Abstraction and interfaces help in achieving loose coupling and flexibil...
- Q3. Array lists vs arrays
- Ans.
Array lists are dynamic in size, while arrays have fixed sizes.
Array lists can grow or shrink in size dynamically, while arrays have a fixed size.
Array lists are implemented using dynamic arrays, while arrays are static data structures.
Array lists provide methods for adding, removing, and accessing elements easily, while arrays require manual resizing and shifting of elements.
Example: ArrayList<String> vs String[...
- Q4. Pattern printibg questionto print a triangle
- Ans.
This question involves printing a triangle pattern using loops in programming.
Use nested loops: Outer loop for rows, inner loop for columns.
For a right-angled triangle, print '*' for each column in the row.
Example for 5 rows: 1st row: * 2nd row: ** 3rd row: *** 4th row: **** 5th row: *****
Adjust spaces for different triangle types (e.g., centered triangle).
(1 Question)
- Q1. Flexible with moving
- Ans.
I am open to relocating for the right opportunity.
I am willing to move to different locations for career growth
I understand the importance of being flexible with relocation for job opportunities
I have experience moving for previous job opportunities, such as relocating for internships or projects
I applied via Campus Placement
The first round of the interview consisted of a 100-question aptitude test.
(2 Questions)
- Q1. Technical Questions regarding to technologies added in your resume.
- Q2. Questions from your technical iin your resume
- Ans.
Discussing technical skills and experiences listed in my resume for the Associate Trainee position.
Proficient in programming languages like Python and Java, used for developing applications.
Experience with data analysis tools such as Excel and SQL for data management.
Familiar with software development methodologies like Agile, enhancing team collaboration.
Worked on a project involving machine learning algorithms to pre...
(1 Question)
- Q1. HR Questions you can find it on Google itself.
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
There were verbal, non verbal, reasoning , English and maths questions
(2 Questions)
- Q1. Tell me about your project.
- Ans.
I worked on a project analyzing customer behavior using machine learning algorithms.
Used Python for data preprocessing and analysis
Implemented machine learning models such as decision trees and logistic regression
Performed feature engineering to improve model performance
- Q2. What programming knowledge you have ?
- Ans.
Proficient in Python, R, and SQL with experience in data manipulation, visualization, and machine learning algorithms.
Proficient in Python for data analysis and machine learning tasks
Experience with R for statistical analysis and visualization
Knowledge of SQL for querying databases and extracting data
Familiarity with libraries such as Pandas, NumPy, Matplotlib, and Scikit-learn
(2 Questions)
- Q1. Where do you stay ?
- Ans.
I currently stay in an apartment in downtown area.
I stay in an apartment in downtown area
My current residence is in a city
I live close to my workplace
- Q2. Tell me about you
- Ans.
I am a data science enthusiast with a strong background in statistics and machine learning.
Background in statistics and machine learning
Passionate about data science
Experience with data analysis tools like Python and R
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
Basic aptitude questions
(2 Questions)
- Q1. Remove duplicates in a array
- Ans.
Remove duplicates from an array of strings by using a set or filtering methods to ensure unique values.
Use a set to automatically handle duplicates: `uniqueArray = list(set(array))`.
Filter the array while checking for existence: `uniqueArray = []` and loop through `array`.
Example: For `array = ['apple', 'banana', 'apple']`, the result will be `['apple', 'banana']`.
Using list comprehension: `uniqueArray = []` + `[x for ...
- Q2. Capitalise first letter of every word
- Ans.
To capitalize the first letter of every word in a string, iterate through the string and modify each word accordingly.
Use a programming language like Python: ' '.join(word.capitalize() for word in text.split())
In JavaScript, you can use: text.split(' ').map(word => word.charAt(0).toUpperCase() + word.slice(1)).join(' ')
Consider edge cases like punctuation: 'hello, world!' becomes 'Hello, World!'
Handle empty strings ...
(2 Questions)
- Q1. Introduce yourself
- Ans.
I am a passionate engineering graduate with a strong foundation in mechanical systems and a keen interest in innovative solutions.
Educational Background: Graduated with a Bachelor's degree in Mechanical Engineering from XYZ University.
Internship Experience: Completed a summer internship at ABC Corp, where I worked on optimizing manufacturing processes.
Technical Skills: Proficient in CAD software like AutoCAD and SolidW...
- Q2. Describe yourself in 3 words
- Ans.
I am curious, dedicated, and adaptable, always eager to learn and grow in my engineering journey.
Curious: I love exploring new technologies and concepts, like learning about AI and its applications in engineering.
Dedicated: I consistently put in extra effort to meet project deadlines, ensuring quality work and team success.
Adaptable: I thrive in dynamic environments, quickly adjusting to new challenges, such as switchi...
Skills evaluated in this interview
I appeared for an interview in Aug 2024.
The aptitude test will be conducted online.
(7 Questions)
- Q1. Can you tell me about yourself?
- Q2. What is the thread lifecycle in programming?
- Ans.
Thread lifecycle in programming refers to the various stages a thread goes through from creation to termination.
Thread creation: A new thread is created using the 'Thread' class or by implementing the 'Runnable' interface.
Thread start: The thread transitions from 'new' to 'runnable' state when 'start()' method is called.
Thread running: The thread is executing its task in the 'running' state.
Thread waiting: The thread c...
- Q3. What is the purpose of collections in Java?
- Ans.
Collections in Java are used to store and manipulate groups of objects.
Collections provide a way to store, retrieve, and manipulate groups of objects in Java.
They offer various data structures like lists, sets, maps, etc. for different purposes.
Collections framework includes interfaces like List, Set, Map, and classes like ArrayList, HashSet, HashMap.
Collections provide methods for sorting, searching, and iterating ove...
- Q4. What are the key concepts of Object-Oriented Programming (OOP)?
- Ans.
Key concepts of OOP include encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit (class).
Inheritance: Allows a class to inherit properties and behavior from another class.
Polymorphism: Ability for objects to be treated as instances of their parent class or their own class.
Abstraction: Hiding complex implementation details and show...
- Q5. What are some real-life examples that illustrate the concepts of Object-Oriented Programming (OOP)?
- Ans.
Real-life examples of Object-Oriented Programming include modeling a car as an object with properties and methods.
Modeling a car as an object with properties like color, make, model, and methods like start, stop, accelerate
Creating a banking system where accounts are objects with properties like balance and methods like deposit, withdraw
Developing a video game where characters are objects with properties like health, p...
- Q6. Write a code for matrix multiplication?
- Ans.
Matrix multiplication code implementation in C++
Declare two matrices A and B of appropriate sizes
Iterate through rows and columns to calculate each element of the resulting matrix C
Use nested loops for efficient computation
Ensure the number of columns in matrix A is equal to the number of rows in matrix B
Example: A = {{1, 2}, {3, 4}}, B = {{5, 6}, {7, 8}}, C = A*B = {{19, 22}, {43, 50}}
- Q7. Could you provide details about your academic project?
- Ans.
Designed and implemented a smart irrigation system using IoT technology.
Researched various sensors and actuators suitable for monitoring soil moisture levels and controlling water flow.
Developed a mobile application to remotely monitor and control the irrigation system.
Implemented machine learning algorithms to optimize water usage based on weather forecasts and plant requirements.
(1 Question)
- Q1. Basic questions
Interview Preparation Tips
LTIMindtree Interview FAQs
Some of the top questions asked at the LTIMindtree interview for freshers -
The duration of LTIMindtree interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
LTIMindtree Interviews By Designations
- LTIMindtree Software Engineer Interview Questions
- LTIMindtree Senior Software Engineer Interview Questions
- LTIMindtree Software Developer Interview Questions
- LTIMindtree Senior Specialist Interview Questions
- LTIMindtree Graduate Engineer Trainee (Get) Interview Questions
- LTIMindtree Module Lead Interview Questions
- LTIMindtree Graduate Engineer Interview Questions
- LTIMindtree Graduate Trainee Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Software Developer Interview Questions
- Senior Specialist Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Module Lead Interview Questions
- Graduate Engineer Interview Questions
- Graduate Trainee Interview Questions
- Show more
Overall Interview Experience Rating
based on 214 interview experiences
Difficulty level
Duration
Explore Interview Questions and Answers for Top Skills at LTIMindtree
Interview Questions from Similar Companies
LTIMindtree Reviews and Ratings
based on 22.9k reviews
Rating in categories
|
Senior Software Engineer
22k
salaries
|  ₹7.4 L/yr - ₹21.7 L/yr |
|
Software Engineer
16.3k
salaries
| ₹3.9 L/yr - ₹8.8 L/yr |
|
Technical Lead
6.4k
salaries
| ₹16.4 L/yr - ₹28.5 L/yr |
|
Module Lead
5.7k
salaries
| ₹12.6 L/yr - ₹22 L/yr |
|
Senior Engineer
4.7k
salaries
| ₹5.8 L/yr - ₹14 L/yr |
Cognizant
Capgemini
Accenture
TCS
- Home >
- Interviews >
- LTIMindtree Interview Questions >
- LTIMindtree Interview Questions for Fresher
