Upload Button Icon Add office photos

Zoomcar

Compare button icon Compare button icon Compare

Filter interviews by

Zoomcar Data Engineer Interview Questions and Answers

Updated 14 Oct 2023

Zoomcar Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Oct 2023

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

I applied via Approached by Company and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Given unsorted array find the subarray with given sum
  • Ans. 

    Find subarray with given sum in an unsorted array

    • Use a sliding window approach to iterate through the array

    • Keep track of the current sum and adjust the window based on the sum

    • Return the subarray when the sum matches the given sum

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. What is partitioning and how it works
  • Ans. 

    Partitioning is the process of dividing a large dataset into smaller, more manageable parts based on certain criteria.

    • Partitioning helps in improving query performance by allowing parallel processing of data

    • It can be done based on date, region, or any other relevant criteria

    • Examples include partitioning a sales database by year or partitioning a log file by date

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. Why do you want to move away from current role

Interview Preparation Tips

Interview preparation tips for other job seekers - just be calm and discuss the problem with the interviewers.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain Joins in SQL?
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column between them

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • INNER JOIN returns rows when there is at least one match in both tables

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table

    • ...

  • Answered by AI
  • Q2. What is Normalisation?
  • Ans. 

    Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalisation involves breaking down data into smaller, more manageable tables

    • It helps in reducing data redundancy by storing data in a structured way

    • It improves data integrity by ensuring that each piece of data is stored in only one place

    • Normalization is usually done in multiple stages (1NF, 2NF, 3NF, etc.) t...

  • Answered by AI
Round 2 - Coding Test 

Questions mostly revolved around pandas and numpy.

Interview Preparation Tips

Topics to prepare for Vogo Automotive Data Analyst interview:
  • SQL
  • Pandas

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected
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 - Coding Test 

Sql test in Hackerrank

Round 3 - One-on-one 

(1 Question)

  • Q1. Questions on SQL was asked
Round 4 - One-on-one 

(1 Question)

  • Q1. Managerial round. I was asked questions on case study for captain acquisition
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
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 

Test duration of 1 hour based on probability and control statements

Round 3 - Technical 

(2 Questions)

  • Q1. Ml algorithms that you have prior knowledge about
  • Ans. 

    I have prior knowledge about various machine learning algorithms.

    • Linear Regression

    • Logistic Regression

    • Decision Trees

    • Random Forests

    • Support Vector Machines

    • Naive Bayes

    • K-Nearest Neighbors

    • Gradient Boosting

    • Neural Networks

  • Answered by AI
  • Q2. Data visualization techniques you have studied and used
  • Ans. 

    I have studied and used various data visualization techniques including bar charts, line graphs, scatter plots, and heat maps.

    • I have experience creating bar charts to compare data across categories

    • I have used line graphs to show trends over time

    • I have created scatter plots to identify correlations between variables

    • I have used heat maps to visualize data density and identify patterns

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - learn statistics and python for visualization. learn SQL for data queries

Skills evaluated in this interview

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

I applied via Job Portal and was interviewed before Jun 2022. There were 2 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 - One-on-one 

(1 Question)

  • Q1. Previous company experience and current company roles and responsibilities
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Aug 2023. There were 3 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 - Coding Test 

I'm knowlege of c language

Round 3 - One-on-one 

(2 Questions)

  • Q1. Aney question of c language
  • Q2. And data base and etc

Interview Preparation Tips

Interview preparation tips for other job seekers - I'm knowlege of knowledge management and computer networks
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. SQL related questions like joins
  • Q2. Types of join in sql
  • Ans. 

    Types of join in SQL include inner join, left join, right join, and full outer join.

    • Inner join returns only the matching records from both tables.

    • Left join returns all records from the left table and the matching records from the right table.

    • Right join returns all records from the right table and the matching records from the left table.

    • Full outer join returns all records when there is a match in either the left or rig

  • Answered by AI
  • Q3. Practical use of left join
  • Ans. 

    A left join is used to combine data from two tables based on a common column, including all records from the left table.

    • Left join returns all rows from the left table and the matching rows from the right table.

    • It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.

    • The result of a left join will have NULL values in the columns from the right table where th...

  • Answered by AI
  • Q4. Number of rows after applying certain join operations
  • Ans. 

    The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.

    • Inner join retains only the rows that have matching values in both tables

    • Left join retains all rows from the left table and the matched rows from the right table

    • Right join retains all rows from the right table and the matched rows from the left table

    • Full outer join retains all rows when there is a

  • Answered by AI
  • Q5. Difference between vlookup in excel and some function in sql
  • Ans. 

    VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.

    • VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.

    • VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Simple SQL & Excel test

Round 2 - One-on-one 

(1 Question)

  • Q1. Will Face hiring Manager
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

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

Round 1 - Coding Test 

Test was based on SQL, coding and MCQ. Coding involved nested query.

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

I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

3 questions easy-medium level leetcode problem I solved 2 completely and 3rd question partially (9/15 test cases passed) to move on to 2nd round

Round 2 - Coding Test 

(1 Question)

  • Q1. Implement an app similar to splitwise

Zoomcar Interview FAQs

How many rounds are there in Zoomcar Data Engineer interview?
Zoomcar interview process usually has 4 rounds. The most common rounds in the Zoomcar interview process are Technical, Resume Shortlist and HR.
How to prepare for Zoomcar Data Engineer 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 Zoomcar. The most common topics and skills that interviewers at Zoomcar expect are SQL, Big Data, Data Management, Data Warehousing and Kafka.
What are the top questions asked in Zoomcar Data Engineer interview?

Some of the top questions asked at the Zoomcar Data Engineer interview -

  1. given unsorted array find the subarray with given ...read more
  2. what is partitioning and how it wo...read more

Tell us how to improve this page.

Zoomcar Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 428 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
Myntra Interview Questions
4.0
 • 214 Interviews
Blinkit Interview Questions
3.7
 • 181 Interviews
BlackBuck Interview Questions
3.8
 • 176 Interviews
Spinny Interview Questions
3.7
 • 170 Interviews
FirstCry Interview Questions
3.6
 • 169 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
Digit Insurance Interview Questions
4.0
 • 142 Interviews
View all
Zoomcar Data Engineer Salary
based on 7 salaries
₹14.5 L/yr - ₹47 L/yr
221% more than the average Data Engineer Salary in India
View more details
Team Lead
59 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Fleet Executive
53 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
39 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
33 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Executive
33 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Zoomcar with

Revv

3.7
Compare

Drivezy

3.5
Compare

Myles Cars

4.6
Compare

Carzonrent

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