AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
LTIMindtree
Compare
Filter interviews by
LTIMindtree Interview Questions, Process, and Tips
Top LTIMindtree Interview Questions and Answers
- Q1. Prime Numbers Identification Given a positive integer N , your task is to identify all prime numbers less than or equal to N . Explanation: A prime number is a natural n ...read moreasked in Software Engineer interview
- Q2. in Angular what is services and how to call service api, and how bind our data with in component.asked in Senior Software Engineer interview
- Q3. Sum of Squares of First N Natural Numbers Problem Statement You are tasked with finding the sum of squares of the first N natural numbers for given test cases. Input: Th ...read moreasked in Software Developer interview
LTIMindtree Interview Experiences
2.9k interviews found
Graduate Engineer Trainee (Get) Interview Questions & Answers
Kanchan Pandhare
posted on 15 Mar 2015
Interview Questionnaire
16 Questions
- Q1. Write a program to display prime numbers from 1-35
- Ans.
Program to display prime numbers from 1-35
Loop through numbers 1-35
Check if each number is prime
If prime, display the number
- Q2. Write a program to reverse a string
- Ans.
A program to reverse a string
Create an empty string to store the reversed string
Loop through the original string from the end to the beginning
Add each character to the new string
Return the new string
- Q3. What is polymorphism?
- Ans.
Polymorphism is the ability of an object to take on many forms.
Polymorphism allows objects of different classes to be treated as if they are of the same class.
It can be achieved through method overloading or method overriding.
Example: A shape class can have different subclasses like circle, square, triangle, etc. and all can be treated as shapes.
Polymorphism helps in achieving code reusability and flexibility.
- Q4. Is method overloading possible in c++?
- Ans.
Yes, method overloading is possible in C++.
Method overloading allows multiple functions with the same name but different parameters.
The compiler determines which function to call based on the number and types of arguments passed.
Example: void print(int x), void print(float x), void print(char x) can all be overloaded.
Overloading can also be done with operators like +, -, *, /, etc.
Overloading improves code readability
- Q5. One question on database to find the max mks from student table
- Q6. BE project, what softwares you will use?
- Ans.
I will use software tools that are relevant to my BE project.
The software tools I will use will depend on the nature of my BE project.
For example, if my project involves designing a circuit, I may use software like LTSpice or Proteus.
If my project involves programming, I may use software like Visual Studio or Eclipse.
I will also use software for data analysis and visualization, such as MATLAB or Python.
Ultimately, I wi...
- Q7. Can we write int func() and int func(int a) in a single class?
- Ans.
Yes, we can write int func() and int func(int a) in a single class.
We can overload the function with different parameters.
The function with no parameter is called default constructor.
Example: class MyClass { int func(); int func(int a); };
Both functions can have different implementations.
- Q8. How to insert a java code in (html tags) 9
- Ans.
You can insert Java code in HTML tags using the <script> tag.
Use the <script> tag to insert Java code within HTML tags.
Make sure to properly close the <script> tag.
Example: <script>System.out.println('Hello, World!');</script>
- Q9. Features of OOPS
- Ans.
OOPS is a programming paradigm that focuses on objects and their interactions.
Encapsulation: bundling of data and methods that operate on that data
Inheritance: ability of a class to inherit properties and methods from a parent class
Polymorphism: ability of objects to take on multiple forms or behaviors
Abstraction: hiding of complex implementation details from the user
Examples: Java, C++, Python
- Q10. Any questions about the organization?
- Ans.
Yes, can you tell me more about the company culture and values?
What are the core values of the organization?
How does the company foster a positive work environment?
What is the company's approach to diversity and inclusion?
Can you provide examples of how the company supports employee growth and development?
- Q11. Previous companies attended by you
- Ans.
I have previously worked at three companies.
Worked as a software engineer at XYZ Inc. for 2 years
Interned at ABC Corp. for 6 months during college
Started my career as a junior developer at DEF Ltd. for 1 year
- Q12. Why didn't you clear the aptitude?
- Ans.
I didn't clear the aptitude because I lacked preparation and practice.
I didn't have enough time to prepare for the exam
I underestimated the difficulty level of the questions
I didn't practice enough mock tests
I lacked confidence during the exam
I have learned from my mistakes and will work harder next time
- Q13. What you learnt from this failure?
- Ans.
I learned the importance of thorough planning and communication.
Thorough planning can prevent oversights and mistakes.
Effective communication can prevent misunderstandings and ensure everyone is on the same page.
It's important to learn from mistakes and use them as opportunities for growth.
For example, in my previous project, we failed to properly plan for potential roadblocks and didn't communicate effectively with al...
- Q14. Are you ready to relocate? (she asked me this question 3 times)
- Q15. About weakness which was mentioned in the form given by them
- Q16. Any question about the organization?
- Ans.
Yes, we are a non-profit organization dedicated to promoting education in underprivileged communities.
Our organization focuses on providing educational resources to children in low-income areas.
We partner with local schools and community centers to offer after-school programs and tutoring services.
We also provide scholarships and grants to help students pursue higher education.
Our goal is to break the cycle of poverty ...
Interview Preparation Tips
Experience: Section 1 was quant. It was very simple. Practice basic questions
Logical reasoning and English sections were slightly tough than quantitative.Overall aptitude was simple and easy to pass
Tips: Try to attempt all questions because there is no negative marking.
Duration: 60 minutes
Total Questions: 60
Round: Group Discussion
Experience: Spoke about the Haryana district with the live examples of two sisters Geeta Kumari and Babita Kumari, who won gold medals in wrestling.
Also mentioned about Saina Nehwal.
Basically I agreed that India is not a mail dominant country.
Tips: Give examples as much as you can, examples portray how well you understand the topic. The examples should be about recent happenings
It also shows how much are you aware about the current scenario.
Stick to one side, if you are speak the first point for the topic, that is "India is a male dominant country" then don't go against this during the second point
No of times you speak, also matters.
Duration: 20-25mins minutes
Round: Technical Interview
Experience: I didn't answer 2 questions, it is fine if you don't answer the question rather than making the interviewer fool
Tips: Prepare core subjects very well
Be prepared to answer the last question, it shows your interest in the company
Round: HR Interview
Experience: It was my third company in campus. So the first question was surely expected, and I was prepared for that. If you clear the technical round then the ball is in your court. You can ace the HR round.
Tips: Just be yourself. Be prepared with basic HR questions.
Round: Paragraph writing
Experience: Topic - Effect of public holidays on Indian economy
Tips: Write atmost one page.3/4th page is also fine.
Skills: Programming , Communication Skills, Database Skills
College Name: VIDYALANKAR INSTITUTE OF TECHNOLOGY
Skills evaluated in this interview
Top LTIMindtree Graduate Engineer Trainee (Get) Interview Questions and Answers
Graduate Engineer Trainee (Get) Interview Questions asked at other Companies
Anonymous
(2 Questions)
- Q1. Azure cloud platform tech
- Q2. Informatica tech stack ques
(2 Questions)
- Q1. Adf tech stack que
- Q2. Scd type 2 implementation
- Ans.
SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.
Identify the columns that need to be tracked for changes
Add effective start and end dates to track the validity of each record
Insert new records for changes and update end dates for previous records
Maintain a surrogate key to uniquely identify each version of the record
(2 Questions)
- Q1. Dw related que ans
- Q2. Solution design related que
(2 Questions)
- Q1. Aspiration from my end
- Q2. How soon can join
- Ans.
I can join the team within 2 weeks.
I can start within 2 weeks of receiving the offer.
I need to give notice to my current employer.
I may need to relocate, which could affect my start date.
Interview Preparation Tips
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.
Skills evaluated in this interview
Top LTIMindtree Technical Lead Interview Questions and Answers
Technical Lead Interview Questions asked at other Companies
Selected
Quantitative Aptitude, Logical Reasoning, English Comprehension, Computer Science, Versant
(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
- 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
- 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
- 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.
- 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
- 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...
- 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.
- 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...
- 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...
- Q10. Do you have any questions for me?
(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
- 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.
- 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
- Q4. Do u have any questions for me?
Top LTIMindtree Associate Interview Questions and Answers
Associate Interview Questions asked at other Companies
What people are saying about LTIMindtree
Harsh Garg
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
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.
(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...
- 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.
- 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.
- 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
- 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...
- 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
- 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
Interview Preparation Tips
- Java
- Spring
- Maven
- Microservices
- Design Patters
- REST API
LTIMindtree interview questions for popular designations
(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...
- 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
- 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...
- 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...
- 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.
(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...
- 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...
- 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...
- 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...
- 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
- 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
(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
Get interview-ready with Top LTIMindtree Interview Questions
Selected
I was interviewed in Dec 2024.
(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
- 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
- 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
(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
- 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.
(1 Question)
- Q1. Salary negotiable
Top LTIMindtree Senior Quality Engineer Interview Questions and Answers
Senior Quality Engineer Interview Questions asked at other Companies
Jobs at LTIMindtree
Selected
I was interviewed in Feb 2025.
(1 Question)
- Q1. Question related to Snowflake architecture and usage understanding in details
Performance tuning the process with snowflake cortex and streamlite
(1 Question)
- Q1. Previous organization data capture future endeavors and flexibility to relocate
- Ans.
Yes, my previous organization regularly captured data on employees' future career goals and their flexibility to relocate.
Previous organization had a system in place to track employees' career aspirations and willingness to relocate
Regular surveys or discussions were conducted to gather this information
This data was used for succession planning and talent management
Employees were given opportunities based on their care
Selected
I applied via Approached by Company
(2 Questions)
- Q1. Complex project scenarios
- Q2. Team management
(2 Questions)
- Q1. Program management questions
- Q2. Delivery related questions
Interview Preparation Tips
Top LTIMindtree Associate Director Interview Questions and Answers
Associate Director Interview Questions asked at other Companies
Selected
I applied via Referral and was interviewed in Nov 2024. There were 3 interview rounds.
(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
(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...
- 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...
(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
Cloud Infrastructure Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(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.
- 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...
- 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...
- 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...
- 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
Interview Preparation Tips
Top LTIMindtree Backup Administrator Interview Questions and Answers
Backup Administrator Interview Questions asked at other Companies
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.
- 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
Top LTIMindtree Data Engineer Interview Questions and Answers
Data Engineer Interview Questions asked at other Companies
LTIMindtree Interview FAQs
Some of the top questions asked at the LTIMindtree interview -
The duration of LTIMindtree interview process can vary, but typically it takes about less than 2 weeks to complete.
Recently Viewed
INTERVIEWS
FIS
No Interviews
INTERVIEWS
NTT Data
No Interviews
INTERVIEWS
FIS
No Interviews
SALARIES
LTIMindtree
SALARIES
LTIMindtree
SALARIES
Ind-Swift Laboratories
INTERVIEWS
Xoriant
No Interviews
INTERVIEWS
Altimetrik
No Interviews
DESIGNATION
LIST OF COMPANIES
Discover companies
Find best workplace
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
LTIMindtree Interview Process
based on 2.9k interviews
Interview experience
Explore Interview Questions and Answers for Top Skills at LTIMindtree
Interview Questions from Similar Companies
Fast track your campus placements
LTIMindtree Reviews and Ratings
based on 21k reviews
Rating in categories
|
Senior Software Engineer
21.3k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
16.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
6.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Module Lead
5.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Engineer
4.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
Capgemini
Accenture
TCS
- Home >
- Interviews >
- LTIMindtree Interview Questions
