INDIUM Data Analyst Interview Questions and Answers

Q1. Question on business acumen
Add your answer

Problems on SQL but harder than round 1

Q1. SQl Questions on Cricket Match
Add your answer
Q2. Python Questions - string and list
Add your answer
Q3. Project Discussion. Project related Questions
Add your answer
Q4. Window Functions in sql
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row

• They can be used with aggregate functions like SUM, AVG, COUNT, etc.

• Common window functions include ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, etc.
Answered by AI
Add your answer

Quantative aptitude , logical reasoning and some SQL questions are asked

Social media, The company people are friendly enough to make you feel comfortable to talk.

Q1. Tell me about yourself, Project, Resume questions
Add your answer
Q2. Give me code to find cube of a number, Data handling through Python (Pandas, NumPy)
Add your answer

Q1. DSA questions about strings oops and advanced SQL (window functions)
Add your answer
Q2. Real time industry problem questions about sales and UI design.
Add your answer

Q1. Tell me about yourself and your hobbies
Ans. 
I am a passionate data analyst with a love for uncovering insights and a variety of hobbies that fuel my creativity.
• I have a background in statistics and data visualization, which helps me interpret complex datasets effectively.

• In my free time, I enjoy hiking, which allows me to connect with nature and clear my mind for analytical thinking.

• I also love photography, capturing moments and perspectives that inspire my crea...read more
Answered by AI
Add your answer

Technical round with some basic/intermediate sql questions

Q1. Questions on project, intermediate sql questions, deep analysis of scenario based questions
Add your answer

Q1. Technical questions with manager
Add your answer

Q1. Hacker rank solving questions
Add your answer

They have asked for HackerRank test which has mix of aptitude and reasoning. And second part has SQL coding comprises of 2 moderate question and 1 has moderate difficult one. I have successfully submitted 2 questions and faced test case failed for the difficult one.

Q1. Questions - 1. Order of execution of query. 2. Join and types of join. 3. Group by query. 4. Having vs where. 5. Left join tricky question 6. Self join tricky question. 7. Window function and comparison to...read more
Add your answer