MothersonSumi INfotech & Designs Data Analyst Interview Questions and Answers

Q1. Briefing about my last job
Add your answer

Q1. On python data manipulation(easy)
Add your answer
Q2. Sql(intermediate)
Add your answer

Q1. Tableau interview questioins
Add your answer
Q2. SQl based quetions
Add your answer

DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION

Q1. SQL QUESTION FIND N TH HIGHEST SALARY
Ans. 
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to specify the Nth highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
Answered by AI
Add your answer
Q2. SQL QUESTION PIVOT TABLE QUESTION
Add your answer

SQL and python questions are very easy.

Q1. Introduce yourself
Add your answer

Q1. What challenges have you encountered in addressing customer problems?
Add your answer
Q2. Product quality
Add your answer

Provided sales case study, asked to analyse the same ans provide insights