Enterprise Minds Data Analyst Interview Questions and Answers

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

Q1. Any question wtihtout i'm very honested and cearfully
Add your answer
Q2. My goal setting and my hobby ect.
Add your answer

The aptitude test consists of MCQ on computer technicals , english, verbals, etc as like usual aptitude test. Also it includes 2-3 sql queries to solve as well as 1-2 coding questions with easy to medium level difficulty.

Q1. Technical round was around 1 hour. They had asked me the technical questions related to computer fundamentals like networking, DS, OOP, etc. Then he went on java code and their programming basics like adap...read more
Add your answer

Q1. HR was the telephonic round for me. They just asked normal hr questions like intro, strengths, weakness, location preferences, technologies on which i had worked on etc. They have also gave me the CTC info...read more
Add your answer

Q1. Basic to Intermediate SQL Based questions
Add your answer
Q2. Basic to Intermediate Python Based questions
Add your answer

It was a test of 90 minutes containing almost every thing .Quantitative+Logical+Computer fundamentals+2 coding questions

Hackerra test with sql ,python coding and theory

Sql advanced coding round

Python basic coding test

Q1. General discussion
Add your answer

Hard 2 questions in 45 mins