Vyapar Data Analytics Analyst Interview Questions and Answers

Consisting of around 10 SQL querying questions and 2 Python programming questions and 30 SQL + PowerBI related MCQs

Q1. SQL related questions
Add your answer
Q2. Questions on ETL and Bigdata
Add your answer
Q3. Resume related questions
Add your answer

Q1. Company policies and work culture explanation and acceptance to work
Add your answer

It contain MCQ question which contain F section but all are easy. It contain some coding problem of easy, medium and hard level of Data structure and problems related to your domain.

Q1. They mainly asked the question related to your Domain.
Add your answer
Q2. SQL, DS,OOPS,DBMS etc.
Add your answer

Q1. HR only asked about yourself and offered you a salary.
Add your answer

Q1. SQL basics questions like types of joins, indexes etc.
Add your answer

Q1. About last company project experience
Add your answer

Q1. Salary, reason to change discussion
Add your answer

Q1. They asked Questions on join given two table A&B with one column each and u have to print out put for inner join, left join and correct join.
Add your answer
Q2. Then they asked medium level questions given , write query to print 2nd highest marks for each class using concept of windows function in SQL.
Add your answer

Q1. Managerial round
Add your answer
Q2. They asked all my project in my CV and deep discussion on each one. What is SCD type, what are composite key .
Add your answer

Q1. CTC negotiation
Add your answer
Q2. What u know about company and why u want to join company.
Add your answer

SQL+CODING QUESTIONS

Q1. CODING QUESTION YOU NEEDED TO TELL YOUR APPROACH AND CODE THEN
Add your answer
Q2. SQL QUESTIONS - THEORY + PREDICTING OUTPUT
Add your answer

Q1. DSA + MANAGERIAL ROUND
Add your answer
Q2. HR QUESTIONS ABOUT YOUR FUTURE
Add your answer

Guestimation question was asked.

Easy to medium leetcode question asked on array , 2 pointer , sliding window

Q1. How will you handle team conflicts
Ans. 
I will address team conflicts by promoting open communication, active listening, and facilitating constructive discussions.
• Encourage open communication among team members to address conflicts early on

• Practice active listening to understand all perspectives and concerns

• Facilitate constructive discussions to find mutually beneficial solutions

• Seek input from team members to involve them in the resolution process
Answered by AI
Add your answer
Q2. Are you able to relocate
Ans. 
Yes, I am open to relocating for the right opportunity.
• I am willing to relocate for the right job opportunity

• I have experience moving for previous roles

• I am flexible and adaptable to new environments
Answered by AI
Add your answer

6 SQL questions to solve which would be easy to moderate.

Q1. Basic to moderate SQL questions
Add your answer

Q1. Managerial round just asked about previous company and work profile.
Add your answer

Q1. CTC discussion and brief explanation about the company.
Add your answer