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 Senior Analyst Interview Questions, Process, and Tips

Updated 22 Jan 2022

Mphasis Senior Analyst Interview Experiences

1 interview found

I applied via Recruitment Consultant and was interviewed in Dec 2021. There was 1 interview round.

Interview Questionnaire 

6 Questions

  • Q1. 1. What is difference between ITIL V3 & V4 ?
  • Ans. 

    ITIL V4 is an updated version of ITIL V3 with a focus on agility, flexibility, and collaboration.

    • ITIL V4 introduces the Service Value System (SVS) which replaces the Service Lifecycle in V3.

    • V4 emphasizes on the importance of collaboration and communication between different departments.

    • V4 includes new practices such as Service Request Management and Problem Management.

    • V4 also includes a new certification scheme with fo...

  • Answered by AI
  • Q2. 2. What is excel formula for Forecast ? (This is scenario based question)
  • Q3. 3. How would you show the count in a graph 📈 which gets added multiple times ? (Method of cumulative graph - like COVID numbers)
  • Ans. 

    To show count in a cumulative graph, use a line graph with time on x-axis and cumulative count on y-axis.

    • Use a line graph to show the cumulative count over time

    • Plot time on the x-axis and cumulative count on the y-axis

    • Add a label to the y-axis indicating the cumulative count

    • Use different colors or markers to differentiate between different data sets

    • Include a legend to explain the different colors/markers used

  • Answered by AI
  • Q4. What's formula used for condition based scenarios in excel? (IF, SUMIF etc)
  • Ans. 

    Excel uses IF, SUMIF, COUNTIF, AVERAGEIF, and other formulas for condition based scenarios.

    • IF formula checks if a condition is met and returns one value if true and another if false.

    • SUMIF formula adds up values in a range that meet a certain condition.

    • COUNTIF formula counts the number of cells in a range that meet a certain condition.

    • AVERAGEIF formula calculates the average of values in a range that meet a certain cond...

  • Answered by AI
  • Q5. How would you extract data in Excel using macros from emails ? (Scenario based question)
  • Q6. How do you define an "Incident"/"Change"/"Problem Task" ?
  • Ans. 

    An incident is an unplanned interruption or reduction in quality of an IT service. A change is a modification to an IT service. A problem task is a task to identify the root cause of an incident or problem.

    • An incident is an event that disrupts the normal operation of an IT service, such as a server crash or network outage.

    • A change is a planned modification to an IT service, such as upgrading software or hardware.

    • A prob...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Mphasis managers are really friendly & supportive. Always be confident & do a better homework to answer the questions precisely. Please take a pause & answer. Always be ready with pen & paper. Best of luck for interview. 🙂👍

Skills evaluated in this interview

Senior Analyst Jobs at Mphasis

View all

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. About digital marketing. questions about AI,IOT and how they are being used. About half an hour long interview mostly on these topics. In addition, questions related to search engine optimisation and socia...
  • Q2. Salary discussion.

Interview Preparation Tips

Round: Resume Shortlist
Experience: Previous work experience and the projects I worked on.

Interview Questionnaire 

3 Questions

  • Q1. I was shortlisted two times ,but i did not get joining latter
  • Q2. Ans hr did not respond on the mail.
  • Q3. Why you shortlisted the candidate if you do not provide the joining

Interview Questionnaire 

1 Question

  • Q1. Introduce Yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - The company usually takes 2 rounds followed by a client round. Interview was not difficult for my profile. I was interviewed for a BA profile and questions were mostly from my area of expertise.

I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Y are you looking for job change?
  • Q2. Will provide Work from home?

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was about overall aspects like current company .salary,expected salary and skills .

Interview Questionnaire 

1 Question

  • Q1. Core Java Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - In mindtree what are questions are asked in interview

I applied via Referral and was interviewed in Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions based on Insurance domain and admin systems such as vantage and wma.

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was purely based on my technical knowledge of Insurance domain and policy admin systems Vantage and WMA. It lasted around 45 minutes. There were two rounds one techinical and second was Mangerial or HR. I answered almost 90% of the questions and tried to explain with an illustration. My experience on admin system and its functionality with the real time scenarios were of great help. My profile and knowledge was fit for the position in DXC technology. I got selected and received my offer letter within a week. Thanks! to HR team of DXC Technology and the process was smooth and hassle free.

I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions on sql and informatica

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up your resume before interview
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell more about your project
  • Ans. 

    Developed a data analysis tool to optimize inventory management for a retail company

    • Utilized SQL to extract and analyze data from multiple databases

    • Created interactive dashboards using Tableau for visual representation of data

    • Collaborated with cross-functional teams to gather requirements and implement solutions

  • Answered by AI

I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Self introduction ,what is python, cyber security

Interview Preparation Tips

Interview preparation tips for other job seekers - Say all the answers with confidence

Mphasis Interview FAQs

How to prepare for Mphasis Senior Analyst interview?
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 Excel, ISO 27001, Information Security, VBA and Accounting.
What are the top questions asked in Mphasis Senior Analyst interview?

Some of the top questions asked at the Mphasis Senior Analyst interview -

  1. 3. How would you show the count in a graph 📈 which gets added multiple times...read more
  2. What's formula used for condition based scenarios in excel? (IF, SUMIF e...read more
  3. 1. What is difference between ITIL V3 & V...read more

Tell us how to improve this page.

Mphasis Senior Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more
Mphasis Senior Analyst Salary
based on 333 salaries
₹3.6 L/yr - ₹15 L/yr
At par with the average Senior Analyst Salary in India
View more details

Mphasis Senior Analyst Reviews and Ratings

based on 45 reviews

3.8/5

Rating in categories

3.8

Skill development

4.0

Work-life balance

3.1

Salary

4.2

Job security

3.8

Company culture

3.0

Promotions

3.6

Work satisfaction

Explore 45 Reviews and Ratings
Software Engineer
6.4k salaries
unlock blur

₹2 L/yr - ₹9.5 L/yr

Senior Software Engineer
5.7k salaries
unlock blur

₹6 L/yr - ₹23.9 L/yr

Associate Software Engineer
4.7k salaries
unlock blur

₹2 L/yr - ₹6 L/yr

Module Lead
2.4k salaries
unlock blur

₹9.5 L/yr - ₹35 L/yr

Transaction Processing Officer
2.3k salaries
unlock blur

₹1 L/yr - ₹4.5 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