Prepare for and practice interview questions from Tech Mahindra.

Tech Mahindra Interview Questions

Tech Mahindra Interview Guides

Data Structures & Algorithms

Given two sorted lists, write a function to merge them into one sorted list.

Merge Sorted Lists

Find the missing integer from a array of consequtive integers

Find the Missing Number

Write a function n_frequent_words that returns the top N frequent words and their frequencies, and state its run-time

Get Top N Frequent Words

Write a function to return the names and resume IDs for resumes whose IDs have not already been scraped

New Resumes

Given an integer N, write a function that returns all of the prime numbers up to N

Prime to N

Machine Learning

How would you encode a categorical variable with thousands of distinct values

Encoding Categorical Features

Which model would perform better and why?

Booking Regression

How do we deal with the missing square footage data to construct our model

Missing Housing Data

How would we build a model to detect fraud and text customers to approve or deny fraudulent transactions

Bank Fraud Model

Rebalancing outcome probabilities for a classifier on imbalanced data.

Rebalance Probabilities

Select the 2nd highest salary in the engineering department

2nd Highest Salary

Write a query to return the two students with the closest test scores and the score difference

Closest SAT Scores

Write a query to get the total three-day rolling average for deposits by day

Rolling Bank Transactions

Longest Streak Users

Paired Products

Probability

First to Six

What is the probability that each subsequent card is larger than the previous drawn card when picking three cards from a shuffled deck of 500 cards

500 Cards

What is the probability that it's actually raining in Seattle?

Raining in Seattle

What is the probability that item X would be found on Amazon's website?

Found Item

Given three uniform(0,4) random variables, what is the probability that the median of them is greater than 3?

Median Probability

Data Pipelines

Design a data pipeline to compute hourly, daily, and weekly active user metrics from a data lake for an hourly-refreshing dashboard

Data Pipelines and Aggregation

How would you build an ETL pipeline to ingest Stripe payment data into a warehouse for revenue dashboards and analytics

Payment Data Pipeline

How would you clean a 100GB .csv file without loading it into memory

Processing Large CSV

Redesign batch credit card processing to enable real-time streaming for fraud detection and reporting.

Real-Time Transaction Streaming

Design a data pipeline that supports resumable loading for a fact table after partial failure.

Resumable Fact Table Load

Given an integer <code>N</code>, write a function that returns a list of all of the prime numbers up to <code>N</code>.

Note: Return an empty list there are no prime numbers less than or equal to <code>N</code>.

Example:

Input:

<pre tabindex="0" class="chroma"><code>N = 3
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def prime_numbers(N) -&gt; [2,3]
</code></pre>

Say you are tasked with designing a data mart or data warehouse for a new online retailer.

How would you design the system?

Note: Sketch a star schema to explain your design.

Design a data warehouse for a new online retailer

Retailer Data Warehouse

Data Modeling

We’re given two tables. One is named <code>projects</code> and the other maps employees to the projects they’re working on.

Write a query to get the top five most expensive projects by budget to employee count ratio.

Note: Exclude projects with 0 employees. Assume each employee works on only one project.

<code>projects</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>state_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>end_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>budget</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>employee_projects</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>project_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>employee_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>budget_per_employee</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Write a query to get the top five projects by budget-to-employee-count ratio

Employee Project Budgets

Given a string, find the first non-repeating character in it and return its index. If it doesn’t exist, return -1.

Example questions:

Consider a string where all characters are lowercase alphabets.

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>s = &#39;helloworld&#39;
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>first_uniq_char(s) -&gt; 0
</code></pre>

In the string ‘helloworld’, the first non-repeating character is ‘h’, which is at index 0.

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>s = &#39;concussion&#39;
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>first_uniq_char(s) -&gt; 4
</code></pre>

In the string ‘concussion’, the first non-repeating character is ‘u’, which is at index 4.

This problem involves finding the first non-repeating character in a given string. The solution involves iterating over the string and keeping track of the frequency of each character. The first character that has a frequency of 1 is the first non-repeating character.

