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
Mphasis Data Quality Analyst Interview Experiences
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
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 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
1 Question
- Q1. Core Java Sql
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
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
Business Analyst Interview Questions & Answers
Persistent Systems
Pranjali Dhawade
posted on 15 Apr 2024
(4 Questions)
- Q1. About the project
- Q2. How to deal with priorities
- Ans.
Prioritizing tasks based on importance and deadlines is key. Use tools like Eisenhower Matrix or MoSCoW method.
Identify and categorize tasks based on urgency and importance
Use tools like Eisenhower Matrix to prioritize tasks into four quadrants: urgent and important, important but not urgent, urgent but not important, neither urgent nor important
Consider using the MoSCoW method to categorize tasks as Must have, Should ...
- Q3. Technique used for project
- Ans.
The technique used for project is Agile methodology.
Agile methodology involves iterative development, where requirements and solutions evolve through collaboration between self-organizing cross-functional teams.
It promotes adaptive planning, evolutionary development, early delivery, and continuous improvement.
Examples of Agile methodologies include Scrum, Kanban, and Extreme Programming (XP).
- Q4. About your self
(1 Question)
- Q1. Brief your profile
(1 Question)
- Q1. Basic questions regarding Business Analyst knowledge
(1 Question)
- Q1. In-depth questions with situation base
(1 Question)
- Q1. Salay discussion
Neeraj Sharma
(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
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
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
6.4k
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 - ₹35 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
