Upload Button Icon Add office photos
Engaged Employer

i

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

Testbook.com Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Testbook.com Data Engineer Interview Questions and Answers

Updated 22 Sep 2024

Testbook.com Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 22 Sep 2024

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

I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Spark related questions
  • Q2. Previous projects done
  • Ans. 

    Developed a real-time data processing system for a retail company to optimize inventory management.

    • Designed and implemented data pipelines to ingest, process, and analyze large volumes of data

    • Utilized technologies like Apache Kafka, Spark, and Hadoop for real-time processing

    • Built dashboards and reports for stakeholders to monitor inventory levels and make data-driven decisions

  • Answered by AI

Interview questions from similar companies

I applied via Job lever and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Easy leetcode code 2 questions , HTML5 css javascript simple screen design

Round 2 - One-on-one 

(1 Question)

  • Q1. Oop, Simple coding javascript, react basic, sql basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Take it easy and go with confidence which matters most

I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Question was moderate.based on logical reasoning and math.

Round 2 - Coding Test 

Coding test question based on sql and python.

Interview Preparation Tips

Interview preparation tips for other job seekers - if u have good knowledge on python ,machine learning and sql, then u can easily crack the exam.

Data Analyst Interview Questions & Answers

BYJU'S user image Aashutosh Goyal

posted on 13 Oct 2023

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

I applied via Referral and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Basic Skillset questions
  • Q2. Projects worked on
Round 3 - One-on-one 

(1 Question)

  • Q1. Knowledge on Marketing tools and case scenarios
Round 4 - Technical 

(1 Question)

  • Q1. SQl Queries, Previous projects
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Sql, numpy, pandas, dictionary, pandas group by, merging

Round 2 - One-on-one 

(1 Question)

  • Q1. Normal questions

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 minutes
Round difficulty - Easy

It was a mix of mathematical aptitude, logical ability, and puzzles along with 2 programming questions of easy and medium level. Time was enough and no sectional time was present. 1-2 MCQs on SQL were also present.

This round was immediately followed by an SHL aptitude test which was basically a quick limited time check of your verbal ability and math because many questions were to be done in 1 hour.

  • Q1. 

    Boolean Matrix Transformation Challenge

    Given a 2-dimensional boolean matrix mat of size N x M, your task is to modify the matrix such that if any element is 1, set its entire row and column to 1. Specifi...

  • Ans. 

    Modify a boolean matrix such that if any element is 1, set its entire row and column to 1.

    • Iterate through the matrix and mark rows and columns to be modified

    • Use additional arrays to keep track of rows and columns to be modified

    • Update the matrix in-place based on the marked rows and columns

  • Answered by AI
Round 2 - Video Call 

Round duration - 60 minutes
Round difficulty - Easy

It was an online video interview round on HackerEarth with simultaneous code option. It was mostly justifying your resume in the first 15 minutes. After that OOPS was majorly asked. Basics of programming including questions on STL were asked. A class which required inheritance was asked by the interviewer to write. I was helped by the interviewer if i got stuck somewhere, Some questions on implementation of hashmaps and priority queues were also asked. A puzzle was asked which luckily struct to me at that moment.

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Dronacharya College of Engineering. I applied for the job as Software Engineer in DelhiEligibility criteria7 CGPAToppr interview preparation:Topics to prepare for the interview - DBMS, OOPS, Data structures, Dynamic Programming, Graphs, Algorithms, Sorting searching, Compiler designTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Never give up
Tip 2 : When u start a topic, don't move on to next topic before you are 100% confident in previous topic
Tip 3 : Try to give maximum time on basics of a topic especially OOPS
Tip 4 - Practice Atleast 250 Questions
Tip 5 - Ex- Do atleast 2 projects

Application resume tips for other job seekers

Tip 1 : Write only those things in resume in which you are 100% confident
Tip 2 : Write maximum projects you have and be ready to explain them thoroughly
Tip 3 : Don't make any silly spelling mistakes on resume

