The interview consists of two rounds:
1st Phone interview for 30 mins: Very basic, just to filter out complete newbies I guess
- Tell me about what you are doing right now
- What's the diff between union and union all
- Basic T-SQL
2nd Onsite: Back to back 4 interviews:
2a. Technical with 2 low level engineers (future team peers) - 1 hour
2b. Just overall talk with "Project Lead" (described by himself) - 30 mins
2c. General + Technical talk with Data Scientist - 30 mins
2d. Another senior level manager (was absent the interview day) - 30 mins
2a: It was very weird, two engineers came to interview room, and they acted as if they were not allowed to talk or something, they showed complete lack of interviewing or social skills. That was a red flag. From the experience, I know that when you see a company with unhappy employees, just run, compensation, package - not worth it.
Technical details: They bring a laptop, give you one CSV file and ask you to build and ETL and dimensional data warehouse and give you 45 minutes. I was like: eh, excuse me?
2b. "Project lead" - I can't stand managers who try to seem tougher than they really are. He started by saying he is the project lead, oversees everything, I asked, what exactly, he said this whole thing (whatever that means). Long story short, it is a 30-min conversation with someone who looks into your eyes for 30 mins, reminds of a detective/criminal interaction in a closed room.
2c. The only "sane" person I talked to in this company, more technical, knows what he is doing and what he is asking, without loud titles and stuff. It was just a mixed technical/personal - tell me what you are doing right now, what do you think of python versus sql, ssis etc.
2d. Wasn't there the interview day.
Compensation package: $160K base, some bonus promise, insurance, 401k etc.
No offer, but to be honest, I would not join even if they extended an offer, decided that was not going to join before interview started.
