Upload Button Icon Add office photos
Premium Employer

i

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

Delhivery Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Delhivery Production Analyst Interview Questions and Answers

Updated 22 Jan 2024

Delhivery Production Analyst Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed in Dec 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Sql questions basic and window functions
  • Q2. Explain analysis already done
  • Ans. 

    The analysis already done includes market research, competitor analysis, and user feedback analysis.

    • Market research was conducted to understand the target market, customer needs, and market trends.

    • Competitor analysis was performed to identify the strengths and weaknesses of competitors and their products.

    • User feedback analysis was done to gather insights from customers regarding the product's features, usability, and s

  • Answered by AI
Round 2 - Case Study 

Uber matching algorithm and what metrics would you choose

Round 3 - One-on-one 

(1 Question)

  • Q1. Case study question based on existing projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Know sql. Organise and explain yout thoughts during an analysis

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. What is the mean of DHL. ( full form).
  • Ans. 

    DHL stands for Dalsey, Hillblom, and Lynn, the surnames of the founders. It is a global logistics company.

    • DHL is a multinational courier, parcel, and express mail service.

    • It was founded in 1969 by Adrian Dalsey, Larry Hillblom, and Robert Lynn.

    • DHL provides services for shipping, tracking, and delivering packages worldwide.

    • The mean of DHL refers to the average or central tendency of the company's operations, such as rev...

  • Answered by AI

Interview Questionnaire 

1 Question

  • Q1. What could be the possible reasons for delay in delivery?
  • Ans. 

    Possible reasons for delay in delivery

    • Logistical issues such as traffic or weather

    • Inadequate inventory management

    • Production delays

    • Customs clearance delays

    • Incorrect address or contact information

    • Technical issues with delivery vehicles or equipment

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and give detailed ans of every questions asked. Don't be hesitant in cross questioning them.

Interview Questionnaire 

2 Questions

  • Q1. Safety related questions were asked..
  • Q2. U must have full knowledge of axcel.

I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tableau, Power Bi , Advance Excel Questions and experience with respect to Supply chain process like Warehousing, inventory management, ABC Analysis, Fast and Slow moving Goods, End to end order creation ...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Calm and Be true, share your project experience from Supply Chain management
And used technical terms to explain your project execution
Be true if you dont know the answer, it will lead to good experience at last

I applied via Recruitment Consultant and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Questions were related to advance sql like stored procedure, view, trigger, windows function in SQL.
  • Q2. Scenario based question related to DAX and sql queries.
  • Q3. Why we use stored procedures, trigger ?
  • Ans. 

    Stored procedures and triggers are used to improve database performance and maintain data integrity.

    • Stored procedures allow for precompiled SQL statements, reducing processing time.

    • Triggers can automatically enforce business rules and maintain data consistency.

    • Both stored procedures and triggers can improve security by limiting direct access to the database.

    • Examples of triggers include auditing changes to a table or au...

  • Answered by AI
  • Q4. Applying filter in power BI, basic concepts should be strong.

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics of power BI and good knowledge of SQL required to clear the interview.
Good hands on required on windows function in sql.
Practice DAX as much as possible.
All the best ??

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Highlight min & Max sales for each year in tableau.
  • Ans. 

    Use Tableau to highlight the minimum and maximum sales for each year.

    • Create a new worksheet in Tableau

    • Drag the 'Year' field to the Columns shelf

    • Drag the 'Sales' field to the Rows shelf

    • Drag the 'Sales' field again to the Color shelf

    • Right-click on the 'Sales' field in the Color shelf and select 'Measure' > 'Min'

    • Right-click on the 'Sales' field in the Color shelf again and select 'Measure' > 'Max'

    • Format the visualization

  • Answered by AI

Skills evaluated in this interview

Round 1 - One-on-one 

(2 Questions)

  • Q1. Show me the PowerBi Data Relations
  • Ans. 

    PowerBI Data Relations show how tables are related to each other in a data model.

    • Data relations are created by linking columns between tables.

    • One table can have multiple relationships with other tables.

    • Data relations can be one-to-one, one-to-many, or many-to-many.

    • PowerBI automatically detects and creates relationships based on column names.

    • Data relations can be edited and managed in the Relationship view.

  • Answered by AI
  • Q2. Python code issue resolve

Interview Preparation Tips

Interview preparation tips for other job seekers - Strict Interviews. Be sure what you speak. Technically they seek every information. They see What you know ,how you look for problem solving.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Case Study 

Talk to the head hunter. General phone screening

Round 2 - One-on-one 

(1 Question)

  • Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Round 3 - Case Study 

Shared a dataset and wanted me to provide some insights and also build some slides to present

Interview Preparation Tips

Interview preparation tips for other job seekers - better to ask about the team structure and also training, career development
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Aptitude Test 

First round was aptitude test,duration is of 25 minutes involves SQL,PowerBI,Python, Qunatitative Aptitude,SAS skillset

Delhivery Interview FAQs

How many rounds are there in Delhivery Production Analyst interview?
Delhivery interview process usually has 3 rounds. The most common rounds in the Delhivery interview process are One-on-one Round and Case Study.
How to prepare for Delhivery Production 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 Delhivery. The most common topics and skills that interviewers at Delhivery expect are Analysis, Analytics, Business operations, Computer science and Data Analytics.
What are the top questions asked in Delhivery Production Analyst interview?

Some of the top questions asked at the Delhivery Production Analyst interview -

  1. Explain analysis already d...read more
  2. Case study question based on existing proje...read more
  3. Sql questions basic and window functi...read more

Tell us how to improve this page.

Delhivery Production Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Maersk Interview Questions
4.2
 • 200 Interviews
Ecom Express Interview Questions
3.8
 • 197 Interviews
XpressBees Interview Questions
3.6
 • 159 Interviews
DTDC Express Interview Questions
3.7
 • 151 Interviews
Blue Dart Express Interview Questions
4.0
 • 102 Interviews
FedEx Express Interview Questions
4.0
 • 93 Interviews
GATI-KWE Interview Questions
3.9
 • 86 Interviews
DHL Express Interview Questions
4.1
 • 62 Interviews
View all
Delhivery Production Analyst Salary
based on 16 salaries
₹10 L/yr - ₹14.5 L/yr
15% more than the average Production Analyst Salary in India
View more details

Delhivery Production Analyst Reviews and Ratings

based on 2 reviews

3.4/5

Rating in categories

3.8

Skill development

4.4

Work-life balance

3.1

Salary

3.8

Job security

2.4

Company culture

3.1

Promotions

2.8

Work satisfaction

Explore 2 Reviews and Ratings
Team Lead
1.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive
1.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
723 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
684 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
621 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Delhivery with

Blue Dart Express

4.0
Compare

Ecom Express

3.8
Compare

GATI-KWE

3.9
Compare

DTDC Express

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