write sql query and then python code for a table of events and return a pivot like response for certain values.
Senior Data Engineer Interview Questions
2,442 senior data engineer interview questions shared by candidates
1) Merge overlapping Intervals (had done in 10 mints) 2) Spark questions like inferschema, mergeschema, how spark works, partitioning, small file problem. All questions I had answered accurately but they still rejected either I was too good for them. LOL
Past experiences, technologies.
Design top trending, continue watching
Design data audit system
O que faria mudar de empresa hoje?
No structure nothing , they will Google it just before the interview. You will be better off reading first five google links
Tell me about a time where you had to go out of your comfort zone to deliver something.
Previous data engineering experience, data pipelines and tech stack related questions.
Times X{open, close} , Y{open, close} rec_type, status, time x1, open, 930 x1, close 1030 x2, open, 1035 y1, open, 1040 y2, open, 1041 x2, close, 1100 x3, open, 1110 x3, close, 1115 y1, close, 1120 y2, close, 1121 |---x1, open, 930 |---x1, close 1030 |-----x2, open, 1035 | y1, open, 1040----| | y2, open, 1041 ---+---| |-----x2, close, 1100 | | |---x3, open, 1110 | | |---x3, close, 1115 | | y1, close, 1120---| | y2, close, 1121-------| Find the pairs of x-type and y-type where they have any time overlap between them.
Viewing 1941 - 1950 interview questions