I was first contacted by a recruiter through LinkedIn for this position, followed by a phone screening.

I thought the second round would be a behavioral interview, but instead it was a technical interview. I could not understand the interviewer, and they were late. The coordinator supplied materials ahead of the interview, but they were only relevant for behavioral interviews. My interviewer showed up late, and I was shorted 15 minutes in the interview, presumably due to unsatisfactory performance on the coding test. According to the interview materials, "Our interviews are rooted in behavioral-based questions.....We avoid brain teasers....", but they nevertheless administered a brain teaser (aka coding test).

1. Given the following 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 three times. For example, from the sample, the output would be 'active', 'expired'.

1. Given the following 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.