Indium Software Senior Data Analyst Interview Questions, Process, and Tips

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

Q1. Sql based questions in first round and increased level in next rounds
Add your answer
Q2. Simple python questions
Add your answer
Q3. Guessestimate- process matters not answers
Add your answer

Q1. Hard SQL question
Add your answer

Q1. Sql based questions asked
Add your answer
Q2. Fit for the role
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

5 Aptitude + 3 SQL query (2 medium level, 1 Advanced)

Q1. Most focused on sql, advanced sql, Python basics
Add your answer
Q2. Tableu questions
Add your answer

Q1. HR questions and salary discussion
Add your answer