There was a string parsing question via Python. Just know how to parse a string into words or even letters and to apply some sort of logic to the string.
Data Engineer Interview Questions
20,177 data engineer interview questions shared by candidates
given some sample web UI log data, write a python algorithm to answer various questions
Don't focus only on Leetcode SQL questions. Their questions are more higher level. Prepare for advanced ETL questions. You should write the best solution immediately instead of just writing the solution down.
Show gender, min birthday and max birthdate where a customer bought at least one product
Dot Product with Sparse Vectors, Dot product of sparse vectors stored as hashmaps
How would you design and build a data model to report on active users and number of posts by interface (ipad, iphone, desktop web, etc) given a hierarchy of these interfaces and their rollup groupings, at any and all levels of the hierarchy?
Phone: SQL qs are pretty basic on equi joins, outer joins, and self joins. Coding exercises are pretty basic like word search, etc. Time is a crunch (1hr). You have to keep explaining while coding so that the interviewer online understands your thought process. In Person: Some live coding exercise, tougher than phone qs, product sense, visualization.
Design a relational database for a ride-sharing app.
(After being shown a graph with some data) Can you think of reasons why the data would appear this way?
Viewing 591 - 600 interview questions