Upload Button Icon Add office photos
Engaged Employer

i

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

Zupee Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 49 Reviews

Filter interviews by

Zupee Data Engineer Interview Questions and Answers for Experienced

Updated 24 Sep 2023

Zupee Data Engineer Interview Experiences for Experienced

1 interview found

Data Engineer Interview Questions & Answers

user image Vaibhav Ashok Tandale

posted on 24 Sep 2023

Interview experience
4
Good
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 - Technical 

(2 Questions)

  • Q1. How to read parquet and csv file in spark .
  • Ans. 

    To read parquet and csv files in Spark, use SparkSession's read method with appropriate options.

    • Create a SparkSession object

    • Use the read method of SparkSession to read parquet files with .parquet() method

    • Use the read method of SparkSession to read csv files with .csv() method

    • Specify options like header, delimiter, inferSchema, etc. as needed

    • Load the data into a DataFrame for further processing

  • Answered by AI
  • Q2. How to check second highest sallery.
  • Ans. 

    To check the second highest salary, use the SQL query with ORDER BY and LIMIT.

    • Use SQL query with ORDER BY clause to sort salaries in descending order.

    • Use LIMIT 1,1 to select the second highest salary.

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't wait for thing to happen, make things happen, take the initiative to identify and solve peoblem.

Skills evaluated in this interview

Data Engineer Jobs at Zupee

View all

Interview questions from similar companies

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

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

Round 1 - Technical 

(2 Questions)

  • Q1. What is the difference between Union and Union all ?
  • Ans. 

    Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.

    • Union removes duplicate rows from the result set, while Union all includes all rows.

    • Union sorts the result set, while Union all does not.

    • Union is slower than Union all because it performs a distinct operation.

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FRO

  • Answered by AI
  • Q2. Which query is more faster , joins or union?
  • Ans. 

    Joins are generally faster than unions.

    • Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

    • Joins can utilize indexes on the columns being joined, which can improve performance.

    • Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Aristocrat Technologies Data Analyst interview:
  • SQL
  • Power BI
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - One-on-one 

(1 Question)

  • Q1. LLD question on whatsapp
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 Jan 2024. There was 1 interview round.

Round 1 - Coding Test 

Leetcode problem to find the missing number. multiple followback on this. the second problem was dp to find the identity matrix. was rejected after this

Interview experience
3
Average
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 - Coding Test 

Basic coding test like palindrome, series,arrays

Round 3 - One-on-one 

(1 Question)

  • Q1. Logical questions,puzzle, behavioural round, introduction
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Coding Test 

Topological Sort based question and it's follow up

Interview Preparation Tips

Interview preparation tips for other job seekers - NA

I applied via Approached by Company and was interviewed in Feb 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. There is one black king and N number of white knights. You need to find is king under attack and is checkmate?
  • Ans. 

    Check if the black king is under attack and if it is checkmate.

    • Check if any white knight can capture the black king

    • Check if the black king has any legal moves to escape capture

    • If the black king is under attack and has no legal moves, it is checkmate

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not expect to go to next round even if you give o(1) solution for the question they ask. They only asked one question in technical round and I provided solution with o(1) time, even though they rejected. Please don't waste time, I think they also don't know how to hire..

I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Google and Technical Questions

Interview Preparation Tips

Interview preparation tips for other job seekers - I was friendly environment while interview, they will ask you easy and knowledgeable questions. Don't get nervous when you are giving interview in Playerzpot

I applied via Recruitment Consulltant and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - Coding Test 

General coding questions

Round 2 - Technical 

(1 Question)

  • Q1. Related technical question

Interview Preparation Tips

Interview preparation tips for other job seekers - Mid level company, salary is not upto market. Rest is fine.

Zupee Interview FAQs

How many rounds are there in Zupee Data Engineer interview for experienced candidates?
Zupee interview process for experienced candidates usually has 2 rounds. The most common rounds in the Zupee interview process for experienced candidates are Resume Shortlist and Technical.
How to prepare for Zupee Data Engineer interview for experienced candidates?
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 Zupee. The most common topics and skills that interviewers at Zupee expect are Python, Big Data, Hadoop, Spark and Data Warehousing.
What are the top questions asked in Zupee Data Engineer interview for experienced candidates?

Some of the top questions asked at the Zupee Data Engineer interview for experienced candidates -

  1. How to read parquet and csv file in spar...read more
  2. how to check second highest salle...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Dream11 Interview Questions
3.8
 • 36 Interviews
Junglee Games Interview Questions
3.2
 • 32 Interviews
PurpleTalk Interview Questions
3.9
 • 25 Interviews
IDZ Digital Interview Questions
3.8
 • 22 Interviews
Games24x7 Interview Questions
3.8
 • 18 Interviews
WinZO Interview Questions
4.8
 • 14 Interviews
View all

Zupee Data Engineer Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

3.0

Salary & Benefits

4.0

Job Security

4.0

Company culture

3.0

Promotions/Appraisal

4.0

Work Satisfaction

Explore 1 Review and Rating
Software Engineer
25 salaries
unlock blur

₹18 L/yr - ₹27 L/yr

Software Developer
9 salaries
unlock blur

₹16 L/yr - ₹48.2 L/yr

Finance Manager
7 salaries
unlock blur

₹11 L/yr - ₹18 L/yr

Assistant Manager
7 salaries
unlock blur

₹9 L/yr - ₹14.5 L/yr

Data Analyst
7 salaries
unlock blur

₹12.5 L/yr - ₹16 L/yr

Explore more salaries
Compare Zupee with

Dream11

3.8
Compare

Rummy Circle

5.0
Compare

Paytm First Games

3.7
Compare

Mobile Premier League

3.4
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