Senior data engineer Interview Questions | Glassdoor

Senior data engineer Interview Questions

155

senior data engineer interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

The percentage of female customer base

3 Answers

Wrote the SQL query to answer this question

Do you have any details on Python questions?

You need demographics data for this. Query would be fairly simple

phone screen for SQL: Give data model - solve various SQL questions Python: list and dict manipulation

3 Answers

Write a constant-time Python 3 implementation of LRU cache. Use any Python data structures. The provided unit tests must pass. You have 15 minutes.

2 Answers

1. Imagine a table keeping track of all the rides a driver undertakes in a given day. How do you query that table to find out the time when he did not have any rides. So the table may have a record when he picks up his first ride and then he picks another and then drops both of them. After a while he picks up a few more which again is recorded in the table. So with all that how do you find the data when he does not have any rides

2 Answers

Asked a live coding on python. Need to execute the program online after coding. And 2 SQL queries where I need to write the query.

1 Answer

Data modeling question, basic concepts of SDLC, concepts like CI/CD approach. SQL group by vs having, a basic sql script. Coding question involving a Hash table.

1 Answer

How would design a data structure(already existing once )?

2 Answers

One or more comments have been removed.
Please see our Community Guidelines or Terms of Service for more information.

After that a python question to test your skill on recursion and iteration

2 Answers

One or more comments have been removed.
Please see our Community Guidelines or Terms of Service for more information.

CDC/SCD types and implementation with SQL and Hive System design and Python coding on screen (F2F) Values based questions Career goals and the reason for changing job etc.,

1 Answer

python and SQL in telephonic Hadoop input file formats, when to use what, design streaming system, Hive optimization, Spark implementation, Python multi-environment related questions Agile and behavioural rounds

1 Answer
110 of 155 Interview Questions