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
3.8

based on 20.6k Reviews

Filter interviews by

LTIMindtree Interview Questions, Process, and Tips

Updated 5 Feb 2025

Top LTIMindtree Interview Questions and Answers

View all 2k questions

LTIMindtree Interview Experiences

Popular Designations

3k interviews found

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Azure cloud platform tech
  • Q2. Informatica tech stack ques
Round 2 - Technical 

(2 Questions)

  • Q1. Adf tech stack que
  • Q2. Scd type 2 implementation
Round 3 - Technical 

(2 Questions)

  • Q1. Dw related que ans
  • Q2. Solution design related que
Round 4 - HR 

(2 Questions)

  • Q1. Aspiration from my end
  • Q2. How soon can join

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join or even I would suggest not to apply or give interview to this pathetic company. I have cleared all my 4 rounds of interview including HR out of which 3 technical and 1 HR. 3 held on video conferencing and one face to face for which I have travelled almost 40 kms from my current location and they said without face to face they cannot proceed hence I had no option left but to travel, then when I entered into the office again put a laptop infront of me which is again video conferencing then I didn't understand why exactly they called me if they want to have it over video online.

Then after putting my lot of time and efforts when finally it comes to release the offer, then they stop picking up the calls and stop responding and the final excuses which I got from them for not releasing the offer is that their software will not allow them to release any offer which is more that 2 days of joining.

Such a pathetic company who even don't know that atleast if you are not releasing the offer, it's your duty to atleast tell the person that either they are not able to provide the compensation as discussed or they are looking parallelly for someone who can settle in less compensation.

Due to all this I have wasted almost my 3-4 weeks of time expecting that I will receive the offer, and didn't focus on other organisations which was ready to provide slightly lower than this.

Hence it's a total scam which is going here suggesting not to get trapped otherwise you will not only waste your time but also other good opportunities as well.

It's a total boycott for me, expecting the same from your end as well, so that they will understand that playing with someone's job is not a joke.

Associate Interview Questions & Answers

user image Anonymous

posted on 20 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Aptitude Test 

Quantitative Aptitude, Logical Reasoning, English Comprehension, Computer Science, Versant

Round 2 - Technical 

(10 Questions)

  • Q1. Can you introduce yourself?
  • Ans. 

    I am a dedicated and experienced professional with a background in finance and a passion for problem-solving.

    • Experienced in financial analysis and reporting

    • Strong problem-solving skills

    • Excellent communication and teamwork abilities

  • Answered by AI
  • Q2. Can you describe your project?
  • Ans. 

    I developed a mobile app for tracking daily water intake and setting hydration goals.

    • Designed user-friendly interface for easy input of water consumption

    • Implemented reminder notifications to encourage regular hydration

    • Included visual graphs to track daily, weekly, and monthly water intake

    • Integrated with wearable devices to sync water intake data

  • Answered by AI
  • Q3. What technologies did you utilize in your project?
  • Ans. 

    I utilized technologies such as Python, SQL, and Tableau in my project.

    • Python

    • SQL

    • Tableau

  • Answered by AI
  • Q4. What is the process for creating and submitting code on GeeksforGeeks?
  • Ans. 

    The process for creating and submitting code on GeeksforGeeks involves writing code, testing it, and then submitting it on the platform.

    • Create an account on GeeksforGeeks website.

    • Write the code for the problem statement provided.

    • Test the code locally to ensure it works correctly.

    • Submit the code on the GeeksforGeeks platform for evaluation.

    • Receive feedback and improve the code if necessary.

  • Answered by AI
  • Q5. What do you know about cloud computing?
  • Ans. 

    Cloud computing is the delivery of computing services over the internet, including storage, servers, databases, networking, software, and more.

    • Cloud computing allows users to access resources on-demand without the need for physical hardware.

    • It offers scalability, flexibility, and cost-efficiency for businesses.

    • Examples of cloud computing services include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Plat

  • Answered by AI
  • Q6. What can you tell me about Kubernetes?
  • Ans. 

    Kubernetes is an open-source container orchestration platform that automates the deployment, scaling, and management of containerized applications.

    • Kubernetes allows for automatic scaling of applications based on resource usage.

    • It provides self-healing capabilities by automatically restarting containers that fail.

    • Kubernetes enables easy deployment and management of microservices architecture.

    • It supports various cloud pr...

  • Answered by AI
  • Q7. What is orchestration?
  • Ans. 

    Orchestration is the automated arrangement, coordination, and management of complex computer systems, services, and workflows.

    • Orchestration involves automating tasks and workflows to streamline processes.

    • It helps in coordinating multiple systems and services to work together seamlessly.

    • Examples include orchestrating the deployment of applications across different servers or managing the workflow of a data pipeline.

  • Answered by AI
  • Q8. How can you create programs in Java?
  • Ans. 

    Programs in Java can be created by writing code in a text editor or an IDE, compiling the code, and running it using a Java Virtual Machine (JVM).

    • Write Java code using classes, methods, variables, and control structures.

    • Compile the code using a Java compiler like javac.

    • Run the compiled code using a Java Virtual Machine (JVM) like java.

    • Use an Integrated Development Environment (IDE) like Eclipse or IntelliJ IDEA for eas...

  • Answered by AI
  • Q9. What is the process for setting the path in Java?
  • Ans. 

    Setting the path in Java involves adding directories to the classpath to locate external libraries or resources.

    • Use the 'java -cp' command to set the classpath for a specific Java program.

    • You can also set the classpath using the CLASSPATH environment variable.

    • To add a JAR file to the classpath, use the '-cp' or '-classpath' option followed by the path to the JAR file.

    • For example, to set the classpath to include a JAR f...

  • Answered by AI
  • Q10. Do you have any questions for me?
