Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mphasis Team. If you also belong to the team, you can get access from here

Mphasis Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mphasis Interview Questions, Process, and Tips for Experienced

Updated 11 Mar 2025

Top Mphasis Interview Questions and Answers for Experienced

View all 166 questions

Mphasis Interview Experiences for Experienced

Popular Designations

340 interviews found

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

I applied via Company Website and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How to Pivot a table in SQL
  • Ans. 

    Pivoting a table in SQL involves rotating the data from rows into columns.

    • Use the PIVOT keyword in SQL to pivot a table

    • Specify the aggregation function and columns to pivot on

    • Example: SELECT * FROM table_name PIVOT (SUM(value) FOR column_name IN (value1, value2, ...))

    • Make sure to handle NULL values appropriately

  • Answered by AI
  • Q2. How to product wise second heighest sales item.
  • Ans. 

    To find the product wise second highest sales item, sort the sales data for each product and select the second highest value.

    • Sort the sales data for each product in descending order

    • Select the second value from the sorted list to find the second highest sales item

    • Consider ties and handle them accordingly

  • Answered by AI

Skills evaluated in this interview

Data Quality Analyst Interview Questions asked at other Companies

Q1. Different types of joins, how to handle duplicates in SQL, excel
View answer (1)

Interview Questions & Answers

user image Bharath SV

posted on 12 Dec 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Character and its frequency in your name using stream
  • Ans. 

    Using Java streams to find the frequency of each character in a given name

    • Convert the name to a character array

    • Use a stream to group the characters by their frequency

    • Print out the character and its frequency

  • Answered by AI
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Walk me through your profile?
  • Q2. Companies you have similar job role experiences?
Round 2 - One-on-one 

(2 Questions)

  • Q1. Describe Lean Six Sigma?
  • Ans. 

    Lean Six Sigma is a methodology that combines Lean principles and Six Sigma techniques to improve processes by eliminating waste and reducing variation.

    • Combines Lean principles (focus on efficiency and waste reduction) with Six Sigma techniques (focus on quality and variation reduction)

    • Uses tools like value stream mapping, root cause analysis, and statistical analysis to identify and solve process problems

    • Aims to impro...

  • Answered by AI
  • Q2. Various aspect of process capacity calculation.
  • Ans. 

    Process capacity calculation involves determining the maximum output a process can achieve under normal operating conditions.

    • Process capacity is calculated by dividing the actual output by the maximum possible output.

    • It helps in identifying bottlenecks and inefficiencies in the process.

    • Examples of process capacity calculation methods include Little's Law, queuing theory, and simulation modeling.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Mphasis Process Excellence Team Manager interview:
  • Lean six sigma Black belt
Interview preparation tips for other job seekers - Be ready for a detail Operation round when going for specific job profile. Hard core digging does happen and unexpected questions do come up.
You to check the job profile completely as I found out that it was not for 1 process as shared by HR but for whole company as the requirement.

Process Excellence Team Manager Interview Questions asked at other Companies

Q1. Various aspect of process capacity calculation.
View answer (1)
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Define. Net core?
  • Ans. 

    ASP.NET Core is a cross-platform, high-performance framework for building modern, cloud-based, internet-connected applications.

    • Cross-platform framework for building web applications

    • High-performance and scalable

    • Supports cloud-based and internet-connected applications

  • Answered by AI
  • Q2. Explain web api?
  • Ans. 

    Web API is a set of rules and protocols that allow different software applications to communicate with each other over the internet.

    • Web API stands for Application Programming Interface for web-based systems.

    • It allows different software applications to interact with each other over the internet.

    • Web APIs use HTTP protocols to enable communication between systems.

    • Examples of web APIs include RESTful APIs, SOAP APIs, and G

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was good. Asked some basic scenario in. Net core.

Skills evaluated in this interview

Top Mphasis Senior Software Engineer Interview Questions and Answers

Q1. Trapping Rain Water Problem Statement Given a long type array/list ARR of size N, representing an elevation map where ARR[i] denotes the elevation of the ith bar, calculate the total amount of rainwater that can be trapped in these elevatio... read more
View answer (1)

Senior Software Engineer Interview Questions asked at other Companies

Q1. Tell me about yourself. What technology are you using? What is a Collection? What are the different types of collection there? What is the difference between ArrayList and LinkedList What are the basic building blocks of Stream operators, s... read more
View answer (2)

Mphasis interview questions for popular designations

 Associate Software Engineer

 (77)

 Software Engineer

 (56)

 Senior Software Engineer

 (56)

 Module Lead

 (33)

 Transaction Processing Officer

 (27)

 Software Developer

 (20)

 Delivery Module Lead

 (14)

 Automation Test Engineer

 (10)

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Project discussion
  • Q2. Details of project
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

Project Manager Interview Questions asked at other Companies

Q1. What is success & what is failure to you? How do you handle failure? - not much interviewer asks such questions, but I believe these are very important questions, if you want to succeed.
View answer (1)

Get interview-ready with Top Mphasis Interview Questions

Team Lead Interview Questions & Answers

user image Anonymous

posted on 21 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Coding Test 

Data structures and algorithm

Team Lead Interview Questions asked at other Companies

Q1. write a java program to get maxing profit by buying and selling a share from a given set of values (they will change the question after you give solution, like if consider buying only once and selling once they will say to buying multiple t... read more
View answer (3)

Jobs at Mphasis

View all

Module Lead Interview Questions & Answers

user image Sohel Manna

posted on 20 Mar 2024

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

I applied via Approached by Company and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. What is Indexing in SQL and why do we use Indexing?
  • Ans. 

    Indexing in SQL is a way to optimize database performance by creating a data structure that allows for faster retrieval of data.

    • Indexing is a technique used to quickly locate and access the rows in a database table.

    • It works by creating an ordered list of values from one or more columns in a table.

    • By using indexes, the database engine can quickly find the rows that match a certain condition without having to scan the en...

  • Answered by AI
  • Q2. What is a recursive query?
  • Ans. 

    A recursive query is a query that refers to itself in order to retrieve data from a database.

    • A recursive query is used to retrieve hierarchical data such as organizational structures or family trees.

    • It typically involves a common table expression (CTE) in SQL.

    • The query continues to execute until a specific condition is met, such as reaching the root node in a tree structure.

    • Example: Finding all employees and their mana

  • Answered by AI
  • Q3. What are the various joins in SQL?
  • Ans. 

    Various types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a match in both tables.

    • Left join: Returns all rows from the left table and the matched rows from the right table.

    • Right join: Returns all rows from the right table and the matched rows from the left table.

    • Full outer join: Returns rows when there is a match in either table.

  • Answered by AI
Round 2 - L2 

(1 Question)

  • Q1. Tell me about yourself.
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion.

Interview Preparation Tips

Topics to prepare for Mphasis Module Lead interview:
  • SQL
  • IT Projects

Skills evaluated in this interview

Top Mphasis Module Lead Interview Questions and Answers

Q1. How can you create a Singleton class in Java?
View answer (2)

Module Lead Interview Questions asked at other Companies

Q1. 1) describe the Cloud architecture for the azure storage, blob , cloud services? 2) describe the integration of Web API related questions for email and sms applications? 3) describe the .net core aspects for solid programming implementation... read more
View answer (2)
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is Java and usage of java

Top Mphasis Senior Software Engineer Interview Questions and Answers

Q1. Trapping Rain Water Problem Statement Given a long type array/list ARR of size N, representing an elevation map where ARR[i] denotes the elevation of the ith bar, calculate the total amount of rainwater that can be trapped in these elevatio... read more
View answer (1)

Senior Software Engineer Interview Questions asked at other Companies

