Upload Button Icon Add office photos

Filter interviews by

Egon Zehnder International Big Data Engineer Interview Questions and Answers

Updated 12 Nov 2024

Egon Zehnder International Big Data Engineer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What was your last projecy?
Round 2 - One-on-one 

(1 Question)

  • Q1. Questions based on project.
Round 3 - One-on-one 

(1 Question)

  • Q1. Managerial questions

Interview Preparation Tips

Interview preparation tips for other job seekers - The process was pretty easy with project discussions at the helm and a few technical questions here and there.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Project related discussions
  • Q2. Meduim level SQl and DSA
Round 2 - One-on-one 

(2 Questions)

  • Q1. This was data modelling round
  • Q2. Design a uber data model
  • Ans. 

    Uber data model design for efficient storage and retrieval of ride-related information.

    • Create tables for users, drivers, rides, payments, and ratings

    • Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

    • Establish relationships between tables using foreign keys

    • Implement indexing for faster query performance

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQl, Python and data modeling

Skills evaluated in this interview

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

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

Round 1 - Aptitude Test 

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Round 2 - Technical 

(2 Questions)

  • Q1. What is DSA , sorting , difference between array and linked list
  • Ans. 

    DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.

    • DSA stands for Data Structures and Algorithms

    • Sorting is the process of arranging data in a particular order

    • Arra...

  • Answered by AI
  • Q2. Written a SQL query
Round 3 - HR 

(2 Questions)

  • Q1. Coding question like add numbers
  • Q2. Experience on your project
  • Ans. 

    I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.

    • Developed predictive models to forecast customer behavior and optimize marketing strategies

    • Conducted market research to identify trends and opportunities for growth

    • Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns

  • Answered by AI

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Power BI Difference between ALL() and ALLSELECTED()
  • Ans. 

    ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.

    • ALL() removes all filters from the specified column or table.

    • ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

    • Example: ALL('Table') would remove all filters on the 'Table' in the query context.

    • Example: ALLSELECTED('Column') would remove filte...

  • Answered by AI
  • Q2. Excel Difference between COUNT() and COUNTA()
  • Ans. 

    COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.

    • COUNT() counts only cells with numerical values.

    • COUNTA() counts all non-empty cells, including text and errors.

    • Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset questions

Skills evaluated in this interview

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

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

Round 1 - Coding Test 

Maxium sub string and reverse a string

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

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Basics of power bi and sql
  • Q2. What are joins and types of join
  • Q3. How to add date table in power bi
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question
Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. How good are you with numbers
Round 2 - Technical 

(1 Question)

  • Q1. Vlookup, pivot table, sumif, average, graphs
Round 3 - Behavioral 

(1 Question)

  • Q1. Do you know the role and responsibility of this position
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is the number of tourist per day in jaipur
  • Ans. 

    The number of tourists per day in Jaipur varies depending on the season and events happening in the city.

    • Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

    • Events like festivals or cultural events can attract more tourists

    • Historical sites like Amer Fort and Hawa Mahal are popular attractions

    • Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Expected salary
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Almost everything on Power BI
Round 2 - One-on-one 

(1 Question)

  • Q1. Behavioral skills

Egon Zehnder International Interview FAQs

How many rounds are there in Egon Zehnder International Big Data Engineer interview?
Egon Zehnder International interview process usually has 3 rounds. The most common rounds in the Egon Zehnder International interview process are One-on-one Round.

Tell us how to improve this page.

Egon Zehnder International Big Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

BCG Interview Questions
3.8
 • 196 Interviews
Citco Interview Questions
3.1
 • 139 Interviews
Bain & Company Interview Questions
3.8
 • 103 Interviews
Blackrock Interview Questions
3.8
 • 100 Interviews
WSP Interview Questions
4.2
 • 89 Interviews
Mercer Interview Questions
3.7
 • 80 Interviews
Gartner Interview Questions
4.2
 • 78 Interviews
Protiviti Interview Questions
3.2
 • 56 Interviews
View all
Research Analyst
87 salaries
unlock blur

₹3.2 L/yr - ₹8 L/yr

Senior Research Analyst
53 salaries
unlock blur

₹5.5 L/yr - ₹18 L/yr

Operations Research Analyst
39 salaries
unlock blur

₹3.8 L/yr - ₹7 L/yr

Data Quality Analyst
35 salaries
unlock blur

₹2.7 L/yr - ₹5.4 L/yr

Senior IT Analyst
34 salaries
unlock blur

₹9 L/yr - ₹21.6 L/yr

Explore more salaries
Compare Egon Zehnder International with

Korn Ferry

3.3
Compare

Spencer Stuart

3.1
Compare

Heidrick & Struggles

2.3
Compare

Russell Reynolds Associates

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