LTIMindtree
Global technology consulting and digital solutions company.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Backend Engineer
•
Behavioral
•
medium
Tell me about a time you found a critical bug in production. What was your step-by-step approach to diagnosing and fixing it?
#Debugging
#Incident Management
#Root Cause Analysis
Backend Engineer
•
Behavioral
•
easy
How do you ensure code quality and maintainability within your development team?
#Code Review
#Testing
#CI/CD
Backend Engineer
•
Behavioral
•
medium
Describe a situation where you had to deliver a critical feature under a very tight deadline. What was your approach?
#Time Management
#Prioritization
#Agile
Backend Engineer
•
Behavioral
•
medium
Tell me about a time you had a disagreement with a client or product manager regarding a technical requirement. How did you handle it?
#Communication
#Conflict Resolution
#Consulting
Backend Engineer
•
Behavioral
•
easy
Why do you want to join LTIMindtree, and how does your experience align with our focus on enterprise digital transformation?
#Company Knowledge
#Career Goals
#Motivation
Backend Engineer
•
Behavioral
•
medium
Tell me about a time you had a disagreement with a client or product owner regarding a technical requirement. How did you handle it?
#Communication
#Conflict Resolution
#Client Management
Backend Engineer
•
Behavioral
•
medium
Describe a situation where you had to deliver a critical project under a very tight deadline. What trade-offs did you make?
#Time Management
#Prioritization
#Agile
Backend Engineer
•
Behavioral
•
easy
How do you ensure code quality and mentor junior developers in your team?
#Mentorship
#Code Review
#Best Practices
Backend Engineer
•
Behavioral
•
medium
Tell me about a time you identified a major bottleneck or bug in production. How did you troubleshoot and resolve it?
#Problem Solving
#Incident Management
#Accountability
Backend Engineer
•
Coding
•
easy
Given an array of integers and an integer target, return indices of the two numbers such that they add up to target. You may assume that each input would have exactly one solution.
#Arrays
#HashMaps
Backend Engineer
•
Coding
•
medium
Given a string s, find the length of the longest substring without repeating characters.
#Strings
#Sliding Window
#Hash Set
Backend Engineer
•
Coding
•
medium
Given an array of intervals where intervals[i] = [starti, endi], merge all overlapping intervals, and return an array of the non-overlapping intervals.
#Arrays
#Sorting
Backend Engineer
•
Coding
•
easy
Write a function to reverse a singly linked list.
#Linked List
#Pointers
Backend Engineer
•
Coding
•
easy
Write a program to find the node at which the intersection of two singly linked lists begins.
#Linked List
#Two Pointers
Backend Engineer
•
Coding
•
medium
Given an integer array nums and an integer k, return the k most frequent elements. You may return the answer in any order.
#Arrays
#Hash Table
#Heap
#Bucket Sort
Backend Engineer
•
Coding
•
medium
Design and implement a data structure for Least Recently Used (LRU) cache.
#Design
#Hash Table
#Doubly Linked List
Backend Engineer
•
Coding
•
medium
Write an SQL query to find employees who earn more than their managers. Assume an Employee table with Id, Name, Salary, and ManagerId.
#SQL
#Self Join
Backend Engineer
•
Coding
•
medium
Find the first non-repeating character in a stream of characters.
#Queues
#HashMaps
#Data Streams
Backend Engineer
•
Coding
•
medium
Given a list of Employee objects, write a Java 8 Streams API snippet to find the second highest salary in the organization.
#Java 8
#Streams API
#Lambda Expressions
Backend Engineer
•
Coding
•
medium
Given a string, reverse the words in the string while maintaining the original punctuation marks and spaces.
#Strings
#Two Pointers
Backend Engineer
•
Coding
•
medium
Write a function to find the longest substring without repeating characters in a given string.
#Strings
#Sliding Window
Backend Engineer
•
Coding
•
medium
Given an array of intervals where intervals[i] = [starti, endi], merge all overlapping intervals, and return an array of the non-overlapping intervals that cover all the intervals in the input.
#Arrays
#Sorting
Backend Engineer
•
Coding
•
medium
Find the top K frequent elements in an integer array. Your algorithm's time complexity must be better than O(n log n).
#Heaps
#HashMaps
#Bucket Sort
Backend Engineer
•
Coding
•
easy
Write a program to detect if a linked list has a cycle in it. Can you do it using O(1) memory?
#Linked Lists
#Two Pointers
Backend Engineer
•
Coding
•
easy
Given an array of integers nums and an integer target, return indices of the two numbers such that they add up to target. You may assume that each input would have exactly one solution.
#Arrays
#Hash Table
Backend Engineer
•
Coding
•
easy
Given a string s containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid.
#Strings
#Stack
Backend Engineer
•
System Design
•
hard
Design the backend for an E-commerce checkout system that needs to handle massive concurrent traffic during a Black Friday sale.
#High Availability
#Message Queues
#Concurrency
#Database Sharding
Backend Engineer
•
System Design
•
medium
Design a centralized Notification System capable of sending Emails, SMS, and Push notifications for a large enterprise client.
#Microservices
#Asynchronous Processing
#Third-party Integration
Backend Engineer
•
System Design
•
medium
Design a scalable URL Shortener service like TinyURL. How would you handle high read throughput and ensure unique short URLs?
#Scalability
#Hashing
#Caching
#Database Design
Backend Engineer
•
System Design
•
medium
Explain how you would use Apache Kafka to decouple microservices in an order processing system. What are topics, partitions, and consumer groups?
#Kafka
#Event-Driven Architecture
#Messaging
Backend Engineer
•
System Design
•
hard
How would you design a distributed Rate Limiter for a public-facing API to prevent abuse?
#API Gateway
#Algorithms
#Redis
Backend Engineer
•
System Design
•
hard
In a microservices architecture, how do you handle distributed transactions across multiple independent services?
#Distributed Systems
#Saga Pattern
#Two-Phase Commit
#Event-Driven Architecture
Backend Engineer
•
System Design
•
medium
Design a URL shortening service like Bitly. Focus on the database schema, API endpoints, and read/write scalability.
#Scalability
#API Design
#Database Schema
Backend Engineer
•
System Design
•
hard
Design a distributed rate limiter for a public-facing API to prevent abuse.
#Distributed Systems
#Algorithms
#Redis
Backend Engineer
•
System Design
•
medium
How would you design a notification system that sends emails, SMS, and push notifications to millions of users?
#Asynchronous Processing
#Message Queues
#Microservices
Backend Engineer
•
System Design
•
medium
Design a logging and monitoring architecture for a microservices-based e-commerce platform.
#Observability
#Logging
#Distributed Tracing
Backend Engineer
•
Technical
•
medium
What is the N+1 select problem in Spring Data JPA / Hibernate, and how do you resolve it?
#ORM
#Database Optimization
#Spring Data JPA
Backend Engineer
•
Technical
•
medium
Explain the internal working of ConcurrentHashMap in Java 8. How does it differ from Java 7?
#Collections
#Multithreading
#Java 8
Backend Engineer
•
Technical
•
medium
What is the difference between map() and flatMap() in Java 8 Streams? Provide a real-world use case for each.
#Streams API
#Functional Programming
Backend Engineer
•
Technical
•
medium
Write a Java 8 Stream operation to group a list of Employee objects by department and find the highest earner in each department.
#Streams API
#Collectors
Backend Engineer
•
Technical
•
hard
How do you handle memory leaks in a Java application? What tools and JVM flags would you use to troubleshoot?
#JVM
#Performance Tuning
#Troubleshooting
Backend Engineer
•
Technical
•
medium
Explain the ExecutorService framework. How would you configure a thread pool for an application with heavy I/O bound tasks versus CPU bound tasks?
#Multithreading
#Concurrency
Backend Engineer
•
Technical
•
medium
What is the difference between CompletableFuture and the standard Future interface in Java?
#Concurrency
#Asynchronous Programming
Backend Engineer
•
Technical
•
hard
How does the JVM Garbage Collector work? Explain the difference between G1GC and ZGC.
#JVM
#Garbage Collection
Backend Engineer
•
Technical
•
medium
How does Spring Boot auto-configuration work under the hood? Explain the role of @EnableAutoConfiguration.
#Spring Boot Internals
#Annotations
Backend Engineer
•
Technical
•
easy
Explain the exact differences between @Component, @Service, @Repository, and @Controller in Spring.
#Spring Core
#Annotations
Backend Engineer
•
Technical
•
medium
How do you implement global exception handling in a Spring Boot REST API?
#REST APIs
#Exception Handling
Backend Engineer
•
Technical
•
medium
What is the N+1 select problem in Hibernate/Spring Data JPA, and how do you resolve it?
#JPA
#Hibernate
#Database Performance
Backend Engineer
•
Technical
•
hard
How do you handle distributed transactions across multiple microservices in a Spring Boot ecosystem?
#Distributed Systems
#Transactions
#Saga Pattern
Backend Engineer
•
Technical
•
medium
Explain how you would secure a Spring Boot microservice using OAuth2 and JWT.
#Security
#OAuth2
#JWT
Backend Engineer
•
Technical
•
medium
What is the role of an API Gateway in a microservices architecture? What specific tasks does it handle?
#Architecture
#API Gateway
Backend Engineer
•
Technical
•
medium
How do you implement circuit breakers in Spring Boot, and why are they necessary?
#Resilience
#Circuit Breaker
#Resilience4j
Backend Engineer
•
Technical
•
medium
Explain the difference between clustered and non-clustered indexes in a relational database.
#Database Indexing
#Performance
Backend Engineer
•
Technical
•
easy
Write a SQL query to find the second highest salary from an Employee table without using the LIMIT or TOP keywords.
#SQL Queries
#Aggregations
Backend Engineer
•
Technical
•
medium
What are ACID properties, and how does a relational database ensure the Isolation property?
#Database Theory
#Transactions
Backend Engineer
•
Technical
•
medium
In what specific scenarios would you choose a NoSQL database like MongoDB over a relational database like PostgreSQL?
#Databases
#NoSQL
#Architecture
Backend Engineer
•
Technical
•
hard
How do you optimize a slow-running SQL query in a production environment?
#Performance Tuning
#Query Optimization
Backend Engineer
•
Technical
•
medium
Explain how the @SpringBootApplication annotation works internally. What other annotations does it encapsulate?
#Spring Boot
#Annotations
#Auto-configuration
Backend Engineer
•
Technical
•
medium
What is the difference between HashMap and ConcurrentHashMap in Java? How does ConcurrentHashMap achieve thread safety without locking the entire map?
#Data Structures
#Multithreading
#Concurrency
Backend Engineer
•
Technical
•
hard
Explain the Java Garbage Collection process. If your application throws an OutOfMemoryError in production, how would you troubleshoot it?
#JVM
#Garbage Collection
#Performance Tuning
#Memory Management
Backend Engineer
•
Technical
•
medium
How do you secure a Spring Boot microservice using JWT? Explain the flow of token generation and validation.
#Spring Security
#JWT
#Authentication
#Authorization
Backend Engineer
•
Technical
•
medium
Explain the Circuit Breaker pattern. Have you used tools like Resilience4j or Hystrix? How do you configure fallback methods?
#Fault Tolerance
#Design Patterns
#Resilience4j
Backend Engineer
•
Technical
•
medium
What is the difference between Future and CompletableFuture in Java? Give an example of when you would use CompletableFuture.
#Multithreading
#Asynchronous Programming
#Java 8
Backend Engineer
•
Technical
•
easy
Explain the ACID properties in the context of a relational database. Give a real-world example of how Isolation is maintained during a bank transfer.
#RDBMS
#Transactions
#ACID
Backend Engineer
•
Technical
•
medium
What is the difference between a clustered and a non-clustered index in SQL Server or MySQL?
#SQL
#Indexing
#Performance Tuning
Backend Engineer
•
Technical
•
medium
If an enterprise client asks you to choose between PostgreSQL and MongoDB for a new project, what factors would drive your decision?
#SQL vs NoSQL
#System Design
#Data Modeling
Backend Engineer
•
Technical
•
easy
Explain the different types of JOINs in SQL. What is the difference between a LEFT JOIN and an INNER JOIN?
#SQL
#Joins
Backend Engineer
•
Technical
•
medium
You have a slow-running SQL query in production. What steps would you take to optimize it?
#Performance Tuning
#SQL
#Execution Plan
Backend Engineer
•
Technical
•
medium
In Hibernate, what is the exact difference between the save() and persist() methods?
#ORM
#Hibernate
Cloud Engineer
•
Behavioral
•
easy
You notice that a developer has accidentally committed an AWS Access Key to a public GitHub repository. What are your immediate next steps?
#Incident Response
#Security
#AWS
Cloud Engineer
•
Behavioral
•
medium
Tell me about a time you failed to meet a project deadline. What went wrong, and what did you learn from the experience?
#Time Management
#Accountability
#Continuous Improvement
Cloud Engineer
•
Behavioral
•
medium
A client demands a new feature deployment immediately, but it violates the company's security compliance standards. How do you handle this situation?
#Security
#Client Management
#Ethics
Cloud Engineer
•
Behavioral
•
easy
Describe your experience with Agile methodologies. How do you integrate infrastructure provisioning into two-week sprints?
#Agile
#DevOps
#Project Management
Cloud Engineer
•
Behavioral
•
medium
Tell me about a time you had a disagreement with a client regarding a technical architectural decision. How did you resolve it?
#Conflict Resolution
#Client Management
#Communication
Cloud Engineer
•
Behavioral
•
medium
Describe a time when you had to handle a critical P1 incident for a client. What was your troubleshooting process and how did you communicate with stakeholders?
#Incident Management
#Communication
#Client Facing
Cloud Engineer
•
Coding
•
medium
Write a Bash script that parses an Nginx access log file, counts the number of 5xx HTTP status codes, and alerts via email if the count exceeds 100 in an hour.
#Bash
#Linux
#Log Parsing
#Monitoring
Cloud Engineer
•
Coding
•
medium
Write a Bash script to backup a specific directory, compress it into a tarball, append the current date to the filename, and upload it to an AWS S3 bucket.
#Bash
#Linux
#AWS CLI
Cloud Engineer
•
Coding
•
medium
Write a Dockerfile for a basic Node.js application. How would you optimize this Dockerfile to minimize the image size and improve security?
#Docker
#Node.js
#Security
Cloud Engineer
•
Coding
•
medium
Write a Python function to validate if a given string is a valid IPv4 address.
#Python
#String Manipulation
#Networking
Cloud Engineer
•
Coding
•
easy
Given an array of integers and an integer target, return indices of the two numbers such that they add up to target. (Two Sum)
#Arrays
#Hash Maps
#Data Structures
Cloud Engineer
•
Coding
•
medium
Write a Python script using Boto3 to find and delete all unattached EBS volumes in an AWS account to save costs.
#Python
#Boto3
#AWS
#Cost Optimization
Cloud Engineer
•
System Design
•
hard
A client wants to migrate a monolithic application to microservices on Kubernetes. Walk me through your deployment strategy to ensure zero downtime.
#Kubernetes
#Microservices
#Deployment Strategies
#Migration
Cloud Engineer
•
System Design
•
medium
Design a CI/CD pipeline using Jenkins or GitHub Actions for a Java Spring Boot application. Include stages for testing, code quality, image scanning, and deployment.
#CI/CD
#Jenkins
#GitHub Actions
#Security
Cloud Engineer
•
System Design
•
medium
Design a serverless data ingestion pipeline on AWS that receives JSON payloads from IoT devices, validates them, and stores them in a data warehouse.
#AWS
#Serverless
#IoT
#Data Pipeline
Cloud Engineer
•
System Design
•
medium
How do you optimize cloud costs for an enterprise client who has heavily over-provisioned their AWS environment?
#AWS
#Cost Optimization
#FinOps
Cloud Engineer
•
System Design
•
hard
Design a Disaster Recovery (DR) plan for a critical financial application hosted on Azure. What RTO and RPO considerations would you make?
#Azure
#Disaster Recovery
#Architecture
Cloud Engineer
•
System Design
•
hard
Design a highly available and fault-tolerant 3-tier web application architecture on Azure. Which services would you use and why?
#Azure
#High Availability
#Architecture
Cloud Engineer
•
System Design
•
hard
Design an automated patching strategy for a fleet of 1000+ EC2 instances across multiple AWS accounts and regions without causing downtime.
#AWS
#Automation
#Security
#Systems Administration
Cloud Engineer
•
Technical
•
hard
How does DNS resolution work in a hybrid cloud environment where on-premises servers need to resolve AWS Route 53 private hosted zones?
#AWS
#Networking
#DNS
#Hybrid Cloud
Cloud Engineer
•
Technical
•
easy
What is the difference between an Application Load Balancer (ALB) and a Network Load Balancer (NLB)? When would you choose one over the other?
#AWS
#Load Balancing
#Networking
Cloud Engineer
•
Technical
•
medium
A pod in your Kubernetes cluster is stuck in a 'CrashLoopBackOff' state. Walk me through the exact steps and kubectl commands you would use to troubleshoot it.
#Kubernetes
#Troubleshooting
#Docker
Cloud Engineer
•
Technical
•
medium
What is the difference between a Kubernetes Deployment and a StatefulSet? Give a use case for each.
#Kubernetes
#Architecture
Cloud Engineer
•
Technical
•
hard
Explain how you would set up cross-account access for an S3 bucket so that an IAM role in Account A can read objects in an S3 bucket in Account B.
#AWS
#IAM
#S3
#Security
Cloud Engineer
•
Technical
•
easy
What are Terraform modules? How do they help in adhering to DRY (Don't Repeat Yourself) principles?
#Terraform
#Best Practices
Cloud Engineer
•
Technical
•
medium
How do you manage Terraform state files in a multi-developer environment? What happens if two developers try to apply changes simultaneously?
#Terraform
#State Management
#Collaboration
Cloud Engineer
•
Technical
•
medium
How does AWS Lambda handle cold starts, and what strategies can you implement to mitigate cold start latency in a production environment?
#AWS
#Serverless
#Performance
Cloud Engineer
•
Technical
•
medium
Explain the difference between Ingress and Egress in the context of Kubernetes network policies.
#Kubernetes
#Networking
#Security
Cloud Engineer
•
Technical
•
hard
What is a Service Mesh? Why would you choose to implement Istio in an EKS cluster?
#Kubernetes
#Service Mesh
#Istio
#AWS
Cloud Engineer
•
Technical
•
medium
Explain the '6 R's' of cloud migration. Give an example of when you would choose 'Refactor' over 'Rehost'.
#Cloud Migration
#Architecture
Cloud Engineer
•
Technical
•
medium
How do you integrate Prometheus and Grafana for monitoring an Azure Kubernetes Service (AKS) cluster?
#Azure
#Kubernetes
#Monitoring
#Prometheus
Cloud Engineer
•
Technical
•
medium
Explain the architecture of a VPC you have designed. How did you configure public and private subnets, NAT gateways, and route tables to ensure security?
#AWS
#VPC
#Networking
#Security
Cloud Engineer
•
Technical
•
medium
How do you securely manage secrets, such as database passwords and API keys, in a CI/CD pipeline?
#CI/CD
#Security
#Secret Management
Cloud Engineer
•
Technical
•
medium
Explain the concept of 'Immutable Infrastructure'. What are its benefits and how do you achieve it using tools like Packer and Terraform?
#DevOps Concepts
#Packer
#Terraform
Cloud Engineer
•
Technical
•
medium
What are Azure ARM templates? How do they compare to Terraform, and why might a company choose one over the other?
#Azure
#Terraform
#ARM Templates
Data Engineer
•
Behavioral
•
medium
Tell me about a time your data pipeline failed in production. How did you troubleshoot it and communicate the delay to business stakeholders?
#Incident Management
#Communication
#Problem Solving
Data Engineer
•
Behavioral
•
hard
Describe a time when you disagreed with a senior engineer or architect regarding the choice of a tool or design pattern for a data pipeline.
#Conflict Resolution
#Collaboration
#Technical Leadership
Data Engineer
•
Behavioral
•
medium
Tell me about a time you had to handle a sudden change in project requirements from the client right before a sprint deadline.
#Agile Methodology
#Time Management
#Client Management
Data Engineer
•
Behavioral
•
medium
Describe a situation where you had to explain a complex technical data architecture or pipeline issue to a non-technical stakeholder.
#Stakeholder Management
#Communication
#Business Acumen
Data Engineer
•
Behavioral
•
medium
Tell me about a time your data pipeline failed in production. How did you troubleshoot, resolve it, and ensure it didn't happen again?
#Incident Management
#Root Cause Analysis
#Continuous Improvement
Data Engineer
•
Behavioral
•
medium
Tell me about a time you had to optimize a slow-running query or pipeline. What steps did you take?
#Performance Tuning
#Problem Solving
#Impact
Data Engineer
•
Behavioral
•
easy
Describe your experience working in an Agile environment. How do you estimate story points for a complex data engineering task?
#Agile
#Scrum
#Estimation
Data Engineer
•
Behavioral
•
easy
Why do you want to join LTIMindtree, and how does this Data Engineer role align with your long-term career goals?
#Career Goals
#Company Culture
#Self-Awareness
Data Engineer
•
Coding
•
hard
Write a SQL query to find the top 3 selling products in each category, along with their percentage contribution to the category's total sales.
#Window Functions
#CTEs
#Math Operations
Data Engineer
•
Coding
•
hard
Write a SQL query to find consecutive days where daily sales exceeded $10,000 (Gaps and Islands problem).
#Advanced SQL
#Window Functions
#Gaps and Islands
Data Engineer
•
Coding
•
hard
Write a SQL query to calculate the cumulative sum of revenue by month, but reset the sum at the start of each financial year (April).
#Window Functions
#Cumulative Sum
#PARTITION BY
Data Engineer
•
Coding
•
medium
Write a Python program to find the longest common prefix string amongst an array of strings.
#Strings
#Arrays
#Loops
Data Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary per department without using the LIMIT keyword.
#Window Functions
#DENSE_RANK
#Subqueries
Data Engineer
•
Coding
•
medium
Write a Python script using Pandas to read a 10GB CSV file in chunks, filter rows based on a condition, and append to a Parquet file.
#Pandas
#Memory Management
#Parquet
Data Engineer
•
Coding
•
easy
Given a table of employee logins, write a query to find the first and last login time for each employee per day.
#Aggregation
#GROUP BY
#Date Functions
Data Engineer
•
Coding
•
medium
Write a Python function to flatten a deeply nested JSON dictionary representing API responses.
#Recursion
#Data Structures
#JSON Parsing
Data Engineer
•
System Design
•
hard
Design a data model and pipeline for a retail client to track inventory levels across 1000+ stores in near real-time.
#Data Modeling
#Real-time Processing
#Retail Domain
Data Engineer
•
System Design
•
medium
A client wants to migrate their legacy on-premise Hadoop cluster to AWS. Walk me through your migration strategy and the AWS services you would use.
#Cloud Migration
#AWS
#Hadoop
#EMR
#S3
Data Engineer
•
System Design
•
hard
Design a scalable data ingestion framework that can handle schema evolution (e.g., new columns added, data types changed) from upstream APIs without breaking downstream reporting.
Data Engineer
•
System Design
•
medium
How would you design a batch ingestion pipeline to load 500 GB of daily incremental data from an on-premise Oracle DB to Azure Data Lake?
#Azure
#Data Ingestion
#Incremental Load
#Self-Hosted Integration Runtime
Data Engineer
•
System Design
•
hard
Design a real-time fraud detection data pipeline for a banking client using the Azure or AWS stack.
#Streaming
#Kafka
#Event Hubs
#Databricks
#Architecture
Data Engineer
•
System Design
•
medium
Design an architecture to handle Slowly Changing Dimensions (SCD Type 2) for a customer dimension table containing 50 million records in a cloud data warehouse.
Data Engineer
•
System Design
•
hard
How would you design a data pipeline to migrate on-premise legacy SQL Server database tables to a cloud data warehouse, ensuring zero data loss and handling incremental loads?
Data Engineer
•
System Design
•
hard
Design a real-time streaming data pipeline to process e-commerce transaction logs, detect fraudulent activities, and update a live dashboard.
Data Engineer
•
System Design
•
medium
Design a batch processing architecture on Azure/AWS to ingest 500GB of daily log data from multiple sources, transform it, and load it into a centralized Data Lakehouse.
Data Engineer
•
Technical
•
medium
Write a SQL query to find the 3rd highest salary in each department using window functions. What happens if there are ties?
#Window Functions
#DENSE_RANK()
#CTEs
Data Engineer
•
Technical
•
medium
Explain the difference between narrow and wide transformations in PySpark. Give two examples of each and explain how they impact the DAG.
#Spark Architecture
#Transformations
#Shuffling
Data Engineer
•
Technical
•
hard
How do you handle data skewness while performing joins in PySpark? Explain the techniques you would use to optimize the job.
#Salting
#Broadcast Joins
#Spark Optimization
Data Engineer
•
Technical
•
medium
Write a Python script using Pandas or PySpark to read a large CSV file, drop rows where a specific column has null values, and write the output partitioned by date to a Parquet file.
#Data Cleaning
#File Formats
#Partitioning
Data Engineer
•
Technical
•
medium
Explain the difference between a Star Schema and a Snowflake Schema. In what scenario would you prefer Snowflake over Star?
#Dimensional Modeling
#Normalization
#Data Warehousing
Data Engineer
•
Technical
•
hard
How do you handle data skewness in PySpark when joining a massive transaction table with a customer table?
#PySpark
#Performance Tuning
#Salting
#Broadcast Joins
Data Engineer
•
Technical
•
medium
Explain the difference between Copy Activity and Mapping Data Flow in Azure Data Factory. When would you use each?
#Azure Data Factory
#ETL
#Data Integration
Data Engineer
•
Technical
•
medium
What is a Slowly Changing Dimension (SCD)? Explain the difference between SCD Type 1, Type 2, and Type 3.
#Data Warehousing
#SCD
#Dimensional Modeling
Data Engineer
•
Technical
•
medium
Explain the difference between repartition() and coalesce() in PySpark. When should you use which?
#PySpark
#Partitioning
#Optimization
Data Engineer
•
Technical
•
medium
How does Snowflake handle clustering, and when would you define a custom clustering key instead of relying on micro-partitions?
#Snowflake
#Performance Tuning
#Micro-partitions
Data Engineer
•
Technical
•
hard
Explain the Catalyst Optimizer in Spark. How does it generate the physical plan from a logical plan?
#Spark Internals
#Catalyst Optimizer
#Query Execution
Data Engineer
•
Technical
•
easy
What is the difference between a Star Schema and a Snowflake Schema? Which one do you prefer for a modern cloud data warehouse?
#Dimensional Modeling
#Star Schema
#Snowflake Schema
Data Engineer
•
Technical
•
hard
How do you ensure exactly-once processing semantics in a Kafka to Spark Streaming pipeline?
#Kafka
#Spark Streaming
#Exactly-Once Semantics
Data Engineer
•
Technical
•
medium
How do you pass data between tasks in Apache Airflow? Explain XComs and their limitations.
#Airflow
#XCom
#Task Dependencies
Data Engineer
•
Technical
•
medium
What is a Broadcast Join in Spark? What is the default threshold, and what happens if the broadcasted table exceeds driver memory?
#PySpark
#Joins
#Optimization
Data Engineer
•
Technical
•
easy
Explain the concept of lazy evaluation in Spark. Can you give an example of an action vs. a transformation?
#Spark Basics
#Lazy Evaluation
#Transformations vs Actions
Data Engineer
•
Technical
•
hard
Explain Time Travel and Fail-safe in Snowflake. How do they impact storage costs?
#Snowflake
#Architecture
#Cost Management
Data Engineer
•
Technical
•
medium
What is Delta Lake? Explain the ACID transaction capabilities it brings to Apache Spark.
#Databricks
#Delta Lake
#ACID Transactions
Data Engineer
•
Technical
•
medium
Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() with an example.
#Window Functions
#Ranking
Data Engineer
•
Technical
•
medium
What are accumulators in Spark? Provide a real-world use case for using them.
#Spark Internals
#Accumulators
#Shared Variables
Data Engineer
•
Technical
•
easy
How do you manage dependencies and virtual environments in a Python data engineering project?
#Python
#Environment Management
#CI/CD
Data Engineer
•
Technical
•
hard
How do you handle dynamic task generation in Airflow based on a configuration file or database table?
#Airflow
#Dynamic DAGs
#Python
Data Engineer
•
Technical
•
medium
In Azure Synapse Analytics, what is the difference between Dedicated SQL pools and Serverless SQL pools?
#Azure Synapse
#Data Warehousing
#Compute
Data Engineer
•
Technical
•
hard
How do you optimize a Spark job that is failing with an OutOfMemory (OOM) error during a groupByKey operation?
#PySpark
#OOM
#Optimization
#reduceByKey
Data Engineer
•
Technical
•
hard
Explain the Z-Ordering optimization in Delta Lake. When should you use it instead of partitioning?
#Databricks
#Delta Lake
#Z-Ordering
#Performance Tuning
Data Scientist
•
Behavioral
•
medium
Tell me about a time you had to work with a difficult client or team member to deliver a data science project on time.
#Conflict Resolution
#Teamwork
#Client Management
Data Scientist
•
Behavioral
•
medium
Tell me about a time you had to explain a complex machine learning model's predictions to a non-technical business stakeholder.
#Stakeholder Management
#Explainable AI
#Communication
Data Scientist
•
Behavioral
•
hard
Describe a situation where your model performed exceptionally well in training and testing but failed in production. How did you debug and fix it?
#Debugging
#Data Drift
#Production ML
Data Scientist
•
Behavioral
•
easy
Why do you want to join LTIMindtree, and how does your experience align with our focus on digital transformation for enterprise clients?
#Company Knowledge
#Motivation
#Consulting
Data Scientist
•
Coding
•
easy
Given a dictionary of employee names and their salaries, write a Python script to find the second highest salary efficiently.
#Python
#Data Structures
#Sorting
Data Scientist
•
Coding
•
medium
Calculate the cumulative sum of revenue partitioned by geographic region and ordered by transaction date.
#SQL
#Window Functions
#Aggregations
Data Scientist
•
Coding
•
hard
Identify duplicate records in a massive transaction table and write a query to delete them, keeping only the row with the lowest ID, without using a temporary table.
#SQL
#Data Cleaning
#CTEs
Data Scientist
•
Coding
•
medium
Given a string, write a Python program to find the length of the longest substring without repeating characters.
#Python
#Sliding Window
#Strings
Data Scientist
•
Coding
•
medium
Write a Pandas script to merge two datasets on a common key, but only keep rows where a specific column's value is above the 75th percentile of the merged dataset.
#Python
#Pandas
#Data Merging
#Statistical Filtering
Data Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 highest-grossing products per category. Assume a 'sales' table and a 'products' table.
#SQL
#Window Functions
#Joins
Data Scientist
•
Coding
•
medium
Implement a Python function from scratch to calculate the cosine similarity between two sparse vectors represented as dictionaries.
#Python
#Math
#Vectors
#Algorithms
Data Scientist
•
Coding
•
medium
Write a Python generator function to read a massive 50GB CSV file line by line, process it, and yield the result to prevent memory overflow.
#Python
#Generators
#Memory Management
#Big Data
Data Scientist
•
Coding
•
easy
Write a Python function using Pandas to calculate the 7-day rolling average of daily sales data for a retail client.
#Python
#Pandas
#Time Series
#Data Manipulation
Data Scientist
•
Coding
•
medium
Implement a custom cross-validation split function in Python for time-series data without using scikit-learn's TimeSeriesSplit.
#Python
#Time Series
#Cross Validation
#Algorithms
Data Scientist
•
Coding
•
medium
Write a SQL query to find all customers who purchased a product in three consecutive months.
#SQL
#Window Functions
#Date Functions
Data Scientist
•
System Design
•
hard
A retail client wants to forecast inventory demand for 10,000 SKUs for the next 4 weeks. Walk me through your end-to-end approach.
#Forecasting
#System Design
#Scalability
#ARIMA/Prophet/LGBM
Data Scientist
•
System Design
•
hard
We have a client in the BFSI sector looking to automate loan approvals using ML. How do you ensure the model is fair, unbiased, and compliant with regulations?
#Fairness
#Bias
#BFSI
#Regulatory Compliance
Data Scientist
•
System Design
•
medium
How do you monitor data drift and concept drift in a deployed machine learning model? What actions do you take if drift is detected?
#MLOps
#Model Monitoring
#Drift
Data Scientist
•
System Design
•
medium
Design a churn prediction system for a telecom client. What features would you engineer, and how would you frame the target variable?
#System Design
#Feature Engineering
#Classification
Data Scientist
•
System Design
•
medium
Walk me through how you would deploy a trained machine learning model as a REST API using FastAPI on Azure.
#Azure
#FastAPI
#Deployment
#Docker
Data Scientist
•
System Design
•
medium
Explain how you would build a hybrid recommendation engine for an e-commerce platform.
#Collaborative Filtering
#Content-Based Filtering
#System Design
Data Scientist
•
Technical
•
medium
Explain the difference between fine-tuning an LLM (like Llama 2) and using prompt engineering with few-shot learning. When would you choose which?
#LLMs
#Fine-tuning
#Prompt Engineering
Data Scientist
•
Technical
•
medium
What evaluation metrics would you use for a multi-class classification problem where the classes are highly imbalanced?
#Metrics
#Multi-class
#Imbalanced Data
Data Scientist
•
Technical
•
medium
How does XGBoost handle missing values internally without requiring explicit imputation beforehand?
#XGBoost
#Missing Data
#Tree Algorithms
Data Scientist
•
Technical
•
easy
What is the difference between Word2Vec and TF-IDF? In what scenarios would you choose one over the other?
#NLP
#Embeddings
#Text Processing
Data Scientist
•
Technical
•
medium
Explain the bias-variance tradeoff. How does this concept apply differently to Random Forests compared to Gradient Boosting Machines?
#Theory
#Ensemble Methods
#Model Evaluation
Data Scientist
•
Technical
•
medium
We are building a fraud detection model for a banking client where the fraud rate is 0.01%. How do you handle this highly imbalanced dataset?
#Imbalanced Data
#SMOTE
#Class Weights
#Evaluation Metrics
Data Scientist
•
Technical
•
hard
Explain the mathematical intuition behind Support Vector Machines (SVM) and the kernel trick. When would you use an RBF kernel over a linear kernel?
#SVM
#Mathematics
#Kernels
Data Scientist
•
Technical
•
hard
Explain the architecture of Transformers and the mathematical mechanism behind scaled dot-product self-attention.
#Deep Learning
#Transformers
#Attention Mechanism
Data Scientist
•
Technical
•
medium
How would you extract specific entities like invoice numbers, dates, and amounts from a large corpus of unstructured PDF documents?
#OCR
#NER
#Information Extraction
Data Scientist
•
Technical
•
hard
How do you implement a Retrieval-Augmented Generation (RAG) pipeline for a corporate knowledge base? Discuss vector databases and chunking strategies.
#RAG
#LLMs
#Vector Databases
#Embeddings
Data Scientist
•
Technical
•
medium
What are the core assumptions of Linear Regression? How do you detect and correct for heteroscedasticity?
#Linear Regression
#Statistics
#Assumptions
Data Scientist
•
Technical
•
easy
Explain the fundamental difference between bagging and boosting ensemble methods.
#Ensemble Methods
#Bagging
#Boosting
Data Scientist
•
Technical
•
medium
How do you choose the optimal number of clusters in a K-Means algorithm? Explain how the Silhouette score works.
#Clustering
#K-Means
#Evaluation Metrics
Data Scientist
•
Technical
•
medium
What is the difference between L1 (Lasso) and L2 (Ridge) regularization? How do they affect feature selection?
#Regularization
#Feature Selection
#Linear Models
DevOps Engineer
•
Behavioral
•
medium
Describe a situation where you had to push back on a development team's request because it violated DevOps best practices or security policies. How did you handle the conflict?
#Communication
#Conflict Resolution
#DevOps Culture
DevOps Engineer
•
Behavioral
•
medium
Tell me about a time you caused a production outage or a pipeline failure that impacted a client delivery. How did you handle it, and what was the post-mortem process?
#Incident Management
#Accountability
#Continuous Improvement
DevOps Engineer
•
Coding
•
easy
Write a Python script to parse a large NGINX access log file, extract all IP addresses that received a 500 HTTP status code, and count the occurrences of each IP.
#Python
#Log Parsing
#Data Structures
DevOps Engineer
•
Coding
•
medium
Write a Python script using the Boto3 library to list all unattached EBS volumes in an AWS account and send a summary report via AWS SNS.
#Python
#AWS
#Boto3
DevOps Engineer
•
Coding
•
hard
Write a Bash script to find and delete all application log files older than 30 days in '/var/log/app', but strictly keep the 5 most recent files regardless of their age.
#Bash
#Linux
#Log Management
DevOps Engineer
•
Coding
•
medium
Write an Ansible playbook to patch 100+ Linux servers for a manufacturing client, ensuring that no more than 10 servers are rebooted simultaneously to maintain high availability.
#Ansible
#Linux
#Automation
DevOps Engineer
•
System Design
•
hard
Design a Disaster Recovery (DR) strategy for a critical stateful application hosted on Azure. The client requires an RPO of 15 minutes and an RTO of 2 hours.
#Azure
#Disaster Recovery
#Architecture
DevOps Engineer
•
System Design
•
hard
Design a highly available, fault-tolerant, and scalable web application architecture on AWS for a major BFSI client. Include networking, compute, database, and caching layers.
#AWS
#Architecture
#High Availability
DevOps Engineer
•
System Design
•
hard
Design a CI/CD pipeline architecture for a legacy monolithic application that LTIMindtree is migrating to microservices. How do you handle the transition phase?
#CI/CD
#Microservices
#Migration
DevOps Engineer
•
Technical
•
easy
What is the difference between an IAM Role and an IAM Policy in AWS? Give a specific example of how you use them together to grant an EC2 instance access to S3.
#AWS
#IAM
#Security
DevOps Engineer
•
Technical
•
medium
LTIMindtree frequently uses shared libraries in Jenkins for enterprise clients. How do you create and structure a Jenkins shared library to standardize deployments across 50+ microservices?
#Jenkins
#Groovy
#Pipeline as Code
DevOps Engineer
•
Technical
•
easy
During a cloud migration project, you encounter a CrashLoopBackOff error in a Kubernetes pod running a Spring Boot application. Walk me through your exact troubleshooting steps.
#Kubernetes
#Troubleshooting
#Docker
DevOps Engineer
•
Technical
•
medium
For a multi-tenant AWS environment managed by LTIMindtree, how do you handle Terraform state file locking and concurrent modifications across a distributed team of DevOps engineers?
#Terraform
#AWS
#State Management
DevOps Engineer
•
Technical
•
medium
How do you optimize a Dockerfile for a Node.js microservice to minimize image size and reduce build time in a GitLab CI pipeline?
#Docker
#Optimization
#Node.js
DevOps Engineer
•
Technical
•
medium
How do you implement zero-downtime deployments in Kubernetes? Compare Rolling Updates with Blue-Green deployments and explain when you would recommend each to a client.
#Kubernetes
#Deployment Strategies
#CI/CD
DevOps Engineer
•
Technical
•
medium
Explain your Git branching strategy for a legacy enterprise project that requires maintaining multiple release versions (e.g., v1.0, v2.0) simultaneously while developing new features.
#Git
#Branching Strategies
#Release Management
DevOps Engineer
•
Technical
•
medium
You need to deploy infrastructure across multiple environments (dev, qa, prod) using Terraform. How do you structure your code to maximize reuse and adhere to DRY principles?
#Terraform
#Modules
#Workspaces
DevOps Engineer
•
Technical
•
medium
How would you set up monitoring and alerting for a Kubernetes-based microservices architecture using Prometheus and Grafana?
#Prometheus
#Grafana
#Kubernetes
DevOps Engineer
•
Technical
•
medium
LTIMindtree heavily emphasizes DevSecOps. How do you integrate security vulnerability scanning (e.g., SonarQube, Trivy) into a GitLab CI/CD pipeline, and how do you handle false positives?
#GitLab CI
#SonarQube
#Trivy
#Security
DevOps Engineer
•
Technical
•
easy
Explain the difference between a ClusterIP, NodePort, and LoadBalancer service in Kubernetes. When would you use an Ingress instead of a LoadBalancer?
#Kubernetes
#Networking
#Services
DevOps Engineer
•
Technical
•
medium
Explain how a VPC works in AWS. How do you secure communication between private subnets and the internet for downloading OS patches without exposing the instances?
#AWS
#Networking
#VPC
DevOps Engineer
•
Technical
•
easy
What are Ansible roles, and how do you use Ansible Galaxy to manage dependencies in a large-scale configuration management project?
#Ansible
#Roles
#Ansible Galaxy
DevOps Engineer
•
Technical
•
hard
How does Kubernetes handle secret management natively, and what are the limitations? How would you integrate HashiCorp Vault or AWS Secrets Manager into an EKS cluster?
#Kubernetes
#Secrets Management
#Vault
DevOps Engineer
•
Technical
•
easy
Explain the 'terraform apply -replace' command (formerly 'terraform taint') and describe a scenario where you would need to use it.
#Terraform
#State Management
DevOps Engineer
•
Technical
•
easy
What is the difference between CMD and ENTRYPOINT in a Dockerfile? How do they interact if both are specified?
#Docker
#Dockerfile
DevOps Engineer
•
Technical
•
hard
For a large retail client, how do you handle relational database schema migrations in an automated CI/CD pipeline without causing downtime?
#Database
#CI/CD
#Zero Downtime
DevOps Engineer
•
Technical
•
medium
Explain the role of an Ingress Controller in Kubernetes. How does it differ from the Ingress Resource, and which controller have you used most?
#Kubernetes
#Networking
#Ingress
DevOps Engineer
•
Technical
•
medium
Explain the ELK stack architecture. How do you ensure log data is not lost if Logstash experiences a sudden spike in traffic and goes down?
#ELK
#Logging
#Architecture
DevOps Engineer
•
Technical
•
medium
A client manually created several AWS resources via the console. How do you import these existing resources into a new Terraform state file?
#Terraform
#State Management
DevOps Engineer
•
Technical
•
medium
What are Horizontal Pod Autoscalers (HPA) and Vertical Pod Autoscalers (VPA) in Kubernetes? Can they be used together on the same deployment?
#Kubernetes
#Autoscaling
DevOps Engineer
•
Technical
•
medium
Explain the concept of GitOps. How does a tool like ArgoCD or Flux differ from traditional push-based CI/CD pipelines like Jenkins?
#GitOps
#ArgoCD
#Kubernetes
DevOps Engineer
•
Technical
•
medium
How do you troubleshoot a Linux server that is experiencing high CPU load but has plenty of free memory? Which tools and metrics do you look at?
#Linux
#Troubleshooting
#Performance
DevOps Engineer
•
Technical
•
easy
Explain the difference between the 'copy' and 'template' modules in Ansible. When would you use one over the other?
#Ansible
#Modules
DevOps Engineer
•
Technical
•
medium
LTIMindtree provides FinOps services to clients. How do you optimize AWS cloud costs for a client with highly unpredictable workloads?
#AWS
#FinOps
#Cost Optimization
DevOps Engineer
•
Technical
•
easy
In Jenkins, how do you trigger a downstream job only if the upstream job is successful, and how do you pass parameters from the upstream to the downstream job?
#Jenkins
#Pipelines
Frontend Engineer
•
Behavioral
•
medium
How do you handle disagreements with a backend developer regarding API contract designs or payload structures?
#Collaboration
#Conflict Resolution
#API Design
Frontend Engineer
•
Behavioral
•
medium
Tell me about a time you had to push back on a client requirement because it would negatively impact the frontend performance or user experience.
#Client Communication
#Pushback
#User Experience
Frontend Engineer
•
Behavioral
•
medium
Describe a situation where you had to deliver a critical UI feature with a very tight deadline for an enterprise client. How did you ensure quality?
#Agile
#Time Management
#Quality Assurance
Frontend Engineer
•
Coding
•
easy
Write a function to check if two strings are anagrams of each other.
#Strings
#Hash Map
Frontend Engineer
•
Coding
•
hard
Implement an infinite scroll component in React. How do you detect when the user has reached the bottom of the list?
#Intersection Observer
#DOM Manipulation
#Custom Hooks
Frontend Engineer
•
Coding
•
medium
Implement a polyfill for `Promise.all()`. How does your implementation handle a mix of resolved promises, rejected promises, and non-promise values?
#Promises
#Asynchronous JavaScript
#Polyfills
Frontend Engineer
•
Coding
•
medium
Write a function to flatten a deeply nested JavaScript object into a single-level object with dot-separated keys.
#Recursion
#Object Manipulation
#Data Structures
Frontend Engineer
•
Coding
•
medium
Implement a function to deep clone a JavaScript object without using `JSON.parse(JSON.stringify())`. Handle Dates and Arrays.
#Recursion
#Memory Management
#Object Manipulation
Frontend Engineer
•
Coding
•
medium
Create a polyfill for `Array.prototype.reduce`.
#Polyfills
#Arrays
#Functional Programming
Frontend Engineer
•
Coding
•
medium
Write a JavaScript function to find the length of the longest substring without repeating characters.
#Sliding Window
#Strings
#Hash Map
Frontend Engineer
•
Coding
•
medium
Write a function to curry an existing function `add(a, b, c)` so it can be called as `add(a)(b)(c)` or `add(a, b)(c)`.
#Currying
#Closures
#Functional Programming
Frontend Engineer
•
Coding
•
medium
Write a custom React hook `useDebounce` that takes a value and a delay, and returns a debounced value. How would you use this for a search input hitting an enterprise API?
#Custom Hooks
#Debouncing
#Performance Optimization
Frontend Engineer
•
System Design
•
hard
Design an autocomplete search bar component for a large e-commerce client. How do you handle race conditions, caching, and performance?
#Component Design
#Caching
#Race Conditions
#Debouncing
Frontend Engineer
•
System Design
•
medium
Design a scalable image carousel component. What accessibility (a11y) and performance considerations would you include?
#Component Design
#Accessibility
#Performance
Frontend Engineer
•
System Design
•
hard
How would you architect a Micro-frontend application for a large banking client? What are the pros and cons?
#Micro-frontends
#Architecture
#Module Federation
Frontend Engineer
•
Technical
•
hard
How do you identify and handle memory leaks in a Single Page Application (SPA)?
#Memory Management
#Performance
#DevTools
Frontend Engineer
•
Technical
•
hard
What is the purpose of RxJS in Angular? Explain the difference between `mergeMap`, `switchMap`, and `concatMap`.
#RxJS
#Operators
#Asynchronous Data
Frontend Engineer
•
Technical
•
medium
How does Webpack work? Explain the difference between loaders and plugins.
#Webpack
#Bundling
#Tooling
Frontend Engineer
•
Technical
•
easy
Explain Event Delegation in JavaScript. Why is it useful and how does it relate to Event Bubbling?
#DOM Events
#Event Bubbling
#Performance
Frontend Engineer
•
Technical
•
medium
In Angular, what is the difference between an Observable and a Promise? Why does Angular heavily rely on RxJS?
#RxJS
#Observables
#Promises
Frontend Engineer
•
Technical
•
medium
Explain the Event Loop in JavaScript. Specifically, how does the engine prioritize between Microtasks (like Promises) and Macrotasks (like setTimeout)?
#Event Loop
#Concurrency
#Browser Architecture
Frontend Engineer
•
Technical
•
medium
How does React's Virtual DOM work under the hood, and what is the reconciliation process (Fiber architecture)?
#Virtual DOM
#Reconciliation
#React Fiber
Frontend Engineer
•
Technical
•
easy
Explain closures in JavaScript. Can you provide a practical use case where you used a closure in a recent client project?
#Closures
#Scope
#Lexical Environment
Frontend Engineer
•
Technical
•
medium
What is the difference between `useMemo` and `useCallback`? When would you use one over the other, and when is it a bad idea to use them?
#Hooks
#Performance Optimization
#Memoization
Frontend Engineer
•
Technical
•
easy
Explain the concept of Hoisting in JavaScript. How do `let` and `const` differ from `var` in this context?
#Hoisting
#Scope
#ES6
Frontend Engineer
•
Technical
•
medium
How do you manage global state in a large-scale React application? Compare Redux (or Redux Toolkit) with the Context API.
#State Management
#Redux
#Context API
Frontend Engineer
•
Technical
•
easy
Explain CSS Grid vs Flexbox. When would you choose Grid over Flexbox for an enterprise dashboard layout?
#CSS Grid
#Flexbox
#Layout
Frontend Engineer
•
Technical
•
hard
What are Web Core Vitals? How do you optimize Largest Contentful Paint (LCP) and Cumulative Layout Shift (CLS) in a React application?
#Core Web Vitals
#LCP
#CLS
#Performance Optimization
Frontend Engineer
•
Technical
•
medium
Explain Cross-Origin Resource Sharing (CORS). How do you resolve CORS errors when developing locally against a client's dev environment?
#CORS
#Security
#Network
Frontend Engineer
•
Technical
•
medium
What is Server-Side Rendering (SSR) vs Client-Side Rendering (CSR)? What are the SEO and performance benefits of using a framework like Next.js?
#SSR
#CSR
#Next.js
#SEO
Frontend Engineer
•
Technical
•
medium
How does Dependency Injection work in Angular? Explain the difference between `providedIn: 'root'` and providing a service at the component level.
#Dependency Injection
#Services
#Architecture
Frontend Engineer
•
Technical
•
easy
Explain the concept of Semantic HTML. Why is it important for Web Accessibility (a11y) and how do screen readers interpret it?
#Semantic HTML
#Accessibility
#a11y
Frontend Engineer
•
Technical
•
medium
What are Higher-Order Components (HOCs) in React? Can you give an example of when to use them versus Custom Hooks?
#HOC
#Design Patterns
#React
Frontend Engineer
•
Technical
•
easy
Explain the CSS Box Model. What is the difference between `box-sizing: border-box` and `content-box`?
#Box Model
#CSS Fundamentals
Frontend Engineer
•
Technical
•
medium
How do you implement authentication and route protection in a React application? Explain the flow involving JWTs.
#Authentication
#React Router
#Security
#JWT
Full Stack Engineer
•
Behavioral
•
medium
Tell me about a time you had a disagreement with a client or a product owner regarding a technical requirement. How did you resolve it?
#Communication
#Conflict Resolution
#Client Management
Full Stack Engineer
•
Behavioral
•
medium
Tell me about a time you found a critical bug in production. How did you handle the situation and what was the outcome?
#Problem Solving
#Incident Management
#Accountability
Full Stack Engineer
•
Behavioral
•
easy
Describe your experience working in an Agile/Scrum environment. Which ceremony do you find most valuable and why?
#Agile
#Scrum
#Teamwork
Full Stack Engineer
•
Behavioral
•
medium
Describe a situation where you had to deliver a critical project under a very tight deadline. How did you prioritize your tasks?
#Time Management
#Prioritization
#Stress Management
Full Stack Engineer
•
Behavioral
•
easy
Tell me about a time you had to learn a new technology or framework quickly to complete a project.
#Adaptability
#Continuous Learning
#Self-Motivation
Full Stack Engineer
•
Coding
•
medium
Implement a function to perform a deep clone of a JavaScript object, handling nested objects and arrays.
#JavaScript
#Recursion
#Data Structures
Full Stack Engineer
•
Coding
•
easy
Write a SQL query to find all employees who earn more than their managers.
#Databases
#SQL Joins
Full Stack Engineer
•
Coding
•
easy
Given a string containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid.
#Strings
#Stack
Full Stack Engineer
•
Coding
•
medium
Write a function to flatten a deeply nested array in JavaScript without using the built-in `Array.prototype.flat()`.
#JavaScript
#Recursion
#Arrays
Full Stack Engineer
•
Coding
•
easy
Find the first non-repeating character in a given string. Return its index. If it doesn't exist, return -1.
#Strings
#Hash Map
Full Stack Engineer
•
Coding
•
medium
Implement a custom React hook `useFetch` that takes a URL, fetches data, and returns the data, loading state, and error state.
#React
#Custom Hooks
#Asynchronous JavaScript
Full Stack Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary from an Employee table without using the LIMIT keyword.
#Databases
#SQL Queries
Full Stack Engineer
•
Coding
•
easy
Given an array of integers and a target sum, return the indices of the two numbers that add up to the target. Can you do this in O(n) time complexity?
#Arrays
#Hash Map
Full Stack Engineer
•
Coding
•
hard
Write a program to merge two sorted arrays into a single sorted array without using extra space (O(1) auxiliary space).
#Arrays
#Two Pointers
#Sorting
Full Stack Engineer
•
Coding
•
medium
Given an array of strings, group the anagrams together. You can return the answer in any order.
#Strings
#Hash Map
#Sorting
Full Stack Engineer
•
System Design
•
medium
Design a scalable URL shortener service like TinyURL. How would you handle high read/write volumes and collisions?
#Scalability
#Hashing
#Database Design
Full Stack Engineer
•
System Design
•
hard
Design a centralized logging and monitoring system for a distributed microservices architecture.
#Microservices
#Logging
#Monitoring
#ELK Stack
Full Stack Engineer
•
System Design
•
medium
Design an E-commerce shopping cart system. What database would you use to store the cart items and why?
#Database Design
#Session Management
#E-commerce
Full Stack Engineer
•
System Design
•
hard
Design a Notification System that can send Emails, SMS, and Push Notifications to millions of users.
#Message Queues
#Asynchronous Processing
#Scalability
Full Stack Engineer
•
System Design
•
medium
Design a REST API for a Library Management System. What endpoints would you create for borrowing and returning books?
#REST API
#API Design
#HTTP Methods
Full Stack Engineer
•
Technical
•
medium
What are ACID properties in a database? Explain Isolation levels and how they prevent dirty reads.
#Databases
#Transactions
#ACID
Full Stack Engineer
•
Technical
•
medium
How do you secure a REST API in a Spring Boot application? Explain the flow of JWT authentication.
#Spring Security
#JWT
#Authentication
#Authorization
Full Stack Engineer
•
Technical
•
medium
What is the Event Loop in Node.js? How does it handle asynchronous operations despite being single-threaded?
#Node.js
#Event Loop
#Asynchronous Programming
Full Stack Engineer
•
Technical
•
easy
What are the differences between `@Component`, `@Service`, `@Repository`, and `@Controller` in Spring?
#Java
#Spring Framework
#Annotations
Full Stack Engineer
•
Technical
•
medium
How do you manage global state in a large-scale React application? Compare Redux with the Context API.
#React
#Redux
#Context API
#State Management
Full Stack Engineer
•
Technical
•
medium
Explain the concept of Promises in JavaScript. What is the difference between `Promise.all()` and `Promise.allSettled()`?
#JavaScript
#Promises
#Asynchronous Programming
Full Stack Engineer
•
Technical
•
hard
How does Garbage Collection work in Java? What are the different types of Garbage Collectors?
#Java
#JVM
#Memory Management
Full Stack Engineer
•
Technical
•
medium
Explain Dependency Injection and Inversion of Control. How does the Spring container manage bean lifecycles?
#Java
#Spring Framework
#Design Patterns
Full Stack Engineer
•
Technical
•
hard
What are React Server Components? How do they differ from traditional Client Components?
#React
#Next.js
#Performance
Full Stack Engineer
•
Technical
•
medium
What is CORS (Cross-Origin Resource Sharing)? How do you configure it in a Node.js/Express or Spring Boot backend?
#Security
#HTTP
#Backend Configuration
Full Stack Engineer
•
Technical
•
medium
How do you implement CI/CD for a Full Stack application? Describe the pipeline stages.
#CI/CD
#Jenkins
#Git
#Deployment
Full Stack Engineer
•
Technical
•
medium
Explain the internal working of React's Virtual DOM and the reconciliation process.
#React
#JavaScript
#Virtual DOM
Full Stack Engineer
•
Technical
•
medium
How does Spring Boot's auto-configuration work under the hood? Which annotations are responsible for it?
#Java
#Spring Boot
#Annotations
Full Stack Engineer
•
Technical
•
hard
What is the N+1 select problem in Hibernate/JPA? How do you resolve it in a Spring Boot application?
#Java
#Hibernate
#JPA
#Performance Optimization
Full Stack Engineer
•
Technical
•
easy
Explain the difference between Monolithic and Microservices architectures. When would you choose one over the other?
#Microservices
#Monolith
#Software Architecture
Machine Learning Engineer
•
Behavioral
•
hard
Tell me about a time an ML model you deployed failed or performed poorly in production. What was the root cause and how did you fix it?
#Production Issues
#Debugging
#Accountability
Machine Learning Engineer
•
Behavioral
•
medium
What is your approach to ensuring your machine learning models are ethical and unbiased, especially when dealing with sensitive client data?
#AI Ethics
#Bias
#Data Privacy
Machine Learning Engineer
•
Behavioral
•
medium
Describe a situation where a client had unrealistic expectations about the accuracy or capabilities of an ML model. How did you manage it?
#Client Management
#Expectation Setting
Machine Learning Engineer
•
Behavioral
•
easy
At LTIMindtree, you often work with geographically distributed teams. Tell me about a challenge you faced working across time zones and how you overcame it.
#Teamwork
#Remote Work
#Communication
Machine Learning Engineer
•
Behavioral
•
medium
Describe a time when the requirements for an ML project changed midway through the sprint. How did you adapt?
#Adaptability
#Agile
Machine Learning Engineer
•
Behavioral
•
medium
Tell me about a time you had a disagreement with a Data Engineer or DevOps engineer regarding model deployment or data pipelines. How was it resolved?
#Conflict Resolution
#Cross-functional Collaboration
Machine Learning Engineer
•
Behavioral
•
medium
Tell me about a time you had to explain a complex machine learning concept to a non-technical client or stakeholder.
#Stakeholder Management
#Communication
Machine Learning Engineer
•
Behavioral
•
easy
You are assigned to a new client project that uses a cloud provider (e.g., GCP) you have no prior experience with. How do you ramp up quickly?
#Adaptability
#Continuous Learning
Machine Learning Engineer
•
Behavioral
•
medium
How do you prioritize your tasks when you have multiple urgent deliverables for different stakeholders at the same time?
#Time Management
#Prioritization
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query using window functions to find the top 3 highest-spending customers in each region from a 'transactions' table.
#SQL
#Window Functions
#Data Aggregation
Machine Learning Engineer
•
Coding
•
medium
Given a string, find the length of the longest substring without repeating characters. Optimize your solution for O(N) time complexity.
#Strings
#Sliding Window
#Hash Map
Machine Learning Engineer
•
Coding
•
medium
Write a Python function using Pandas to merge two large datasets on a common key, handle missing values by imputing the median for numerical columns, and create a new aggregated feature.
#Python
#Pandas
#Data Preprocessing
Machine Learning Engineer
•
Coding
•
easy
Implement a binary search algorithm to find the optimal threshold for a classification model given a sorted array of predicted probabilities.
#Binary Search
#Arrays
Machine Learning Engineer
•
Coding
•
medium
Write a Python script to calculate the cosine similarity between two text documents from scratch, without using scikit-learn.
#NLP
#Math
#Python
Machine Learning Engineer
•
System Design
•
medium
Design a document extraction pipeline to process scanned invoices, extract key-value pairs, and export them to a relational database.
#Computer Vision
#OCR
#NLP
Machine Learning Engineer
•
System Design
•
hard
Design a recommendation system for a large e-commerce client. How would you handle the cold start problem for new users and new items?
#Recommendation Systems
#Cold Start
#Collaborative Filtering
Machine Learning Engineer
•
System Design
•
hard
Design a real-time credit card fraud detection system. The system must process thousands of transactions per second with sub-50ms latency.
#Real-time Processing
#Fraud Detection
#Streaming
Machine Learning Engineer
•
System Design
•
hard
Design a scalable architecture to serve an open-source LLM (like Llama-3) to internal enterprise users securely.
#LLMs
#Cloud Architecture
#Security
Machine Learning Engineer
•
System Design
•
medium
Design an automated ticket classification system for an IT helpdesk. How do you handle multi-label classification and continuous learning?
#NLP
#Classification
#Continuous Learning
Machine Learning Engineer
•
System Design
•
hard
Design a demand forecasting system for a retail chain with 1,000 stores and 50,000 SKUs. How do you model this at scale?
#Time Series
#Forecasting
#Distributed Computing
Machine Learning Engineer
•
Technical
•
medium
Explain how you would use Docker to containerize a Machine Learning model built with FastAPI. What does your Dockerfile look like?
#Docker
#FastAPI
#Deployment
Machine Learning Engineer
•
Technical
•
medium
How do Explainable AI (XAI) frameworks like SHAP or LIME work? Why is explainability important for our enterprise clients?
#Explainable AI
#SHAP
#LIME
Machine Learning Engineer
•
Technical
•
medium
Explain the mathematical difference between Random Forest and Gradient Boosting. Why might XGBoost overfit more easily than Random Forest?
#Ensemble Methods
#Decision Trees
#Overfitting
Machine Learning Engineer
•
Technical
•
medium
Describe the difference between Batch Inference and Real-Time Inference. What architecture changes are required to move from batch to real-time?
#Inference
#Architecture
#MLOps
Machine Learning Engineer
•
Technical
•
easy
What is the difference between L1 (Lasso) and L2 (Ridge) regularization? In what scenario would you strictly prefer L1?
#Regularization
#Linear Models
#Feature Selection
Machine Learning Engineer
•
Technical
•
medium
How do you handle highly imbalanced datasets in a classification problem? Explain the pros and cons of SMOTE versus class weighting.
#Data Preprocessing
#Imbalanced Data
#Classification
Machine Learning Engineer
•
Technical
•
hard
Explain the architecture of a Transformer model. How does the Self-Attention mechanism work mathematically?
#NLP
#Transformers
#Attention Mechanism
Machine Learning Engineer
•
Technical
•
hard
We are building a GenAI application using a Retrieval-Augmented Generation (RAG) pipeline. How would you handle chunking strategies and evaluate the retrieval performance?
#RAG
#LLMs
#Vector Databases
Machine Learning Engineer
•
Technical
•
hard
What is PEFT (Parameter-Efficient Fine-Tuning) and how does LoRA (Low-Rank Adaptation) work when fine-tuning Large Language Models?
#LLMs
#Fine-Tuning
#LoRA
Machine Learning Engineer
•
Technical
•
easy
How do you choose the optimal number of clusters in K-Means clustering? Explain the Elbow method and Silhouette score.
#Unsupervised Learning
#Clustering
Machine Learning Engineer
•
Technical
•
medium
Explain the vanishing gradient problem in Recurrent Neural Networks (RNNs). How do LSTMs solve this issue?
#RNN
#LSTM
#Optimization
Machine Learning Engineer
•
Technical
•
easy
When evaluating a binary classifier for a rare disease detection system, would you prioritize Precision or Recall? Why? What metric combines both?
#Evaluation Metrics
#Classification
Machine Learning Engineer
•
Technical
•
medium
In a recent client project, we noticed our model's performance degrading over time. Explain the difference between Concept Drift and Data Drift, and how you would detect them.
#Model Monitoring
#Data Drift
#Production ML
Machine Learning Engineer
•
Technical
•
medium
How does Principal Component Analysis (PCA) differ from t-SNE? When would you use one over the other?
#Dimensionality Reduction
#PCA
#t-SNE
Machine Learning Engineer
•
Technical
•
medium
What is MLflow used for in an ML pipeline? Describe how you would track experiments and register a model.
#MLflow
#Experiment Tracking
#Model Registry
Product Manager
•
Behavioral
•
hard
How do you manage a backlog when receiving conflicting priorities from the client's business team and their IT team?
#Conflict Resolution
#Backlog Management
#Consulting
Product Manager
•
Behavioral
•
medium
How do you handle scope creep requested by a high-value enterprise client mid-sprint?
#Scope Management
#Agile
#Client Relations
Product Manager
•
Behavioral
•
medium
Describe a situation where a product or feature launch failed. What did you learn?
#Failure Analysis
#Continuous Improvement
#Accountability
Product Manager
•
Behavioral
•
medium
How do you align a cross-functional team of designers, engineers, and QA who are disagreeing on a feature implementation?
#Cross-functional Leadership
#Conflict Resolution
#Team Dynamics
Product Manager
•
Behavioral
•
medium
Tell me about a time you had to say 'no' to a senior stakeholder or a high-value client.
#Pushback
#Stakeholder Management
#Prioritization
Product Manager
•
Behavioral
•
medium
How would you prioritize features for an internal HR portal used by 80,000+ LTIMindtree employees globally?
#Prioritization
#Internal Products
#Stakeholder Management
Product Manager
•
Behavioral
•
medium
What is your approach to conducting backlog grooming and sprint planning with a distributed offshore/onshore team?
#Distributed Teams
#Agile Ceremonies
#Communication
Product Manager
•
Behavioral
•
medium
We are building a new SaaS tool for cloud cost optimization for our enterprise clients. Who are your target personas and what are their pain points?
#B2B SaaS
#Cloud Computing
#User Personas
Product Manager
•
Behavioral
•
medium
You launched a new self-service feature for an e-commerce client, but adoption is stuck at 2%. How do you investigate and resolve this?
#Data Analysis
#Root Cause Analysis
#User Feedback
Product Manager
•
Behavioral
•
medium
Walk me through a time you had to pivot your product roadmap mid-development due to a shift in client strategy.
#Adaptability
#Roadmapping
#Change Management
Product Manager
•
Behavioral
•
medium
Tell me about a time you used data to influence a critical product decision against popular opinion.
#Data Analysis
#Influence without Authority
#Decision Making
Product Manager
•
Behavioral
•
hard
The engineering team estimates a critical feature will take 3 sprints, but the client insists they need it in 1 sprint. How do you handle this?
#Negotiation
#Agile
#Client Management
Product Manager
•
Behavioral
•
medium
Tell me about a time you had to quickly learn a new industry domain to manage a product effectively.
#Domain Knowledge
#Learning Agility
#Consulting
Product Manager
•
Behavioral
•
easy
How do you keep yourself updated with the latest technology trends (e.g., Web3, GenAI) and apply them to client pitches?
#Continuous Learning
#Innovation
#Consulting
Product Manager
•
Behavioral
•
medium
How do you measure the success of a digital transformation project for a legacy insurance client?
#Digital Transformation
#Success Metrics
#Insurance
Product Manager
•
Behavioral
•
hard
You are assigned to a client project that is already delayed and over budget. What do your first 30 days look like?
#Crisis Management
#Onboarding
#Project Turnaround
Product Manager
•
Behavioral
•
hard
How do you price a new proprietary API service developed by LTIMindtree for external developers?
#Pricing Strategy
#Monetization
#APIs
Product Manager
•
Coding
•
medium
Given a table of user sessions (user_id, login_time, logout_time), write a SQL query to find the average session duration per user.
#Date Functions
#Aggregation
Product Manager
•
Coding
•
hard
Write a SQL query to identify users who have logged in every day for the past consecutive 7 days.
#Advanced SQL
#Gaps and Islands
#User Activity
Product Manager
•
Coding
•
easy
Write a SQL query to find the top 3 most used features in our product over the last 30 days based on an event_logs table.
#Data Extraction
#Aggregation
Product Manager
•
Coding
•
hard
Write a SQL query to calculate the month-over-month retention rate of users on a platform.
#Cohort Analysis
#Advanced SQL
#Retention
Product Manager
•
System Design
•
medium
How do you design a secure authentication and authorization flow for a B2B financial application?
#Authentication
#RBAC
#FinTech
Product Manager
•
System Design
•
hard
Design a data pipeline product that ingests millions of IoT sensor events daily for a smart factory.
#Data Engineering
#IoT
#Scalability
Product Manager
•
System Design
•
medium
Design a dashboard for a retail banking client to track digital onboarding drop-offs.
#UX/UI
#Metrics
#Banking Domain
Product Manager
•
System Design
•
hard
Design a high-level system architecture for a scalable push notification service for a logistics client tracking real-time deliveries.
#Microservices
#Real-time Systems
#Logistics
Product Manager
•
System Design
•
medium
Design an automated workflow system for processing insurance claims.
#Workflow Automation
#Insurance
#System Architecture
Product Manager
•
Technical
•
medium
What metrics would you use to evaluate the performance of a machine learning recommendation engine for a retail client?
#Machine Learning
#E-commerce
#KPIs
Product Manager
•
Technical
•
medium
Explain your process for writing user stories and acceptance criteria for a complex legacy data migration project.
#Requirements Gathering
#Data Migration
#Agile Delivery
Product Manager
•
Technical
•
hard
LTIMindtree is pitching a Generative AI chatbot for a telecom client's customer support. What are the key product risks you must address?
#Generative AI
#Risk Management
#Telecom
Product Manager
•
Technical
•
medium
What KPIs would you define for a newly launched API gateway used by our enterprise clients?
#APIs
#Performance Metrics
#B2B
Product Manager
•
Technical
•
medium
How do you decide whether to build a custom solution from scratch for a client or integrate an existing third-party SaaS product?
#Build vs Buy
#Vendor Management
#ROI Analysis
Product Manager
•
Technical
•
medium
How do you ensure technical debt is addressed while still delivering new business value to the client?
#Technical Debt
#Resource Allocation
#Engineering Collaboration
Product Manager
•
Technical
•
hard
A major manufacturing client wants to build a predictive maintenance product using IoT data. How do you define the MVP?
#IoT
#MVP Definition
#Manufacturing
Product Manager
•
Technical
•
easy
Explain how REST APIs work to a non-technical business stakeholder who is funding the project.
#APIs
#Stakeholder Communication
#Technical Translation
Product Manager
•
Technical
•
hard
A client wants to migrate their on-premise CRM to AWS. As a PM, what are your product considerations and risks?
#Cloud Migration
#Risk Management
#AWS
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.