i
LTIMindtree
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
Implementing a data platform using Snowflake involves several key steps from planning to deployment and optimization.
1. Define Business Requirements: Identify the data needs and use cases, such as analytics or reporting.
2. Data Architecture Design: Plan the architecture, including data ingestion, storage, and processing layers.
3. Set Up Snowflake Account: Create a Snowflake account and configure necessary settings...
A manuscript in Duck Creek is a customizable template for insurance policy documents and workflows.
Manuscripts allow insurers to tailor policy forms to meet specific regulatory and business needs.
They can include various components like coverage details, exclusions, and endorsements.
For example, a manuscript might be created for a unique commercial property insurance policy.
Manuscripts can be version-controlled to...
L1 and L2 support refer to different levels of technical support in operational projects, addressing issues of varying complexity.
L1 support handles basic issues like password resets and user inquiries.
L2 support deals with more complex problems, such as software bugs or system errors.
Example of L1: A user calls to report they can't log in; L1 resets their password.
Example of L2: A user reports a software crash; L...
UAT in Agile projects typically occurs at the end of each iteration or sprint, validating the product with end-users.
UAT (User Acceptance Testing) is conducted after the completion of development in a sprint.
It involves real users testing the product to ensure it meets their needs and requirements.
For example, in a software project, UAT might involve users testing a new feature to confirm it works as intended.
UAT ...
What people are saying about LTIMindtree
Overloading and overriding enhance code flexibility and reusability in object-oriented programming.
Overloading allows methods to have the same name with different parameters. Example: 'add(int a, int b)' and 'add(double a, double b)'.
Overriding enables a subclass to provide a specific implementation of a method already defined in its superclass. Example: 'public void display()' in both parent and child classes.
In ...
Automation frameworks streamline testing processes, enhancing efficiency and maintainability in software development.
1. Linear Framework: Simple and straightforward, ideal for small projects. Example: A single script executing a series of test cases.
2. Modular Framework: Breaks tests into smaller, manageable modules. Example: Testing different components of a web application separately.
3. Data-Driven Framework: Us...
Hints in PL/SQL guide the optimizer to improve query performance by influencing execution plans.
Hints are special comments in SQL statements that provide instructions to the optimizer.
Examples include 'USE_NL' to enforce a nested loop join or 'INDEX' to force the use of a specific index.
They can help in scenarios where the optimizer's default choices lead to suboptimal performance.
Hints can be used to control join...
Indexes are database structures that improve query performance by allowing faster data retrieval.
Indexes are like a book's index, helping locate data quickly without scanning the entire table.
They are stored in a separate structure, often as B-trees or hash tables, which organize data for efficient access.
For example, a B-tree index allows for logarithmic time complexity for search operations.
Indexes can be unique...
A materialized view is a database object that stores the result of a query for faster access and can be refreshed periodically.
Materialized views store data physically, unlike regular views which are virtual.
They can improve performance for complex queries by precomputing and storing results.
Refresh mechanisms include:
1. Complete Refresh: Rebuilds the entire materialized view from the base tables.
Example: `REF...
An explain plan provides details on how a SQL query will be executed, including the execution path and resource usage.
Execution Order: Shows the sequence in which operations are performed, e.g., SELECT, JOIN, FILTER.
Access Methods: Indicates how data is accessed, such as full table scans or index scans.
Join Methods: Describes how tables are joined, e.g., nested loops, hash joins.
Cost Estimates: Provides estimated ...
Azure virtual network gateway is a service that enables you to establish secure, cross-premises connectivity.
It provides site-to-site VPN connectivity between on-premises and Azure virtual networks.
It supports both policy-based and route-based VPNs.
It can be used to connect virtual networks across different regions.
It can be configured to use ExpressRoute for private connectivity to Azure services.
It provides high avai...
Fault and update domains are concepts used in cloud computing to ensure high availability and minimize downtime.
A fault domain is a group of resources that share a common point of failure, such as a power source or network switch.
An update domain is a group of resources that can be updated or restarted at the same time without affecting the availability of the application.
By spreading resources across multiple fault an...
posted on 6 May 2025
I appeared for an interview in Apr 2025, where I was asked the following questions.
Tosca is a test automation tool that supports API testing, enhancing efficiency and accuracy in software testing processes.
API Scanning: Tosca can automatically scan APIs to identify endpoints, methods, and parameters, streamlining the testing process.
Authentication Validation: Tosca supports various authentication methods (e.g., OAuth, Basic Auth) to ensure secure access to APIs during testing.
Test Case Design: Users ...
Synchronization is essential in software to manage concurrent processes and ensure data consistency across threads.
Data Consistency: Synchronization prevents data corruption by ensuring that only one thread can access shared resources at a time.
Thread Safety: Using synchronization mechanisms like locks or semaphores ensures that critical sections of code are executed by one thread at a time.
Deadlock Prevention: Proper ...
API with CI/CD pipeline integration automates the deployment and testing of APIs, ensuring faster and more reliable software delivery.
Automated Testing: CI/CD pipelines can run automated tests on APIs to ensure functionality and performance before deployment.
Continuous Deployment: Changes to the API can be automatically deployed to production, reducing manual intervention and speeding up release cycles.
Version Control:...
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
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.
I appeared for an interview in Mar 2025, where I was asked the following questions.
I appeared for an interview in Jun 2025, where I was asked the following questions.
This Groovy script automates data processing and integration tasks using various libraries and methods.
Uses Groovy's built-in methods for data manipulation.
Integrates with external APIs for data retrieval, e.g., fetching user data.
Handles JSON and XML formats for data interchange.
Implements error handling to manage exceptions during execution.
Retry refers to the process of attempting an operation again after a failure, often used in integration and software systems.
Retry mechanisms are essential in integration to handle transient failures, such as network issues.
For example, if a service call fails due to a timeout, a retry can be attempted after a brief pause.
Exponential backoff is a common strategy where the wait time increases with each subsequent failur...
Quantitative Aptitude, Logical Reasoning, English Comprehension, Computer Science, Versant
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
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
I utilized technologies such as Python, SQL, and Tableau in my project.
Python
SQL
Tableau
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.
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...
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...
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.
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...
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...
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
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.
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
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.
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...
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.
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.
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...
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...
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
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...
I appeared for an interview in May 2025, where I was asked the following questions.
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...
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...
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...
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...
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.
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...
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...
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...
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...
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
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
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
I appeared for an interview in Dec 2024.
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
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
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
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...
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.
I applied via Approached by Company
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.
based on 3k interview experiences
Difficulty level
Duration
based on 22.9k reviews
Rating in categories
Hyderabad / Secunderabad,
Pune
+14-9 Yrs
Not Disclosed
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