Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Vyapar Team. If you also belong to the team, you can get access from here

Vyapar Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 318 Reviews

Filter interviews by

Vyapar Data Analyst Interview Questions and Answers for Freshers

Updated 28 Nov 2024

1 interview found

Sort by: Popular

Data Analyst Interview Questions

user image Anonymous

posted on 28 Nov 2024

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Oct 2024.

3 Interview Rounds

1

Aptitude Test Round

6 mcqs and 2 sql questions

2

Technical Round (5 Questions)

  • Q1. Difference between having and where in sql
  • Q2. Sql joins and it types
  • Q3. Window functions and subqueries
  • Q4. Sql scenario question based on joins
  • Q5. Kpi's and metrics
3

Technical Round (1 Question)

  • Q1. Business problem related to case study

Interview Preparation Tips

Interview preparation tips for other job seekers - learn sql, problem solving,puzzles,kpi's and metrics

Skills evaluated in this interview

Data Analyst Jobs at Vyapar

View all

Interview questions from similar companies

I applied via campus placement at International Institute of Information Technology (IIIT), Bangalore and was interviewed in Oct 2022.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2

Coding Test Round

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

3

Technical Round (3 Questions)

  • Q1. SQL related questions
  • Q2. Questions on ETL and Bigdata
  • Q3. Resume related questions
4

HR Round (1 Question)

  • Q1. Company policies and work culture explanation and acceptance to work

Interview Preparation Tips

Topics to prepare for Celebal Technologies Data Analyst interview:
  • MySQL
  • ETL
  • Bigdata
  • DBMS
Interview preparation tips for other job seekers - Prepare SQL very well. And you will easily clear all the rounds. Be confident. The hiring team is great
Interview experience
4
 Good
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed before Sep 2023.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Rate yourself in SQL and PowerBi
  • Q2. Different Type of Joins
Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Coding Test Round

It is an online coding test and the duration is 3 hours. They test your python skills here. Questions are related to Python and Pandas. You have to write code for the given questions.

2

One-on-one Round (2 Questions)

  • Q1. Few basic python programs related to lists, data structures, strings, Fibonacci series etc
  • Q2. Asked ML related questions like regression, classification algorithms, NLP questions, evaluation metrics, how to handle if there are many attributes in dataset ...read more

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not join in this company. They say that they'll convert you as a Full time employee in 8 months but ultimately they will convert you after one year and mass lay offs are going on.
Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Coding Test Round

Python coding, simple

2

Technical Round (2 Questions)

  • Q1. Data analytics related, imbalanced data set handling
  • Q2. Overfit and how to fix that
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Company Website and was interviewed in Aug 2023.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Heap concept,insert 10 values in list
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 -
Result
Selected  Selected

I applied via Company Website and was interviewed in Aug 2024.

2 Interview Rounds

1

Coding Test Round

It was Python coding and Sql query assessment round.

2

One-on-one Round (2 Questions)

  • Q1. Perform task on joins?
  • Q2. Explain projects

I applied via campus placement at International Institute of Information Technology (IIIT), Bangalore and was interviewed in Oct 2022.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Coding Test Round

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

3

Technical Round (3 Questions)

  • Q1. SQL related questions
  • Q2. Questions on ETL and Bigdata
  • Q3. Resume related questions
4

HR Round (1 Question)

  • Q1. Company policies and work culture explanation and acceptance to work

Interview Preparation Tips

Topics to prepare for Celebal Technologies Data Analyst interview:
  • MySQL
  • ETL
  • Bigdata
  • DBMS
Interview preparation tips for other job seekers - Prepare SQL very well. And you will easily clear all the rounds. Be confident. The hiring team is great
Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

3 Interview Rounds

1

Coding Test Round

It had 1 SQL question & 1 question on Dynamic Programming.

2

Technical Round (2 Questions)

  • Q1. Question on group by, aggregate functions.
  • Q2. Window functions
3

HR Round (2 Questions)

  • Q1. What projects have you worked on ?
  • Q2. Any interesting problem solved ?
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed before Feb 2023.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Sql queries- nth highest salary python code- reverse string, word count program repartition vs coalesce reader and writer API External vs managed table Spark ar...read more

Vyapar Interview FAQs

How many rounds are there in Vyapar Data Analyst interview for freshers?
Vyapar interview process for freshers usually has 3 rounds. The most common rounds in the Vyapar interview process for freshers are Technical and Aptitude Test.
How to prepare for Vyapar Data Analyst interview for freshers?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Vyapar. The most common topics and skills that interviewers at Vyapar expect are Python, SQL, Data Analytics, Data Mining and Data Visualization.
What are the top questions asked in Vyapar Data Analyst interview for freshers?

Some of the top questions asked at the Vyapar Data Analyst interview for freshers -

  1. difference between having and where in ...read more
  2. table were given in google sheet & had to write basic level queries on them eg....read more
  3. The interviewer was not serious at all, asked silly quizzes instead of business...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Vyapar interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

Zoho Interview Questions
4.3
 • 485 Interviews
Tekion Interview Questions
3.1
 • 85 Interviews
Innovaccer Interview Questions
3.4
 • 72 Interviews
NoBrokerHOOD Interview Questions
3.3
 • 54 Interviews
Tally Solutions Interview Questions
4.2
 • 36 Interviews
Grey Orange Interview Questions
3.2
 • 35 Interviews
View all
Vyapar Data Analyst Salary
based on 8 salaries
₹7 L/yr - ₹13 L/yr
49% more than the average Data Analyst Salary in India
View more details

Vyapar Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-Life balance

5.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

5.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Business Development Executive
135 salaries
unlock blur

₹2.8 L/yr - ₹5.4 L/yr

Inside Sales Executive
73 salaries
unlock blur

₹2.7 L/yr - ₹4.5 L/yr

Accounts Manager
70 salaries
unlock blur

₹2.8 L/yr - ₹6 L/yr

Team Lead
67 salaries
unlock blur

₹4 L/yr - ₹7.8 L/yr

Customer Support Executive
56 salaries
unlock blur

₹2.8 L/yr - ₹3.7 L/yr

Explore more salaries
Compare Vyapar with

Zoho

4.3
Compare

Tally Solutions

4.3
Compare

MARG ERP

3.6
Compare

Busy Infotech

4.1
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview