To start had a 30 minute phone call with one of their tech recruiters and went over what i was looking for along with what what the role and company was all about. I should start by saying - the mission seem solid, maybe just the folks they have interviewing are trying to serve some self purpose (get their own people in) or just are not experienced enough. Next were all the tech rounds with two members of the data engineering team. First one was with a guy on the data eng team that gave me a couple schemas and had a bunch of sql questions. There are always multiple ways of going about any question - if he wanted something specific he should have asked about it. I answered all the questions correctly and thoughtfully. I constantly checked to ensure he was ok with my solution (which he was) and it made sense. He actually was not really familiar with common concepts in sql (even case statements, as he took 10 mins to try and walk through my solution in his head bc he didnt get it lol). I dont believe he was quite qualified to interview me as he didn't know basics. From the feedback i got this is the interview where i was told my sql is not strong enough. This interview is where my negative feedback stems from, it is frustrating i was penalized bc the interviewer was not knowledgeable and qualified. Second interview was pretty good in my opinion, it was a higher level design problem. Guy seemed pretty straight forward and as if he knew what was going on. Great conversation - nothing negative here. I was told a couple days later that the first tech round did not go how they wanted and they would not be moving forward. My advice for the organization. Please have qualified engineers conduct interviews. It is a complete waste of my time to work on an at home assignment (which the more i think of it, might have just been something they needed done and farmed out to interviewers) and multiple interviews if I can't be judged by a competent engineer.

A 30 minute background call with a recruiter followed by a take home data loading and transformation assignment. If you pass the take home then the recruiter will schedule a full day face to face meeting over Zoom with about 11 people over a span of 6+ hours