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.
Various Python, Snowflake, and dbt questions. More heavily weighted to Python, as noted above. Some ETL vs ELT and OLAP vs OLTP 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 2031 - 2040 interview questions