1. Given the sample: id, status 1, active 2, active 3, active 4, pending 5, expired 6, expired 7, expired 8, pending Pull the unique statuses that show up consecutively 3 times, e.g. from the sample, the output would be 'active', 'expired'. 2. Given the sample: employee, in_out, time A, IN, 6:00 B, IN, 7:00 A, OUT, 8:00 C, IN, 9:30 A, IN, 9:00 A, OUT, 10:00 B, OUT, 11:00 C, OUT, 10:00 Determine which employees are in the building at 10:30.
Sr Data Engineer Interview Questions
2,266 sr data engineer interview questions shared by candidates
If you take 3 subsequent number (n, n+1, n+2) and know, that n and n+2 are prime numbers, can you proove, that n+1 is always dividable by 6?
try to get a pattern out of string or json. ask you to translate numbers from 1 to 100 to names of numbers ( for example 34 translated to thirty-four). you need to come with a solution within 10 seconds, I am able to get it done within 2 minutes. That's not fast enough.
2 Sum
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.
The percentage of female customer base
They answered no questions I sent over and sent my own questions back to me. So that was mighty pathetic too.
phone screen for SQL: Give data model - solve various SQL questions Python: list and dict manipulation
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
Why and how high bottom hole temperature could affect the hydrostatic pressure gradients
Viewing 1 - 10 interview questions