AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Mphasis
Compare
Filter interviews by
Mphasis Data Quality Analyst Interview Questions and Answers for Experienced
Mphasis Data Quality Analyst Interview Experiences for Experienced
1 interview found
Aamod Gadling
Selected
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
(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
- 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
Skills evaluated in this interview
Interview questions from similar companies
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
Business Analyst Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 14 Mar 2021
Interview Questionnaire
1 Question
- Q1. Introduce Yourself
Interview Preparation Tips
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
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
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 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
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
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 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
Mphasis Interview FAQs
Tell us how to improve this page.
Mphasis Interviews By Designations
- Mphasis Associate Software Engineer Interview Questions
- Mphasis Software Engineer Interview Questions
- Mphasis Senior Software Engineer Interview Questions
- Mphasis Module Lead Interview Questions
- Mphasis Transaction Processing Officer Interview Questions
- Mphasis Software Developer Interview Questions
- Mphasis Delivery Module Lead Interview Questions
- Mphasis Automation Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Show more
Mphasis Data Quality Analyst Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
6.5k
salaries
|  ₹2 L/yr - ₹9.5 L/yr |
|
Senior Software Engineer
5.7k
salaries
| ₹6 L/yr - ₹24 L/yr |
|
Associate Software Engineer
4.7k
salaries
| ₹2 L/yr - ₹6 L/yr |
|
Module Lead
2.4k
salaries
| ₹9.5 L/yr - ₹36 L/yr |
|
Transaction Processing Officer
2.3k
salaries
| ₹1.4 L/yr - ₹4.5 L/yr |
Cognizant
Wipro
Accenture
TCS
- Home >
- Interviews >
- Mphasis Interview Questions >
- Mphasis Data Quality Analyst Interview Questions for Experienced