Find the First Non-Repeating Character in a String

You work as a data engineer at a global financial services company. The current pipeline ingests millions of daily credit card transactions via nightly batch jobs. The business now requires real-time processing and analysis for each transaction to support instant fraud detection and real-time reporting.

How would you redesign the ingestion and processing architecture to enable reliable, scalable, and consistent real-time streaming of transaction data?

Draft a design proposal outlining your approach.

Write a Python function called <code>group_anagrams</code> that takes a list of strings as input and returns a list of lists, where each inner list contains a group of anagrams that were present in the input list.

An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, using all the original letters exactly once.

Note: Each of the inner lists should be ordered alphabetically and contain no duplicate values

<h3>Example:</h3>

Input:

<pre tabindex="0" class="chroma"><code>words = [&#34;eat&#34;, &#34;tea&#34;, &#34;tan&#34;, &#34;ate&#34;, &#34;nat&#34;, &#34;bat&#34;]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>[ 
 [&#34;nat&#34;,&#34;tan&#34;],
 [&#34;ate&#34;,&#34;eat&#34;, &#34;tea&#34;],
 [&#34;bat&#34;]
]
</code></pre>

Explanation:

In the example, the words “eat”, “tea”, and “ate” are anagrams of each other, as are the words “tan” and “nat”. The word “bat” does not have any anagrams in the input list, and therefore is listed on its own. The function then groups the anagrams together and returns a list of lists representing these groups.

Each of the lists representing a group of anagrams is sorted in alphabetical order.

Identify the groups of anagrams in a list of words

Groups of Anagrams

You work as a data engineer at Skyscanner. Your team is responsible for ingesting, transforming, and loading flight and hotel availability data from dozens of external partner APIs into Skyscanner’s real-time search platform. The system must ensure high data freshness, fault tolerance, and scalability as new partners are onboarded.

How would you architect the ETL pipeline to support these requirements? Design a system flow explaining this architecture.

Design a scalable ETL pipeline for ingesting heterogeneous data from Skyscanner's partners.

Skyscanner Partner ETL

Tell me about a data project that didn’t go the way you expected. What did you set out to do, what surprised you, and how did you handle it?

Describing a data project and its challenges

Hurdles In Data Projects

Behavioral

Implement Dijkstra’s shortest path algorithm for a given graph with a known source node.

A graph format is a dictionary of nodes as key and the value is a dictionary of neighbors to that node with the distance between them as follow.

Note: set the previous node of the source node to <code>None</code>.

Example:

Input:

<pre tabindex="0" class="chroma"><code>
source_node = &#39;A&#39;

graph = {
 &#39;A&#39;: {
 &#39;D&#39;: 1,
 &#39;B&#39;: 6
 },
 &#39;B&#39;: {
 &#39;A&#39;: 6,
 &#39;D&#39;: 2,
 &#39;E&#39;: 2,
 &#39;C&#39;: 5
 },
 &#39;C&#39;: {
 &#39;B&#39;: 5,
 &#39;E&#39;: 5
 },
 &#39;D&#39;: {
 &#39;A&#39;: 1,
 &#39;B&#39;: 2,
 &#39;E&#39;: 1
 },
 &#39;E&#39;: {
 &#39;C&#39;: 5,
 &#39;B&#39;: 2
 }

 }


</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>
output_table = {
 &#39;A&#39;: {
 &#39;ShortestDistance&#39;: 0,
 &#39;PreviousVertex&#39;: None
 },
 &#39;B&#39;: {
 &#39;ShortestDistance&#39;: 3,
 &#39;PreviousVertex&#39;: &#39;D&#39;
 },
 &#39;C&#39;: {
 &#39;ShortestDistance&#39;: 7,
 &#39;PreviousVertex&#39;: &#39;E&#39;
 },
 &#39;D&#39;: {
 &#39;ShortestDistance&#39;: 1,
 &#39;PreviousVertex&#39;: &#39;A&#39;
 },
 &#39;E&#39;: {
 &#39;ShortestDistance&#39;: 2,
 &#39;PreviousVertex&#39;: &#39;D&#39;
 }
 }
