Data Engineer Interview Questions

Big Data Engineer

Interviewed at Nielsen

3★

Jun 20, 2018

What is the difference between a map and a flatMap in Scala

Data engineer 2

Interviewed at Recorded Future

3.6★

Jun 14, 2021

Q: How big of a dataset have you worked with before in your projects

Data Engineer

Interviewed at HealthVerity

3.1★

Jul 26, 2017

What is a dual eligibility?

Data Engineer

Interviewed at Tipalti

3.3★

Feb 18, 2023

Bellow is a table called fact_daily_users, which contains the users who were active on a specific date with the specific action they have made (aggregate total actions per row). user_id | date | action| total_actions| day_in_row 332 |17/06| view | 1 | 1 332 |20/06| view | 6 | 1 332 |20/06| click | 2 | 1 221 |24/06| view | 4 | 1 221 |24/06| click | 2 | 1 221 |21/06| view | 1 | 2 221 |20/06| view | 1 | 1 332 |21/06| view | 4 | 2 332 |21/06| click | 3 | 2 Q1: write a query that calculates the logic of day_in_row field with SQL, no joins are allowed. "day_in_row" shows consecutive days for user - users that return day after day to the website per row. Q2: write a function (Python / Java) that gets sql query and returns the output in json object

Data Engineer

Interviewed at TD

3.8★

Sep 10, 2025

What is Integration Runtime in azure?

Data Engineer

Interviewed at Scotiabank

3.8★

May 30, 2023

Python 1. How to remove duplicates 2. Words frequency in a dictionary 3. Multiple Constraints based dictionary questions SQL 1. Find the time between next station for a train

Data Engineer

Interviewed at Bayer

3.9★

Oct 2, 2022

How would you use Python to flatten a JSON object?

Data Warehouse Data Engineer

Interviewed at DISH

2.7★

Feb 10, 2023

Aws - Boto3 SQL - Case Satement - Mod function - Qualify Row Number - Checksum Unix - Find hidden files within a folder Tons of behavioral questions

Senior Data Engineer

Interviewed at Pluralsight

2.9★

Mar 9, 2022

1) Imagine you are data modeling Netflix and create the entities and relationships involved using a modeling tool. 2) follow a link to a sql tool which shows 4 tables. Run some provided sql to populate the tables, Create the sql to aggregate the data and provide a result set showing the top row.

Data Engineer

Interviewed at Meta

3.5★

Oct 28, 2015

Query a many to many relationship while not violating the grain of a fact table.