Round 3 - HR 

(4 Questions)

  • Q1. Can you provide a self-introduction?
  • Ans. 

    Experienced Associate with a background in finance and strong analytical skills.

    • Background in finance with X years of experience

    • Strong analytical skills demonstrated through successful projects

    • Proven ability to work well in a team environment

  • Answered by AI
  • Q2. What additional hobbies do you engage in?
  • Ans. 

    I enjoy hiking, photography, and cooking in my free time.

    • Hiking: I love exploring new trails and being in nature.

    • Photography: I enjoy capturing moments and landscapes through my camera lens.

    • Cooking: I like experimenting with new recipes and cooking for friends and family.

  • Answered by AI
  • Q3. Are you willing to relocate?
  • Ans. 

    Yes, I am open to relocating for the right opportunity.

    • I am open to exploring new locations for career growth

    • I am willing to relocate for the right job offer

    • I have experience moving for previous job opportunities

  • Answered by AI
  • Q4. Do u have any questions for me?

Top LTIMindtree Associate Interview Questions and Answers

Q1. What are the differences between lists and arrays in the Python programming language?
View answer (1)

Associate Interview Questions asked at other Companies

Q1. What is mean of TTR & why required for powder coating process ?
View answer (17)

Senior Specialist - Java Architecture Interview Questions & Answers

user image Harsh Garg

posted on 14 Dec 2024

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Coding test provided on a platform that included two coding questions and about 20 MCQs. Time provided was definitely short, and my guess would be that they wanted interviewers to pick their battles, so to speak. 45% was enough to get to the next round and scoring above 65% meant an HR round directly.

Round 2 - One-on-one 

