Upload Button Icon Add office photos
Engaged Employer

i

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

CARS24 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

CARS24 Data Analyst Interview Questions and Answers

Updated 24 Apr 2022

CARS24 Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 24 Apr 2022

I applied via Naukri.com and was interviewed before Apr 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Technica questions related to sql

Round 2 - Technical 

(1 Question)

  • Q1. Some technical questions related to sql and advance excel .
Round 3 - One-on-one 

(1 Question)

  • Q1. Some questions related to cars insurance and second cars
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion and some hr questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on sql join where clause having clause etc and advance excel

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Questions from arrays and strings and some aptitude questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. How to merge 2 csv files
  • Ans. 

    To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.

    • Open both CSV files in a software like Microsoft Excel.

    • Copy the data from one CSV file and paste it into the other CSV file.

    • Save the merged CSV file with a new name.

    • Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.

  • Answered by AI
  • Q2. Basic questions on arrays
Round 3 - HR 

(1 Question)

  • Q1. 3 reasons why u choose this company
  • Ans. 

    I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.

    • Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.

    • Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.

    • Company culture - I value a positive work environment and the...

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. Questions on python

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Interviewer asked me basic SQL questions
  • Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Round 2 - Coding Test 

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Basic Excel Questions
  • Q2. Medium and Basic SQL Questions
  • Q3. Resume based Question
  • Q4. Case Study Questions
  • Q5. Questions on Project
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL based questions wer asked on joins , rank function,

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL base Question
  • Q2. About your projects
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

Round 2 - Case Study 

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Aptitude Test 

Number sires, clock, logic, arithmetic, geometry

Round 3 - Coding Test 

Code test basic, ans the basic knowledge, write code

Round 4 - Technical 

(5 Questions)

  • Q1. What is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

    • It emphasizes code readability and uses indentation to define code blocks.

    • Python has a large standard library and a vibrant community of developers.

    • Example: print('Hello, World!')

    • Example: import pandas as pd

  • Answered by AI
  • Q2. What is python used for?
  • Ans. 

    Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.

    • Data analysis and visualization

    • Web development (Django, Flask)

    • Artificial intelligence and machine learning (TensorFlow, PyTorch)

    • Automation and scripting

    • Scientific computing (NumPy, SciPy)

  • Answered by AI
  • Q3. What type of language is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is an interpreted language, meaning it does not need to be compiled before running.

    • It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

    • Python has a large standard library and a thriving community, making it versatile and widely used.

    • Example: Python is used for web develop...

  • Answered by AI
  • Q4. What is oops in python?
  • Ans. 

    Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.

    • OOP allows for the organization of code into reusable components called classes.

    • Classes can have attributes (variables) and methods (functions) associated with them.

    • In Python, everything is an object, and classes can be defined using the 'class' keyword.

    • Encapsulation, inheritance, and polymorph

  • Answered by AI
  • Q5. What is array in python?
  • Ans. 

    An array in Python is a data structure that stores a collection of elements of the same type.

    • Arrays can store elements such as integers, floats, or strings.

    • Arrays are indexed starting from 0, with elements accessed using their index.

    • Example: arr = ['apple', 'banana', 'cherry']

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy Data Analyst interview:
  • Advanced Excel
  • SQL Server
  • Python
Interview preparation tips for other job seekers - online interview

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Joins and basics
Round 2 - Case Study 

Netflix user churn case study,
Uber booking number reduce

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Coding Test 

SQL and Python data analysis questions

Round 2 - Technical 

(1 Question)

  • Q1. How do you match the data in different columns.
  • Ans. 

    Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.

    • Use string matching techniques like exact match, partial match, or fuzzy matching.

    • Apply data cleaning and preprocessing techniques to standardize the data before matching.

    • Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

    • Consider using database join...

  • Answered by AI

CARS24 Interview FAQs

How many rounds are there in CARS24 Data Analyst interview?
CARS24 interview process usually has 4 rounds. The most common rounds in the CARS24 interview process are Aptitude Test, Technical and One-on-one Round.
How to prepare for CARS24 Data Analyst interview?
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 CARS24 . The most common topics and skills that interviewers at CARS24 expect are SQL, Data Analysis, Excel, Python and Data Analytics.
What are the top questions asked in CARS24 Data Analyst interview?

Some of the top questions asked at the CARS24 Data Analyst interview -

  1. Some technical questions related to sql and advance exce...read more
  2. Some questions related to cars insurance and second c...read more

Tell us how to improve this page.

CARS24 Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
CARS24 Data Analyst Salary
based on 46 salaries
₹3.6 L/yr - ₹10 L/yr
At par with the average Data Analyst Salary in India
View more details

CARS24 Data Analyst Reviews and Ratings

based on 13 reviews

4.2/5

Rating in categories

3.7

Skill development

4.1

Work-life balance

3.9

Salary

4.0

Job security

4.0

Company culture

3.7

Promotions

4.2

Work satisfaction

Explore 13 Reviews and Ratings
Retail Associate
685 salaries
unlock blur

₹1.9 L/yr - ₹4.8 L/yr

Evaluation Engineer
459 salaries
unlock blur

₹1.4 L/yr - ₹4.8 L/yr

Team Lead
440 salaries
unlock blur

₹2 L/yr - ₹10.3 L/yr

Retail Manager
428 salaries
unlock blur

₹2.4 L/yr - ₹7.2 L/yr

Senior Retail Associate
304 salaries
unlock blur

₹2.3 L/yr - ₹6 L/yr

Explore more salaries
Compare CARS24 with

Mahindra First Choice Wheels

3.8
Compare

Truebil

3.8
Compare

Udaan

3.9
Compare

Indiamart Intermesh

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview