i
Mphasis
Filter interviews by
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
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
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
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
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
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...
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.
What people are saying about Mphasis
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
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
Mphasis interview questions for popular designations
Get interview-ready with Top Mphasis Interview Questions
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
Data structures and algorithm
I applied via Approached by Company and was interviewed in Feb 2024. There were 3 interview rounds.
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...
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
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.
I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.
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
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.
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
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.
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
Coding and some basic questions
Basic questions on Java and DB.
Some of the top questions asked at the Mphasis interview for experienced candidates -
The duration of Mphasis interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 187 interviews
Interview experience
based on 8.4k reviews
Rating in categories
Software Engineer
6.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
5.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
4.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Module Lead
2.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Transaction Processing Officer
2.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
Wipro
Accenture
TCS