</code></pre>

<img src="/s3/questions/785715d4-3305-4b9f-bdd7-33d5cf987bdb.png" alt="image"/>

Implement Dijkstra's shortest path algorithm for a given graph with a known source node.

Dijkstra implementation

Let’s say you are tasked with building a spam classifier for emails. Assume that you’ve built a V1 of the model.

What metrics would you use to track accuracy and validity of the model?

What metrics would you use to track accuracy and validity of the model

Spam Classifier 

You’re hired by a literary newspaper for an unusual project. They want you to use your data science skills to parse the most frequent words used in poems.

Poems are given as a list of strings called <code>sentences</code>. Return a dictionary of the frequency that words are used in the poem.

Your keys should be a number representing the number of times the word is used in the poem, with its value being a list of words with that frequency.

Make sure to process all words as entirely lowercase. Additionally, do not worry about parsing punctuation marks.

Note: Due to limitations with our code runner, your keys will be displayed as strings instead of integers. But you do not need to convert the keys to strings yourself

Example:

Input:

<pre tabindex="0" class="chroma"><code>sentences = [
 &#34;I love roses&#34;,
 &#34;Roses are the best&#34;,
 &#34;Roses are red violets are blue&#34;
]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def word_frequency(sentences) -&gt; {
 &#34;1&#34;:[&#34;I&#34;,&#34;love&#34;,&#34;the&#34;,&#34;best&#34;,&#34;violets&#34;,&#34;blue&#34;],
 &#34;3&#34;:[&#34;roses&#34;,&#34;are&#34;]
}
</code></pre>

Write a function to parse the most frequent words.

Word Frequency

Tower of Hanoi is a fun puzzle game that consists of a set of <code>3</code> pegs (<code>A</code>, <code>B</code>, <code>C</code>) and <code>n</code> number of disks. You are required to move all disks from the source peg <code>A</code> to destination peg <code>C</code>, under the following conditions:

<ul>
<li>You can only move one disk for each action.</li>
<li>You can only move the disk onto the top of another peg; you cannot place it off to the side or under existing disks.</li>
<li>You cannot place a larger disk onto a smaller disk.</li>
</ul>

Initially, all disks are on the source <code>A</code> peg and sorted by decreasing width from bottom to the top (widest on the bottom, smallest on the top).

You must develop an algorithm to move all disks from <code>A</code> to the destination peg <code>C</code> with the optimal solution. Also, return every step made from the starting state to the final state.

<img src="https://i.ibb.co/my0Vm13/initail.png" alt="alt"/>

<img src="https://i.ibb.co/0Ftzs7D/final.png" alt="alt"/>

Example

Input:

<pre tabindex="0" class="chroma"><code>n = 3
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>#return list of {&#34;A&#34;:[],&#34;B&#34;:[],&#34;C&#34;:[]} 
tower_of_hanoi_solver(n) -&gt; [
 {&#34;A&#34;: [1, 2, 3], &#34;B&#34;: [], &#34;C&#34;: []},
 {&#34;A&#34;: [2, 3], &#34;B&#34;: [], &#34;C&#34;: [1]},
 {&#34;A&#34;: [3], &#34;B&#34;: [2], &#34;C&#34;: [1]},
 {&#34;A&#34;: [3], &#34;B&#34;: [1, 2], &#34;C&#34;: []},
 {&#34;A&#34;: [], &#34;B&#34;: [1, 2], &#34;C&#34;: [3]},
 {&#34;A&#34;: [1], &#34;B&#34;: [2], &#34;C&#34;: [3]},
 {&#34;A&#34;: [1], &#34;B&#34;: [], &#34;C&#34;: [2, 3]},
 {&#34;A&#34;: [], &#34;B&#34;: [], &#34;C&#34;: [1, 2, 3]}
 ]
</code></pre>

What is the minimal number of steps needed to solve the Tower of Hanoi problem with n disks?

What is the minimal number of steps needed to solve the Tower of Hanoi problem with *n* disks?

Linear Data Structures

Write an algorithm to solve Tower of Hanoi optimally and return every step from A to C

Tower of Hanoi

Given an array filled with random values, write a function <code>rotate_matrix</code> to rotate the array by 90 degrees in the clockwise direction.

Example:

Input:

<pre tabindex="0" class="chroma"><code>import numpy as np

array = np.array( [[1, 2, 3, 4, 5], [2, 3, 4, 5, 6], [3, 4, 5, 6, 7], [4, 5, 6, 7, 8], [5, 6, 7, 8, 9]] )

</code></pre>

array
<table><tbody><tr><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td></tr><tr><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td></tr><tr><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td></tr><tr><td>4</td><td>5</td><td>6</td><td>7</td><td>8</td></tr><tr><td>5</td><td>6</td><td>7</td><td>8</td><td>9</td></tr></tbody></table>

Output:

<table><tbody><tr><td>5</td><td>4</td><td>3</td><td>2</td><td>1</td></tr><tr><td>6</td><td>5</td><td>4</td><td>3</td><td>2</td></tr><tr><td>7</td><td>6</td><td>5</td><td>4</td><td>3</td></tr><tr><td>8</td><td>7</td><td>6</td><td>5</td><td>4</td></tr><tr><td>9</td><td>8</td><td>7</td><td>6</td><td>5</td></tr></tbody></table>

Write a function to rotate an array by 90 degrees in the clockwise direction.

Matrix Rotation

You work as a backend engineer at a company deploying a large language model (LLM) as a service for multiple clients. The LLM must handle concurrent user requests while maintaining low latency, high throughput, and robust fault tolerance.

How would you design the serving infrastructure for this LLM to efficiently manage simultaneous requests from multiple users?

Design a system to handle simultaneous requests to a deployed LLM model ensuring scalability, low latency, and reliability.

Concurrent LLM Serving

Concurrent & Distributed Systems

The Fibonacci sequence is a series of numbers in which each number is the sum of the two preceding ones, usually starting with 0 and 1. It is often used in algorithm examples, and is defined by the following formula: F(n) = F(n-1) + F(n-2), with F(0) = 0 and F(1) = 1.

Your task is to implement the Fibonacci algorithm in three different methods:
1. Recursively
2. Iteratively
3. Using Memoization

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>n = 5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>fibonacci(n) -&gt; 5
</code></pre>

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>n = 10
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>fibonacci(n) -&gt; 55
</code></pre>

The Fibonacci sequence starts as follows: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55…

This question requires the implementation of the Fibonacci sequence using three different methods: recursively, iteratively, and using memoization.

Implementing the Fibonacci Sequence in Three Different Methods

Let’s say we’re building a system for eBay to support multiple types of sellers: individuals, small businesses, and enterprise merchants. Each seller type shares core attributes like <code>seller_id</code> and <code>account_status</code>, but has unique features—enterprise merchants, for example, can manage up to 50 sub-accounts, while individuals have simpler profiles.

How would you decide between using composition or inheritance to model these seller types, and what trade-offs would you weigh in making your choice?

How would you decide between composition and inheritance when modeling different seller types on eBay?

Seller Type Modeling

You work as a data engineer at Spotify. The executive team requests a weekly analytics report summarizing user engagement and streaming trends, using data from internal databases and log files. Strict budget constraints prohibit the use of commercial or managed cloud services; you must rely solely on open-source technologies such as PostgreSQL, Apache Airflow, Apache Spark, and Metabase.
How would you architect this reporting pipeline from data ingestion to report delivery?

Design a reporting pipeline for a major tech company using only open-source tools under strict budget constraints.

Open Source Reporting Pipeline

You work as a DevOps engineer for a global SaaS company with services deployed across multiple cloud providers. The team wants to implement a cloud-agnostic CI/CD pipeline that supports safe, zero-downtime deployments for critical microservices. The deployment process should allow for rapid rollback, controlled traffic shifting, and minimal service disruption.

How would you design this CI/CD and deployment system?

Design a cloud-agnostic CI/CD pipeline supporting safe deployments and rollbacks across multiple providers.

Cloud-Agnostic Deployments

DevOps

Given a string, write a function to determine if it is palindrome or not.

Note: A palindrome is a word/string that is read the same way forward as it is backward, e.g. <code>&#39;reviver&#39;</code>, <code>&#39;madam&#39;</code>, <code>&#39;deified&#39;</code> and <code>&#39;civic&#39;</code> are all palindromes, while <code>&#39;tree&#39;</code>, <code>&#39;music&#39;</code> and <code>&#39;person&#39;</code> are not palindromes.

Example:

Input:

<pre tabindex="0" class="chroma"><code>word1 = &#34;tree&#34;
word2 = &#34;radar&#34;
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def is_palindrome(word1) -&gt; False
def is_palindrome(word2) -&gt; True
</code></pre>

Given a string, write a function to determine if it is palindrome or not.

String Palindromes

As a data engineer for Slack, they asked you to design their new product, “Slack for School”. When designing their database, you ponder upon the following questions:

<ol>
<li>What are the critical entities, and how would they interact?</li>

<li>Imagine we want to provide insights to teachers about students’ class participation. How should we design an ETL process to extract data about when and how often each student interacts with the app?</li>

<li>Suppose a teacher wants to see the students’ assignment submission trends over the last six months. How would you write a SQL query to retrieve this data?</li>
</ol>

How would you answer?

System design for a digital classroom service.

Digital Classroom System Design

Write a function <code>fib</code> which takes an integer <code>n</code> and returns the nth fibonacci number. For this question, <code>fib</code> MUST be recursively defined.

Note: <code>for</code> and <code>while</code> keywords are disabled for this question, as well as <code>functools</code>. Any workarounds around this restriction is prohibited.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n = 4
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def fib(n) -&gt; 3
# the sequence is [1, 1, 2, 3, 5, 8...]
</code></pre>

Implement a dynamic recursive fibonacci function.

Impossibly Iterative Fibonacci

You work as an analyst at DeltaMart. Over the years, DeltaMart’s data volume has exploded : clickstream events, search logs, inventory updates, payments, delivery scans, and customer behavior signals now exceed 5 TB/day. Different teams face multiple issues in day-to-day tasks because:

<ol>
<li>Real-time metrics (orders/min, delivery delays) are unreliable (lags, inaccuracies, etc. have been observed)</li>
<li>Batch reports take hours to run</li>
<li>ML teams struggle with inconsistent historical data</li>
<li>No unified governance across domains</li>
</ol>

The technical lead has asked your team to design a next-generation data platform that can support real-time analytics, batch workloads, ML experimentation, and cross-team collaboration.

Identify the core architectural principles we should adopt when designing this new platform.

For each principle, explain briefly:

<ol>
<li>What the principle means?</li>
<li>How it would influence a specific design or technology choice?</li>
<li>What tradeoff it introduces?</li>
<li>How it helps DeltaMart scale without breaking?</li>
</ol>

Designing an architecture to support real time and batch analytics

Expansion Plan

Business Case

You have been tasked with designing three classes: <code>text_editor</code>, <code>moving_text_editor</code>, and <code>smart_text_editor</code>. These classes are to be created with specific functionalities as defined below:

<ol>
<li><code>text_editor</code> class:

<ul>
<li><code>write_line(string:str)</code>: A method which appends a given string to the end of the existing string.</li>
<li><code>delete_line(char_num : int)</code>: A method which deletes <code>char_num</code> number of characters from the existing string, starting from the end. If there are no characters left, the method should do nothing.</li>
<li><code>special_operation()</code>: A method which currently does nothing.</li>
<li><code>get_notes()</code>: A method which returns the internal string.</li>
</ul></li>

<li><code>moving_text_editor</code> class:

<ul>
<li>This class extends <code>text_editor</code>. The <code>special_operation()</code> method is overridden. Initially, the cursor will be at the end of the current string. If <code>special_operation()</code> is called, it moves the cursor to the beginning of the string, any additional appends will be appended to the beginning of the string instead. Calling <code>special_operation()</code> again reverses the cursor operation.</li>
</ul></li>

<li><code>smart_text_editor</code> class:

<ul>
<li>This class extends <code>text_editor</code>. In this class, the <code>special_operation()</code> method is overridden to serve as an undo operation, allowing it to undo an infinite number of operations.</li>
</ul></li>
</ol>

<h3>Input</h3>

<pre tabindex="0" class="chroma"><code>[[&#39;special_text_editor&#39;], [&#39;write_line&#39;, &#39;special_operation&#39;, &#39;write_line&#39;], [&#39;World&#39;, &#39;Hello, &#39;]]
</code></pre>

<h3>Output</h3>

<code>&#34;Hello, World&#34;</code>

Create a text editor while displaying method overriding as a concept.

Text Editor With OOP

Design Patterns

Let’s say you’re a data engineer at a rapidly expanding e-commerce company, and the volume of daily transactions has increased from 10,000 to 100,000 over the past year.
How would you approach designing or adapting your data pipelines to ensure they remain both scalable and reliable as the business continues to grow?

How would you design data pipelines to handle rapid growth in data volume while maintaining reliability?

Scalable Data Pipelines

You work as a cloud architect at a large enterprise. The company is migrating its core web application to Microsoft Azure and wants to ensure high availability and scalability. You are asked to provision the infrastructure as code, leveraging Kubernetes for orchestration and Terraform for automation.

How would you architect this system to maximize reliability and scalability?

Write a technical design document describing your approach.

Design a highly available, scalable Azure infrastructure using Terraform and Kubernetes.

Azure Kubernetes Infrastructure

Let’s say we’ve proposed a new analytics dashboard to a client, but after reviewing our design and data sources, the client says the solution doesn’t meet their needs and pushes back on several key features.

How would you approach the conversation to negotiate alternative solutions, and what steps would you take to ensure disagreements are handled constructively so we can still reach a successful outcome?

How would you negotiate and resolve disagreements when a client rejects your proposed solution?

Client Solution Pushback

Suppose that you are a machine learning engineer for a large bank, working with the modeling team that creates input data for downstream models. Downstream models can include regulatory models for risk, internal models for credit decisions, internal risk models, marketing models, audits, and any other application where ML can be used.

You have access to the following APIs:

<ul>
<li>Reddit API for all posts and comments for finance and news-related subreddits</li>
<li>Bloomberg API for daily stock prices, including opening and closing prices</li>
</ul>

How would you go about designing an ML system that extracts data from those APIs, transforms the data, and stores it in a format that downstream modeling teams can use?

Designing an ML system to extract financial insights from market data for improved bank decision-making

Using APIs for Downstream Tasks

AI & Agentic Systems

What is the difference between Logistic and Linear Regression?

When would use one instead of the other in practice?

What is the difference between Logistic and Linear Regression?

Linear vs Logistic Regression

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Given the <code>employees</code> and <code>departments</code> table, write a query to get the top 3 highest employee salaries by department. If the department contains less that 3 employees, the top 2 or the top 1 highest salaries should be listed (assume that each department has at least 1 employee). 

Note: The output should include the full name of the employee in one column, the department name, and the salary. The output should be sorted by department name in ascending order and salary in descending order. 

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>employee_nam</code>e</td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>department_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

Tech Mahindra Interview Questions

Tech Mahindra Interview Guides

Tech Mahindra Interview Questions

Challenge

Tech Mahindra Salaries by Position

Discussion & Interview Experiences

Discussion & Interview Experiences