(7 Questions)

  • Q1. How can multithreading be implemented in a Java microservices application?
  • Ans. 

    Multithreading in Java microservices can be implemented using Java's built-in threading capabilities.

    • Use Java's Executor framework to manage threads in a microservices application.

    • Implement asynchronous processing using CompletableFuture to improve performance.

    • Consider using thread pools to manage resources efficiently.

    • Use synchronized blocks or locks to handle shared resources safely.

    • Leverage Java's concurrent data st...

  • Answered by AI
  • Q2. Sort a map of employees and their corresponding salaries using java streams.
  • Ans. 

    Sort a map of employees and their corresponding salaries using Java streams.

    • Use entrySet() to get a stream of key-value pairs from the map.

    • Use sorted() with a comparator to sort the stream based on salaries.

    • Collect the sorted stream back into a LinkedHashMap to maintain the order.

  • Answered by AI
  • Q3. What is the conditional property of Spring beans and how is it configured?
  • Ans. 

    Conditional property in Spring beans allows for conditional bean creation based on specified conditions.

    • Conditional property is used to conditionally create beans based on certain conditions.

    • It is configured using @Conditional annotation on the bean definition class.

    • Examples include @ConditionalOnProperty, @ConditionalOnClass, @ConditionalOnMissingBean, etc.

  • Answered by AI
  • Q4. What is the request filter for API requests and how is it configured to utilise different forms of authentication?
  • Ans. 

    Request filter for API requests is a mechanism to intercept and process incoming requests before they reach the intended endpoint.

    • Request filters can be implemented using frameworks like Spring Security in Java.

    • They can be configured to support different forms of authentication such as basic authentication, OAuth, JWT, etc.

    • Authentication mechanisms can be specified in the filter configuration to validate incoming reque

  • Answered by AI
  • Q5. How do you enable pagination in responses from a REST API ?
  • Ans. 

    Pagination in REST API responses can be enabled by using query parameters like 'page' and 'limit'.

    • Use query parameters like 'page' and 'limit' to specify the page number and number of items per page.

    • Implement logic in the backend to fetch and return the appropriate subset of data based on the page and limit values.

    • Include metadata in the response to indicate total number of items and current page number.

    • Example: /api/u...

  • Answered by AI
  • Q6. How would you implement a JUnit test for a REST API that you have developed?
  • Ans. 

    Implementing JUnit test for a REST API

    • Create a test class for the REST API endpoints

    • Use @RunWith(SpringRunner.class) and @SpringBootTest annotations

    • MockMvc to perform HTTP requests and validate responses

    • Use @Autowired to inject dependencies for testing

    • Assert statements to verify expected results

  • Answered by AI
  • Q7. How does the Circuit Breaker design pattern work?
  • Ans. 

    Circuit Breaker design pattern is used to prevent a system from repeatedly trying to execute an operation that is likely to fail.

    • Circuit Breaker monitors the number of failures when calling a remote service

    • If the failures exceed a certain threshold, the Circuit Breaker trips and stops further calls to the service

    • After a specified time, the Circuit Breaker allows a limited number of calls to test if the service is avail

  • Answered by AI

Interview Preparation Tips

Topics to prepare for LTIMindtree Senior Specialist - Java Architecture interview:
  • Java
  • Spring
  • Maven
  • Microservices
  • Design Patters
  • REST API
Interview preparation tips for other job seekers - The interviewers are knowledgeable and fairly technical. Be prepared to answer follow up questions based on your answers.

Specialist - Qulaity Engineering Interview Questions & Answers

user image Anonymous

posted on 20 Dec 2024

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

(5 Questions)

  • Q1. What is the difference between Regression Testing and Smoke Testing?
  • Ans. 

    Regression Testing is testing the application to ensure new code changes have not affected existing functionality, while Smoke Testing is a preliminary test to check if the software build is stable enough for further testing.

    • Regression Testing is performed after code changes to ensure that existing functionality is not impacted.

    • Smoke Testing is a quick test to check if the software build is stable enough for further te...

  • Answered by AI
  • Q2. What is the bug life cycle?
  • Ans. 

    Bug life cycle is the process of identifying, reporting, fixing, retesting, and closing bugs in software development.

    • Bug identification: Bugs are identified by testers during testing.

    • Bug reporting: Testers report bugs to developers with detailed information.

    • Bug fixing: Developers resolve the reported bugs.

    • Bug retesting: Testers verify if the fixed bugs are resolved.

    • Bug closing: Once the bug is confirmed fixed, it is cl

  • Answered by AI
  • Q3. Could you explain the automation framework you used in your last project?
  • Ans. 

    I used a keyword-driven automation framework in my last project.

    • The framework was based on keywords that represented actions or functionalities.

    • Test scripts were written using these keywords to perform automated tests.

    • The framework allowed for easy maintenance and scalability of test scripts.

    • It provided flexibility to easily add new test cases or modify existing ones.

    • Example: Keywords like 'click', 'inputText', 'verify...

  • Answered by AI
  • Q4. What is the difference between the `gettext()` and `getAttribute()` methods in Selenium?
  • Ans. 

    gettext() is used to retrieve text from a web element, while getAttribute() is used to retrieve the value of an attribute of a web element.

    • gettext() retrieves the visible text displayed on a web element, such as a button or a link.

    • getAttribute() retrieves the value of a specified attribute of a web element, such as 'href' for a link or 'value' for an input field.

    • Example: Using gettext() to retrieve the text displayed o...

  • Answered by AI
  • Q5. Write a java program to replace a specific character at a specified index?
  • Ans. 

    Java program to replace a specific character at a specified index in an array of strings.

    • Create a method that takes in the array of strings, index, and character to replace as parameters.

    • Use StringBuilder to modify the string at the specified index.

    • Return the updated array of strings.

  • Answered by AI
