LTIMindtree Interview Questions, Process, and Tips

Q1. Write a query to identify the duplicate record and delete it using SQL.
Ans. 
Query to identify and delete duplicate records in SQL
• Use a combination of SELECT and DELETE statements

• Identify duplicates using GROUP BY and HAVING clauses

• Delete duplicates based on a unique identifier or combination of columns
Answered by AI
Add your answer
Q2. Spark Architecture ?
Add your answer
Q3. Optimisation techniques used in your project?
Ans. 
Various optimisation techniques were used in my project to improve performance and efficiency.
• Implemented indexing to speed up database queries

• Utilized caching to reduce redundant data retrieval

• Applied parallel processing to distribute workloads efficiently

• Optimized algorithms to reduce time complexity

• Used query optimization techniques to improve database performance
Answered by AI
Add your answer
Q4. What Is AWS Lambda? How does it work?
Ans. 
AWS Lambda is a serverless computing service provided by Amazon Web Services.
• AWS Lambda allows you to run code without provisioning or managing servers.

• It automatically scales based on the incoming traffic.

• You only pay for the compute time you consume.

• Supports multiple programming languages like Node.js, Python, Java, etc.

• Can be triggered by various AWS services like S3, DynamoDB, API Gateway, etc.
Answered by AI
Add your answer
Q5. How do you handle incremental data?
Ans. 
Handle incremental data by using tools like Apache Kafka for real-time data streaming and implementing CDC (Change Data Capture) for database updates.
• Utilize tools like Apache Kafka for real-time data streaming

• Implement CDC (Change Data Capture) for tracking database updates

• Use data pipelines to process and integrate incremental data

• Ensure data consistency and accuracy during incremental updates
Answered by AI
Add your answer
Q6. Project Architecture?
Add your answer
Q7. What is a Catalyst optimiser?
Ans. 
Catalyst optimizer is a query optimization framework in Apache Spark that improves performance by applying various optimization techniques.
• It is a query optimization framework in Apache Spark.

• It improves performance by applying various optimization techniques.

• It leverages techniques like predicate pushdown, column pruning, and constant folding to optimize queries.

• Catalyst optimizer generates an optimized logical plan a
Answered by AI
Add your answer

Q1. OOPs concepts and framework implementation
Add your answer
Q2. Bubble sort program
Ans. 
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
• Start at the beginning of the array and compare the first two elements. If the first element is greater than the second, swap them.

• Continue comparing adjacent elements and swapping them if necessary until the end of the array is reached.

• Repeat this process for each ...read more
Answered by AI
Add your answer
Q3. Basic questions on selenium
Add your answer
Q4. Custom assertions in selenium
Ans. 
Custom assertions in Selenium allow for creating personalized validation checks in test automation scripts.
• Custom assertions can be created by extending the Assert class in Selenium.

• They can be used to validate specific conditions or elements on a web page.

• Custom assertions can improve test readability and maintainability by encapsulating complex validation logic.

• Example: Creating a custom assertion to verify the prese
Answered by AI
Add your answer
Q5. Webdriver questions
Add your answer

Q1. First round was the Technical round
Add your answer
Q2. Second round was the group discussion
Add your answer

Q1. HR Round was the final round
Add your answer

It encompasses a combination of aptitude, technical skills, and communication abilities.

Q1. What was your HR's focus during the interview, particularly concerning your projects and their technical stack, and what types of basic questions were asked related to Python and SQL?
Add your answer

Q1. What is your biggest achievement throughout your life?
Ans. 
My biggest achievement is graduating with honors from university while working part-time and being actively involved in extracurricular activities.
• Graduating with honors from university

• Balancing academics with a part-time job

• Active involvement in extracurricular activities

• Receiving recognition for academic achievements
Answered by AI
Add your answer