Upload Button Icon Add office photos

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:
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 - 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
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is difference between dense_rank and rank function
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Netaji Subhas Institute of Technology (NSIT) and was interviewed before Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

It was demure and well balanced.

Round 2 - Technical 

(2 Questions)

  • Q1. Databases based on resume.
  • Q2. Sql based questions
Round 3 - One-on-one 

(2 Questions)

  • Q1. Sql based question
  • Q2. Resume and intern experiences.

Interview Preparation Tips

Interview preparation tips for other job seekers - be thorough with resume.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(1 Question)

  • Q1. Design the generic tool or package using pyspark which allows to create connections to multiple databases like mysql, s3 or api. Fetch the result and do transformations like handling null values and then s...
  • Ans. 

    Design a generic tool in pyspark to connect to multiple databases, fetch results, handle null values, and store output in another database

    • Use pyspark to create a tool that can connect to databases like mysql, s3, or api

    • Implement functions to fetch data from the databases and perform transformations like handling null values

    • Utilize pyspark to store the transformed data in another database

    • Consider using pyspark SQL funct

  • Answered by AI

Skills evaluated in this interview

I applied via I don't remember and was interviewed in Aug 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. About experience DBMS questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't take the job if your gut says the interviewer wasn't polite during the interview.

I dint feel comfortable right from the start of the interview. The interviewer was condescending and not accepting even correct answers and claiming I failed to know basic stuff required for the role. I ended the interview in less than half the time it was scheduled for. I'm sure I don't want to work under such a person who wants to keep rejecting answers and pointing how you did not know answer to a question.

Interview is generally to understand how good the candidate is and how good the company is. After first 5 mins of the call I knew I dint want to work there. He added a team member just to tell him if there was any important thing he had to look into (like that other guy is some kind of service assistant to him).

Even after I accepted I wasn't the right fit for the role and bailed, he again pointed out how I barely knew anything that I should for the role (which is not necessary as the interview is over).
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
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was an online assessment. Some coding questions. Some cs fundamental mcqs. SQL query, Rest Api question.

Round 2 - Assignment 

An assignment to create a game using nodejs/ go lang/ java.

Round 3 - Technical 

(2 Questions)

  • Q1. Discussion related to Assignment. Told some changes and told to add some more functionalities.
  • Q2. Some APIS were given. It was case study. You had to show the dishes to a customer according to his preferences.
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
-
Process Duration
-
Result
Not Selected
Round 1 - Coding Test 

Questions were crayon box ,the bot and the game and happy neighbourhood for 90 mins

Round 2 - Technical 

(2 Questions)

  • Q1. Array basics was asked
  • Q2. Segment tree,prefix sum
Round 3 - Technical 

(1 Question)

  • Q1. Low level design was asked
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Create pagination component using an api show the data for the pages
  • Ans. 

    Create a pagination component using an API to display data for different pages.

    • Use API to fetch data for each page

    • Implement pagination logic to display data for each page

    • Allow users to navigate between pages

  • Answered by AI

Skills evaluated in this interview

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.

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 423 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 323 Interviews
CARS24 Interview Questions
3.6
 • 317 Interviews
BlackBuck Interview Questions
3.8
 • 172 Interviews
Blinkit Interview Questions
3.7
 • 172 Interviews
Tata 1mg Interview Questions
3.7
 • 141 Interviews
Paisabazaar.com Interview Questions
3.5
 • 137 Interviews
Urban Company Interview Questions
3.5
 • 133 Interviews
Ninjacart Interview Questions
4.0
 • 94 Interviews
View all
Zoomcar Data Engineer Salary
based on 7 salaries
₹14.5 L/yr - ₹47 L/yr
224% more than the average Data Engineer Salary in India
View more details
Team Lead
60 salaries
unlock blur

₹2.1 L/yr - ₹4.6 L/yr

Fleet Executive
53 salaries
unlock blur

₹1.8 L/yr - ₹4.2 L/yr

Senior Software Engineer
34 salaries
unlock blur

₹18.7 L/yr - ₹46 L/yr

Software Engineer
33 salaries
unlock blur

₹10 L/yr - ₹29 L/yr

Operations Executive
33 salaries
unlock blur

₹1.9 L/yr - ₹4.2 L/yr

Explore more salaries
Compare Zoomcar with

Revv

3.7
Compare

Drivezy

3.5
Compare

Myles Cars

4.6
Compare

Carzonrent

3.6
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