Final outcome of the interviewSelected

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Apr 2024. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is List comprehension? Print Fibonacci series in python.
  • Ans. 

    List comprehension is a concise way to create lists in Python. Fibonacci series can be printed using list comprehension.

    • List comprehension is a compact way to create lists in Python by iterating over an iterable object.

    • Fibonacci series can be generated using list comprehension by defining the series logic within the comprehension.

    • Example: fibonacci = [0, 1] + [fibonacci[i-1] + fibonacci[i-2] for i in range(2, 10)]

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. You have two table. Employee and salary. Join the table and fetch the 3rd highest salary
Round 3 - Case Study 

Customer segmentation on Sales Data

Round 4 - One-on-one 

(1 Question)

  • Q1. Psychological questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Round 2 - Technical 

(1 Question)

  • Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Question based on Window Functions in sql
  • Q2. Order of execution
  • Ans. 

    Order of execution refers to the sequence in which operations are carried out in a program or system.

    • Execution starts from the top of the program and moves downwards.

    • Operations within parentheses are executed first.

    • Multiplication and division are executed before addition and subtraction.

    • Functions are executed when they are called.

    • Control structures like loops and conditionals affect the order of execution.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
  • Ans. 

    Use a SQL query to find different routes for an airline based on source and destination columns in a table.

    • Use a SELECT statement to retrieve the distinct combinations of source and destination.

    • Use the DISTINCT keyword to ensure only unique routes are returned.

    • Order the results by source and destination for easier analysis.

  • Answered by AI
  • Q2. Situational questions based on Business KPI
Round 3 - Behavioral 

(1 Question)

  • Q1. Simple discussion on the role and company culture
Round 4 - Head Of Analytics round 

(1 Question)

  • Q1. Case study question
Round 5 - HR 

(1 Question)

  • Q1. Basic Discussion on relocation and interest in joining the company.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewers were friendly but the level of interview for technical round was above moderate. SQL proficiency is must.

Skills evaluated in this interview

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

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Round 2 - Technical 

(1 Question)

  • Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...
Round 3 - HR 

(1 Question)

  • Q1. Was asked basic HR questions

Interview Preparation Tips

Topics to prepare for Simplilearn Data Analyst interview:
  • SQL
  • Python
  • Excel
  • Case Studies
Contribute & help others!
anonymous
You can choose to be anonymous

Testbook.com Interview FAQs

How many rounds are there in Testbook.com Data Engineer interview?
Testbook.com interview process usually has 1 rounds. The most common rounds in the Testbook.com interview process are Technical.

Recently Viewed

INTERVIEWS

Testbook.com

No Interviews

DESIGNATION

JOBS

Chandigarh University

No Jobs

LIST OF COMPANIES

H J Software

Locations

JOBS

ManTech Publications

No Jobs

LIST OF COMPANIES

DOT1 Solutions

Locations

JOBS

Nextasy Technologies

No Jobs

JOBS

Business Innovations

No Jobs

JOBS

SunTec Web Services

No Jobs

SALARIES

SunTec Web Services

Tell us how to improve this page.

Testbook.com Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

BYJU'S Interview Questions
3.1
 • 2.1k Interviews
Planet Spark Interview Questions
3.7
 • 359 Interviews
Unacademy Interview Questions
3.0
 • 206 Interviews
upGrad Interview Questions
3.7
 • 198 Interviews
NxtWave Interview Questions
3.8
 • 177 Interviews
Simplilearn Interview Questions
3.2
 • 101 Interviews
Skill Lync Interview Questions
3.1
 • 90 Interviews
LEAD School Interview Questions
3.3
 • 86 Interviews
Teachnook Interview Questions
3.2
 • 85 Interviews
Scaler Academy Interview Questions
3.7
 • 82 Interviews
View all
Testbook.com Data Engineer Salary
based on 13 salaries
₹8 L/yr - ₹20 L/yr
24% more than the average Data Engineer Salary in India
View more details
Senior Business Development Associate
136 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

SME
129 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Associate
116 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Executive
70 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
60 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Testbook.com with

BYJU'S

3.1
Compare

Unacademy

3.0
Compare

upGrad

3.7
Compare

MeritNation

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