Delhivery interview experience Real time questions & tips from candidates to crack your interview
Data Engineer
Delhivery
2 rounds | 5 Coding
problems
Rejected
Interview preparation journey
Journey
I applied for this position through Hirist where the company HR viewed my profile and called me for the details and then interviews were scheduled. I gave 2 rounds of interviews, and I was rejected from the second technical round.
Application story
I applied off-campus by putting my resume online. HR viewed my profile and reached out to me. He explained the process to me. What are the levels in this role and what is the salary structure.
Why selected/rejected for the role?
I had experience in ETL tools but did not know DSA which was asked in round 2. I told the logic and algorithm but they wanted full code.
Preparation
Duration: 1 month
Topics: Pyspark, ETL, SQL, DS Algorithms, Python
Tip 1: Practice DSA questions online.
Tip 2: Read basic theories of data engineering.
Tip 3: Maintain speed while solving.
Application process
Where: Other
Eligibility: No
Tip 1: Mention all tools and skills.
Tip 2: Explain your work experience in detail.
Interview rounds
01
Round
Easy
Telephonic
Duration30 minutes
Interview date11 May 2023
Coding problem3
It was held in the daytime. He asked basics about my work experience and basic problem-solving questions and QA
1. Find an even number
Hard
30m average time
60% success
0/120
Asked in companies
General online puzzles and basic number system questions related to algorithms like how can you find an even number.
Problem approach
Tip 1: Practice puzzles
Tip 2: Communication skills are tested
Tip 3: Practice basic aptitude
2. Coin Challenge: Equalizing Heads
You are blindfolded and 10 coins are placed in front of you on the table. You are allowed to touch the coins but can’t tell which way up they are by feel. You are told that there are 5 coins head up, and 5 coins tails up but not which ones are which. Can you make two piles of coins each with the same number of heads up? You can flip the coins any number of times.
Problem approach
Tip 1: Try to solve
Tip 2: If not solved, explain your thinking process
Tip 3: Try alternatives
3. Checking for Perfect Squares: Code Implementation
Easy
10m average time
90% success
0/40
Asked in companies
How can you check if the number is a perfect square using the code?
Problem approach
Tip 1: Practice DSA
Tip 2: Logic is important
Tip 3: The approach can be different
02
Round
Medium
Video Call
Duration45 minutes
Interview date15 May 2023
Coding problem2
There were 2 rounds in this - SQL coding and DSA coding
1. City routes question based on lead and lag in SQL
Given a city name table, find all the possible distinct routes between all cities
Problem approach
i joined the tables using n=m+1 or m-1 logic
Table : city
City_name
--------------
Delhi
Mumbai
Kolkata
Chennai
O/P :
source destination
---------------------------------
delhi mumbai
delhi kolkata
delhi chennai
mumbai kolkata
mumbai chennai
Kolkata chennai
2. Detecting Stock Price Spikes
Given a table with daily price of a stock. Need to find the day in which spike was observed.
Problem approach
Daily_price
===========
--------------
| Day| Price |
--------------
| 1 | 10 |
| 2 | 12 |
| 6 | 10 |
| 3 | 55 |
| 5 | 77 |
| 4 | 12 |
--------------
Output
=========
| Day|
------
| 3 |
| 5 |
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
SDE - 1
3 rounds | 4 problems
Interviewed by Delhivery
Selected 
1466 views
0 comments
0 upvotes
SDE - 1
3 rounds | 3 problems
Interviewed by Delhivery
Selected 1327 views
0 comments
0 upvotes
SDE - 1
3 rounds | 6 problems
Interviewed by Delhivery
Selected 1228 views
0 comments
0 upvotes
Software Engineer
3 rounds | 3 problems
Interviewed by Delhivery
Selected 1203 views
0 comments
0 upvotes