Round 2 - Technical 

(6 Questions)

  • Q1. What is the difference between absolute and relative XPath?
  • Ans. 

    Absolute XPath starts from the root node, while relative XPath starts from any node in the XML structure.

    • Absolute XPath starts with a single forward slash (/) and always starts from the root node of the XML document.

    • Relative XPath does not start with a forward slash and can start from any node in the XML document.

    • Absolute XPath is more brittle as any changes in the structure of the XML document can break the XPath, whi...

  • Answered by AI
  • Q2. What is the average number of test cases you automate on a daily basis?
  • Ans. 

    The average number of test cases automated daily varies depending on complexity and scope of testing.

    • The number of test cases automated daily can range from a few to dozens, depending on the project requirements.

    • Factors such as the size of the application, level of automation already in place, and availability of resources can impact the daily automation rate.

    • For example, in a small project with limited scope, an engin...

  • Answered by AI
  • Q3. What is the difference between the Verify and Assert commands?
  • Ans. 

    Verify is used to validate the condition of a test case, while Assert is used to validate the result of a test case.

    • Verify is used to check if a condition is true without stopping the execution of the test case.

    • Assert is used to check if a condition is true and if not, it stops the execution of the test case.

    • Verify is typically used for non-critical verifications, while Assert is used for critical verifications.

    • Example...

  • Answered by AI
  • Q4. What is the difference between implicit waits and explicit waits in automated testing?
  • Ans. 

    Implicit waits are applied globally and wait for a certain amount of time before throwing an exception, while explicit waits are applied to specific elements and wait for a certain condition to be met.

    • Implicit waits are set once and apply to all elements in the test script

    • Explicit waits are applied to specific elements and wait for a certain condition to be met

    • Implicit waits wait for a certain amount of time before thr...

  • Answered by AI
  • Q5. How can you handle frames in Selenium?
  • Ans. 

    Frames in Selenium can be handled using switchTo() method to navigate between frames.

    • Use driver.switchTo().frame() method to switch to a frame by index, name or WebElement

    • Use driver.switchTo().parentFrame() method to switch back to the parent frame

    • Use driver.switchTo().defaultContent() method to switch to the main content of the page

  • Answered by AI
  • Q6. Write a java program to copy an array by iteration the array
  • Ans. 

    Java program to copy an array by iterating through it

    • Create a new array with the same length as the original array

    • Use a for loop to iterate through the original array and copy each element to the new array

    • Return the new copied array

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. What are your salary expectations?
  • Ans. 

    I am looking for a competitive salary that reflects my experience and skills in the quality engineering field.

    • Research industry standards for quality engineering salaries

    • Consider your level of experience and expertise

    • Factor in location and cost of living

    • Be prepared to negotiate based on benefits and opportunities for growth

  • Answered by AI

LTIMindtree interview questions for popular designations

 Software Engineer

 (316)

 Senior Software Engineer

 (211)

 Software Developer

 (92)

 Senior Specialist

 (77)

 Graduate Engineer Trainee (Get)

 (73)

 Module Lead

 (72)

 Graduate Engineer

 (69)

 Graduate Trainee

 (66)

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Dec 2024.

Round 1 - Technical 

(4 Questions)

  • Q1. All Manual testings
  • Q2. Code for a Start pattern
  • Ans. 

    Code for a Start pattern

    • Use nested loops to print the pattern

    • Increment the number of stars in each row

    • Use a combination of spaces and stars to create the pattern

  • Answered by AI
  • Q3. Code for reverse string
  • Ans. 

    Code to reverse a string in an array of strings

    • Iterate through each string in the array

    • For each string, use a loop to reverse the characters

    • Store the reversed string back in the array

  • Answered by AI
  • Q4. Code to start Web browser,go to a specific url and find a element and display
  • Ans. 

    Use Selenium WebDriver to start a web browser, navigate to a specific URL, find an element, and display it.

    • Use Selenium WebDriver to automate browser actions

    • Instantiate a WebDriver object and open a browser

    • Use the get() method to navigate to the specified URL

    • Locate the desired element using findElement() method

    • Retrieve and display the element's text or attributes

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. About project,roles and responsibilities
  • Q2. Steps to start Mobile automation
  • Ans. 

    To start mobile automation, first identify the tools and frameworks, set up the testing environment, create test cases, and execute tests.

    • Identify the tools and frameworks suitable for mobile automation (e.g. Appium, Selenium)

    • Set up the testing environment with necessary software and devices

    • Create test cases based on requirements and user scenarios

    • Execute tests on different mobile devices and platforms to ensure compat

  • Answered by AI
  • Q3. Client meeting to handle them
  • Q4. Why you want to join us
  • Ans. 

    I am excited about the opportunity to contribute my expertise in quality engineering to a dynamic and innovative team.

    • I am impressed by the company's reputation for excellence in quality standards.

    • I am excited about the chance to work on cutting-edge projects and technologies.

    • I believe my skills and experience align well with the company's goals and values.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary negotiable

Top LTIMindtree Senior Quality Engineer Interview Questions and Answers

Q1. What is Requirement and what is requirement traceability matrix
View answer (1)

Senior Quality Engineer Interview Questions asked at other Companies

Q1. what is least count of vernier caliper ,micrometer, height gauge?
View answer (13)

Get interview-ready with Top LTIMindtree Interview Questions

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Approached by Company

Round 1 - Technical 

(2 Questions)

  • Q1. Complex project scenarios
  • Q2. Team management
Round 2 - Technical 

(2 Questions)

  • Q1. Program management questions
  • Q2. Delivery related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - They prefer hiring through backdoor channels rather than selecting genuine candidates. Unfortunately, the head of HR is also involved in this unethical practice. They often offer compensation that is lower than the stated Cost to Company (CTC). It is advisable to avoid joining this company. it’s worth waiting for other job than join here. Most unethical people to work. Data analytics is Mini cognizant.

Top LTIMindtree Associate Director Interview Questions and Answers

Q1. Primary scope of responsibilities, how risk identification is done and what mitigation steps are taken on delivery expectation
View answer (1)

Associate Director Interview Questions asked at other Companies

Q1. How will you manage the New location and ramp up the Resourcing as per business requirement
View answer (2)

Jobs at LTIMindtree

View all
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. About myself and my Day-to-day activities
  • Q2. About my role in the project, Packaging workflow and Life cycle.
  • Q3. How you handle user profile data?
  • Ans. 

    User profile data is securely stored in a centralized database with access control and encryption.

    • Store user profile data in a centralized database

    • Implement access control to restrict unauthorized access

    • Encrypt sensitive user information for added security

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Explain about which package you feel complex and why?
  • Ans. 

    I find the Kubernetes package to be complex due to its extensive features and configurations.

    • Kubernetes has a steep learning curve with various concepts like pods, deployments, services, etc.

    • Managing Kubernetes clusters requires understanding of networking, storage, security, and scalability.

    • Configuring Kubernetes involves YAML files, API resources, and command-line tools like kubectl.

    • Troubleshooting issues in Kubernet...

  • Answered by AI
  • Q2. Explain the difference between application model and package model in sccm?
  • Ans. 

    Application model in SCCM is used to deploy applications based on user-centric requirements, while package model is used for traditional software deployment.

    • Application model allows for user-centric deployments and dependencies, while package model is more rigid and requires manual intervention for dependencies.

    • Application model supports user device affinity, allowing for targeted deployments to specific users or devic...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. About my role in the package. Previous origination details?
  • Q2. Salary discussion and about my notice period

Top LTIMindtree Cloud Infrastructure Engineer Interview Questions and Answers

Q1. What is your understanding of Service Level Agreements (SLA)?
View answer (1)

Cloud Infrastructure Engineer Interview Questions asked at other Companies

Q1. What is your understanding of Service Level Agreements (SLA)?
View answer (1)

Software Engineer interview

user image OnlineStudy4u

posted on 18 Nov 2021

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

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

Round 1 - Technical 

(5 Questions)

  • Q1. Explain what is windows server.
  • Ans. 

    Windows Server is a group of operating systems designed by Microsoft for server use.

    • Windows Server is a group of operating systems developed by Microsoft.

    • It is specifically designed for use in server environments.

    • Windows Server provides features such as networking, storage, and virtualization capabilities.

    • Examples of Windows Server versions include Windows Server 2016 and Windows Server 2019.

  • Answered by AI
  • Q2. Explain what does intellimirror do
  • Ans. 

    Intellimirror is a feature in Windows Server that allows for centralized management of user desktop settings and files.

    • Intellimirror provides users with access to their desktop settings and files from any computer on the network.

    • It allows for automated backup and restoration of user data and settings.

    • Intellimirror can be used to deploy software applications to multiple computers in a network.

    • It helps in reducing IT sup...

  • Answered by AI
  • Q3. What does it mean by "tattooing" the registry
  • Ans. 

    Tattooing the registry refers to making permanent changes to the Windows registry that cannot be easily undone.

    • Tattooing the registry involves modifying critical system settings in the Windows registry.

    • These changes are typically irreversible and can have a significant impact on system performance and stability.

    • It is important to exercise caution when tattooing the registry as incorrect changes can lead to system error...

  • Answered by AI
  • Q4. Mention how many types of queries DNS does
  • Ans. 

    DNS can perform various types of queries including recursive, iterative, inverse, and dynamic updates.

    • DNS can perform recursive queries where it queries other servers on behalf of the client until it finds the answer.

    • Iterative queries involve the DNS server providing the best answer it can based on its own knowledge.

    • Inverse queries allow a DNS client to request the domain name associated with a specific IP address.

    • Dyna...

  • Answered by AI
  • Q5. Explain what is the primary function of the domain controller
  • Ans. 

    The primary function of the domain controller is to authenticate and authorize all users and computers in a Windows domain network.

    • Authenticating and authorizing users and computers in a Windows domain network

    • Managing security policies and access control

    • Maintaining Active Directory database

    • Enforcing security policies across the network

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Finding your dream job can be a challenging task with so many career options available. it's easy to feel lost and overwhelmed. However, with the right guidance and support, you can successfully navigate the job market and land the job of your dream. That's why we have brought in an expert career coach to answer some commonly asked questions and share tips to help job.

Top LTIMindtree Backup Administrator Interview Questions and Answers

Q1. what is your environment and which backups are taking?
View answer (1)

Backup Administrator Interview Questions asked at other Companies

Q1. what is the difference between nw9 and nw19 version?
View answer (2)
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Technical 

(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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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
  • 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 ...

  • Answered by AI
  • 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
  • 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
  • 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
Round 2 - Technical 

(2 Questions)

  • Q1. Scenario based. Write SQL and pyspark code for a dataset.
  • 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

Topics to prepare for LTIMindtree Data Engineer interview:
  • SQL
  • pyspark
  • ETL
Interview preparation tips for other job seekers - L2 was scheduled next day to L1 so the process is fast. Brush up your practical knowledge more.

Skills evaluated in this interview

Top LTIMindtree Data Engineer Interview Questions and Answers

Q1. 1) If you are given a card with 1-1000 numbers and there are 4 boxes. Card no 1 will go in box 1 , card 2 in box 2 and similarly it will go. Card 5 will again go in box 1. So what will be the logic for this code?
View answer (4)

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a GameYou and your friend Ninjax are playing a game of coins. Ninjax place the 'N' number of coins in a straight line. The rule of the game is as follows: 1. Each coin has a value associated with it. 2. It’s a two-playe... read more
View answer (6)

LTIMindtree Interview FAQs

How many rounds are there in LTIMindtree interview?
LTIMindtree interview process usually has 2-3 rounds. The most common rounds in the LTIMindtree interview process are Technical, HR and Aptitude Test.
How to prepare for LTIMindtree 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 SQL, Python, Javascript, Agile and Java.
What are the top questions asked in LTIMindtree interview?

Some of the top questions asked at the LTIMindtree interview -

  1. 1) If you are given a card with 1-1000 numbers and there are 4 boxes. Card no 1...read more
  2. 1.data dictionary concept-table creation steps How do you maintain TMG? What is...read more
  3. 5.enhancements What is enhancements? Types of enhancements? How do you find an...read more
How long is the LTIMindtree interview process?

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 Interview Process

based on 2.8k interviews

Interview experience

4.1
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Mphasis Interview Questions
3.4
 • 800 Interviews
Cyient Interview Questions
3.7
 • 282 Interviews
View all

LTIMindtree Reviews and Ratings

based on 20.6k reviews

3.8/5

Rating in categories

3.8

Skill development

3.8

Work-life balance

3.3

Salary

3.7

Job security

3.7

Company culture

3.0

Promotions

3.6

Work satisfaction

Explore 20.6k Reviews and Ratings
Senior Software Engineer

Bangalore / Bengaluru

3-6 Yrs

₹ 4.11-23.62 LPA

Specialist - Package Implementation

Kolkata

7-12 Yrs

₹ 14.4-32 LPA

Specialist - Package Implementation

Noida

3-6 Yrs

Not Disclosed

Explore more jobs
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