Sr Data Engineer Interview Questions

2,567 sr data engineer interview questions shared by candidates

Context Given a night with X ride requests and Y available drivers in a fictional city, you have to develop a batch processing application that would aggregate and expose data coming from the matching engine. Every Z seconds, the matching engine tries to match every pair of request and driver that are available in the city. Some are matched, some are not. The results of each matching tick are stored in a set of files. Given this data we want to be able to get a overview of the marketplace health and multiple applications could follow such as heat maps. The metrics that we want to use for heat mapping are driver match rate and request match rate. Exercice Develop a microservice that will: Aggregate matching data by fetching new matching data and exploiting this data in order to aggregate driver match rates and request match rates by geo-spatial units of your choice. Expose an endpoint which return the adjusted values of request and driver match rate, following this formula.. Bonus Plot the driver and request match rate for one night
avatar

Senior/Lead Data Engineer

Interviewed at Heetch

4.2
Dec 24, 2018

Context Given a night with X ride requests and Y available drivers in a fictional city, you have to develop a batch processing application that would aggregate and expose data coming from the matching engine. Every Z seconds, the matching engine tries to match every pair of request and driver that are available in the city. Some are matched, some are not. The results of each matching tick are stored in a set of files. Given this data we want to be able to get a overview of the marketplace health and multiple applications could follow such as heat maps. The metrics that we want to use for heat mapping are driver match rate and request match rate. Exercice Develop a microservice that will: Aggregate matching data by fetching new matching data and exploiting this data in order to aggregate driver match rates and request match rates by geo-spatial units of your choice. Expose an endpoint which return the adjusted values of request and driver match rate, following this formula.. Bonus Plot the driver and request match rate for one night

- Do some basic DB queries with Python. - Study an example AWS cloud architecture, have it explained by a current employee, and talk about how it could be improved. - Normal "Tell me about a time when..." background questions.
avatar

Senior Data Engineer

Interviewed at Omada Health

4.3
May 16, 2022

- Do some basic DB queries with Python. - Study an example AWS cloud architecture, have it explained by a current employee, and talk about how it could be improved. - Normal "Tell me about a time when..." background questions.

Viewing 1511 - 1520 interview questions

Glassdoor has 2,567 interview questions and reports from Sr data engineer interviews. Prepare for your interview. Get hired. Love your job.