I applied online. The process took 2 weeks. I interviewed at Mphasis (Pune) in Feb 2023
Interview
It was good where HR was very quick with response and hiring process was also fast and got offer letter in 2 days where HR explained all the things like benefits and other.
Interview questions [1]
Question 1
Basic Linux questions related to linux and ansible and Vmware
I applied through a recruiter. The process took 1 week. I interviewed at Mphasis (Pune) in July 2023
Interview
good experience with the panel and level was medium. I had two technical rounds and one HR round. Be prepared to answer questions about Mphasis itself, its projects, and how your skills align with the company's goals. Show that you've done your research
Interview questions [1]
Question 1
SQL:
Subqueries:
Explain what a subquery is and provide an example of how you might use it.
Normalization:
What is database normalization, and why is it important? Can you give an example of normalization?
Transactions:
Describe the properties of a transaction in a database. What is ACID, and why is it important?
Performance Tuning:
How would you optimize a slow-performing SQL query? What tools or techniques would you use?
Joins:
Explain the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
I applied through a recruiter. I interviewed at Mphasis (Bengaluru) in May 2020
Interview
There were 3 rounds: 2 rounds from Mphasis team and 1 round from Client. First round had basic questions on Resume followed by second round which was technical. Client interview was on previous experience.