Q1. Tell me about yourself. What technology are you using? What is a Collection? What are the different types of collection there? What is the difference between ArrayList and LinkedList What are the basic building blocks of Stream operators, s... read more
View answer (2)
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(5 Questions)

  • Q1. Interview questions based on your technology
  • Q2. If database,what is procedure & function
  • Ans. 

    Procedures and functions are stored routines in a database that can be called to perform specific tasks.

    • Procedures are a set of SQL statements that perform a specific task. They can have input and output parameters.

    • Functions are similar to procedures but return a value. They can be used in SQL queries like any other function.

    • Both procedures and functions can improve code reusability and maintainability in a database sy

  • Answered by AI
  • Q3. What is trigger
  • Ans. 

    A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.

    • Triggers are used to maintain data integrity by enforcing business rules or cascading changes.

    • They can be set to execute before or after INSERT, UPDATE, or DELETE operations.

    • Examples include auditing changes to a table, updating related records in other tables, or enforcing constraints.

  • Answered by AI
  • Q4. What'sis database
  • Ans. 

    A database is a structured collection of data that is stored and accessed electronically.

    • Database organizes and stores data in tables

    • It allows for efficient retrieval, insertion, and updating of data

    • Examples include MySQL, Oracle, MongoDB

  • Answered by AI
  • Q5. What is primary key?
  • Ans. 

    Primary key is a unique identifier for each record in a database table.

    • Primary key ensures each record in a table is uniquely identified.

    • It must have a unique value for each record.

    • Primary key can be a single column or a combination of columns.

    • Examples: ID column in a user table, combination of first name and last name in an employee table.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare and attend

Skills evaluated in this interview

Top Mphasis Senior Software Developer Interview Questions and Answers

Q1. If database,what is procedure & function
View answer (1)

Senior Software Developer Interview Questions asked at other Companies

Q1. Intersection of Linked List Problem You are provided with two singly linked lists containing integers, where both lists converge at some node belonging to a third linked list. Your task is to determine the data of the node at which they sta... read more
View answer (1)

Team Lead Interview Questions & Answers

user image Anonymous

posted on 23 Sep 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Coding Test 

Coding and some basic questions

Round 2 - Assignment 

Basic questions on Java and DB.

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush on your basics

Team Lead Interview Questions asked at other Companies

Q1. write a java program to get maxing profit by buying and selling a share from a given set of values (they will change the question after you give solution, like if consider buying only once and selling once they will say to buying multiple t... read more
View answer (3)

Mphasis Interview FAQs

How many rounds are there in Mphasis interview for experienced candidates?
Mphasis interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the Mphasis interview process for experienced candidates are Technical, HR and One-on-one Round.
How to prepare for Mphasis interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Mphasis. The most common topics and skills that interviewers at Mphasis expect are Java, Javascript, SQL, Spring Boot and Microservices.
What are the top questions asked in Mphasis interview for experienced candidates?

Some of the top questions asked at the Mphasis interview for experienced candidates -

  1. 1. All types of database commands- DDL, DML, DCL, TCL 2. Write a java code to r...read more
  2. 1. What are the commands used for maven build 2. What are the different stages ...read more
  3. 3 types of languages pronunciation one in english language , the same words and...read more
How long is the Mphasis interview process?

The duration of Mphasis interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Mphasis Interview Process for Experienced

based on 187 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
DXC Technology Interview Questions
3.7
 • 795 Interviews
KPIT Technologies Interview Questions
3.4
 • 281 Interviews
View all

Mphasis Reviews and Ratings

based on 8.4k reviews

3.4/5

Rating in categories

3.3

Skill development

3.5

Work-life balance

2.8

Salary

3.4

Job security

3.3

Company culture

2.5

Promotions

3.2

Work satisfaction

Explore 8.4k Reviews and Ratings
Senior Officer - Marketing

Bangalore / Bengaluru

1-4 Yrs

Not Disclosed

Module Lead - Systems

Bangalore / Bengaluru

5-8 Yrs

Not Disclosed

Delivery Module Lead

Bangalore / Bengaluru

4-6 Yrs

Not Disclosed

Explore more jobs
Software Engineer
6.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
5.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
4.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead
2.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Transaction Processing Officer
2.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mphasis with

Cognizant

3.7
Compare

Wipro

3.7
Compare

Accenture

3.8
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview