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 Data Quality Analyst Interview Questions and Answers

Updated 4 Jun 2024

Mphasis Data Quality Analyst Interview Experiences

1 interview 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

Interview questions from similar companies

I applied via Company Website and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. What is the difference between UL and VUL
  • Ans. 

    UL and VUL are both types of life insurance policies, but VUL offers investment options while UL does not.

    • UL stands for Universal Life Insurance, which offers a fixed premium and death benefit but no investment options

    • VUL stands for Variable Universal Life Insurance, which offers investment options in addition to a flexible premium and death benefit

    • VUL policyholders can choose to invest in stocks, bonds, and mutual fun...

  • Answered by AI
  • Q2. What are the Death Benefit Options?
  • Q3. What are the Non-forfeiture options?
  • Ans. 

    Non-forfeiture options are the choices available to a policyholder when they stop paying premiums.

    • Non-forfeiture options allow policyholders to retain some value from their policy even if they stop paying premiums.

    • Common non-forfeiture options include reduced paid-up insurance, extended term insurance, and cash surrender value.

    • Reduced paid-up insurance provides a smaller death benefit but does not require further premi...

  • Answered by AI
  • Q4. What is Reinsurance?
  • Ans. 

    Reinsurance is a process where an insurance company transfers a portion of its risk to another insurance company.

    • Reinsurance helps insurance companies manage their risk exposure.

    • It allows insurance companies to protect themselves against large losses.

    • Reinsurance can be either proportional or non-proportional.

    • Proportional reinsurance involves sharing both premiums and losses with the reinsurer.

    • Non-proportional reinsuran...

  • Answered by AI
  • Q5. What is an Underwriting?
  • Ans. 

    Underwriting is the process of evaluating and assessing the risk of insuring a person or entity.

    • Underwriting involves analyzing the potential risks and determining the appropriate premium to charge for insurance coverage.

    • It is commonly used in the insurance industry for various types of insurance policies such as life, health, and property insurance.

    • Underwriting also involves reviewing the applicant's financial and med...

  • Answered by AI
  • Q6. Major differences between traditional life and whole life products?

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are attending an interview for the Insurance project, you will face most of the questions from the Insurance domain. So please be prepared.

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. 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.

Interview Questionnaire 

2 Questions

  • Q1. Why should I hire you
  • Q2. Tell them something which you r confident as your strength and you have an upper hand ... Anything close to you any learning which you apply in life

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cool and relaxed... What has to happen wil happen.

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.

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

I applied via Company Website and was interviewed in May 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. As I was from Insurance IT background most of the questions were from Insurance and SDLC for Insurance products
  • Q2. Be confident on what you are speaking. Communication skills has to be very good as I got a compliment from the Interviewer that I have a good communication skills.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep exploring.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(7 Questions)

  • Q1. Tell me about yourself.
  • Ans. 

    Experienced business analyst with a background in data analysis and process improvement.

    • Over 5 years of experience in analyzing business processes and identifying areas for improvement

    • Skilled in data analysis tools such as Excel, SQL, and Tableau

    • Strong communication and problem-solving skills

    • Certified in Business Analysis Professional (CBAP)

    • Previously worked on a project to streamline inventory management processes, re

  • Answered by AI
  • Q2. What are your BAU tasks as a Business Analyst
  • Ans. 

    BAU tasks of a Business Analyst include gathering requirements, analyzing data, creating reports, and facilitating communication between stakeholders.

    • Gathering and documenting business requirements from stakeholders

    • Analyzing data to identify trends and insights

    • Creating reports and presentations to communicate findings

    • Facilitating communication between different teams and stakeholders

    • Participating in meetings to discuss

  • Answered by AI
  • Q3. What is API in Business Analysis?
  • Ans. 

    API in Business Analysis refers to Application Programming Interface, which allows different software systems to communicate with each other.

    • APIs define the methods for accessing and interacting with software applications

    • They enable data sharing and functionality between different systems

    • APIs are commonly used in business analysis to integrate various software tools and systems

    • Examples include using APIs to connect a C

  • Answered by AI
  • Q4. How much do you rate yourself in SQL knowledge?
  • Ans. 

    I rate myself as proficient in SQL knowledge.

    • I have extensive experience writing complex SQL queries for data analysis and reporting.

    • I am comfortable working with joins, subqueries, and aggregations.

    • I have optimized database performance by creating indexes and tuning queries.

    • I have experience with stored procedures, triggers, and functions.

    • I am familiar with database management systems like MySQL, SQL Server, and Oracl

  • Answered by AI
  • Q5. What are use cases?
  • Ans. 

    Use cases are descriptions of how a system will be used by end users to achieve specific goals.

    • Use cases describe interactions between users and a system

    • They outline specific goals or tasks that users want to accomplish

    • Use cases help in understanding system requirements and functionality

    • Examples include 'User login', 'Place order', 'Generate report'

  • Answered by AI
  • Q6. How do you write User Stories?
  • Ans. 

    User stories are written in a specific format to capture requirements from the perspective of an end user.

    • Start with 'As a , I want so that '

    • Keep user stories small, focused, and independent

    • Include acceptance criteria to define when a user story is complete

  • Answered by AI
  • Q7. What are the Acceptance Criteria?
  • Ans. 

    Acceptance criteria are conditions that a product must meet to be accepted by stakeholders.

    • Acceptance criteria are defined during the requirements gathering phase.

    • They are used to determine if a product or feature is working as expected.

    • Acceptance criteria are usually written in a specific format such as 'Given-When-Then'.

    • Example: 'Given a user is logged in, when they click on the submit button, then the form should be

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Nov 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Questions were medium level and quants Questions, english Questions include vocabulary test etc were also there.

Round 3 - Technical 

(1 Question)

  • Q1. Questions based on skills mentioned in CV
Round 4 - HR 

(1 Question)

  • Q1. Let him know which is not there in your CV.

Interview Preparation Tips

Interview preparation tips for other job seekers - Before going in an interview read your CV carefully mostly the questions are based on the skills mentioned in your CV.

Mphasis Interview FAQs

How many rounds are there in Mphasis Data Quality Analyst interview?
Mphasis interview process usually has 1 rounds. The most common rounds in the Mphasis interview process are Technical.
What are the top questions asked in Mphasis Data Quality Analyst interview?

Some of the top questions asked at the Mphasis Data Quality Analyst interview -

  1. how to product wise second heighest sales it...read more
  2. how to Pivot a table in ...read more

Tell us how to improve this page.

Mphasis Data Quality Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

LTIMindtree Interview Questions
3.7
 • 2.9k Interviews
DXC Technology Interview Questions
3.7
 • 802 Interviews
Nagarro Interview Questions
4.0
 • 762 Interviews
NTT Data Interview Questions
3.8
 • 627 Interviews
Publicis Sapient Interview Questions
3.5
 • 618 Interviews
GlobalLogic Interview Questions
3.6
 • 591 Interviews
View all
Software Engineer
6.5k salaries
unlock blur

₹2 L/yr - ₹9.5 L/yr

Senior Software Engineer
5.7k salaries
unlock blur

₹6 L/yr - ₹24 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 - ₹36 L/yr

Transaction Processing Officer
2.3k salaries
unlock blur

₹1.4 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