ValueMomentum Senior Data Analyst Interview Questions and Answers

Q1. Optimization techniques in spark
Add your answer

Q1. Tell me about your project
Add your answer

Q1. After bragging about their company for 25 minutes, they proceed to give you a 15% hike. All the negative reviews about this company is true
Add your answer

Questions on SQL, Python and Data Science. SQL joins and Cumulative Sum question followed by Python function definitions to lambda functions - square the odd digits in array using lambda function. Data Science - Which test metric to use for assessing CTR and when to differentiate between Mean Sq Error and R2 coefficient of Variation. Overall medium difficulty questions.

Coding and mcq round

Q1. Question related to your project
Add your answer

Q1. Questions on different types of joins and show its output
Add your answer
Q2. Find the second largest element in a python array
Ans. 
Find the second largest element in a Python array
• Sort the array in descending order

• Return the element at index 1, which is the second largest element
Answered by AI
Add your answer

Q1. Basic questions on sql
Add your answer
Q2. Basics of python
Add your answer

5 coding questions to evaluate data structure and algorithms shared over an online coding platform.

Q1. Machine learning fundamentals and problems related to past projects
Add your answer
Q2. Aptitude and logical reasoning questions
Add your answer

Case study to evaluate the problem solving strategy

Hacker rank 2 questions…difficulty: moderate

Q1. Write sql code to get 2nd order for each customer for each day
Ans. 
SQL code to retrieve 2nd order for each customer for each day
• Use a subquery to rank orders for each customer by date

• Filter the results to only include the 2nd order for each customer for each day
Answered by AI
Add your answer

Q1. Write sql code to give the tournament schedule for 4 countries each having only 1 match with an opponent
Ans. 
SQL code to generate tournament schedule for 4 countries each having 1 match with an opponent
• Create a table with country names and match opponents

• Use a SELECT statement to display the tournament schedule for each country
Answered by AI
Add your answer

Q1. Questions from a/b testing
Add your answer