LTIMindtree Interview Questions, Process, and Tips for Freshers

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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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 ...read more
Answered by AI
View 1 more answer
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
Answered by AI
Add your answer
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.
Answered by AI
Add your answer
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.
Answered by AI
Add your answer

Q1. Scenario based. Write SQL and pyspark code for a dataset.
Add your answer
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...read more
Add your answer

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.

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++
Answered by AI
Add your answer
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
Answered by AI
Add your answer
Q3. A puzzle was asked. Probably do all the puzzles from geeks for geeks.
Add your answer

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.

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
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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.

• ...read more
Answered by AI
Add your answer

Q1. Java Based Questions
Add your answer

Basic aptitude question.

Basic coding question.

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.
Answered by AI
Add your answer
Q2. About the coding language you mention
Add your answer
Q3. Asking to slove coding question
Add your answer

Q1. General basic question
Add your answer
Q2. Scenario based question
Add your answer