Mock Interview Questions – Mu Sigma (Data
Analytics Role)
■ Technical Questions
1. What is the difference between Data Science and Decision Science?
2. Explain a project where you used data to solve a problem.
3. What are different types of joins in SQL? Give examples.
4. How do you handle missing data in a dataset?
5. Write a SQL query to find the second highest salary in a table.
6. What is normalization and why is it important in databases?
7. What’s the difference between supervised and unsupervised learning?
8. Explain the concept of p-value in hypothesis testing.
9. How would you identify outliers in a dataset?
10. How do Excel formulas like VLOOKUP or Pivot Tables help in data analytics?
■ Behavioral Questions
1. Tell me about yourself.
2. Why do you want to work at Mu Sigma?
3. Describe a time when you solved a problem using data.
4. How do you manage tight deadlines and multiple tasks?
5. Describe a situation where you had to work in a team with conflicting opinions.
■ Case Study / Situational Questions
1. A client reports a sudden drop in sales. How would you investigate the issue using data?
2. You're given a messy dataset with missing and inconsistent values. What's your approach to
clean and analyze it?
3. You notice a team member consistently missing deadlines, impacting project delivery. How
would you handle this?