Phone interview with HR (15 min) -> Interview with a hiring Director (1 hour) -> homework -> 30 mins to go through my homework -> professional interview with an Architect and TL of other team.
Very strange process. It seems strange to give homework for TL position, but the homework is even more strange: it was writing SQL query with a recursive CTE, planning a data warehouse for a given context and restrictions and writing and ETL on SQL. All of these should have been done within 2 hours window though they didn't check if it I started earlier.
So they don't test your coding skills, but a lot of SQL.
The feedback I received was also weird: the huuuge ETL SQL query I created wasn't optimised performance wise due to lack of time and because in real world you don't do such things, you use Spark or similar.
Another feedback was that the solution I suggested was not as the interviewer's team has in production (though it is a good and working solution).
I thought the goal was to see the way I think and that I understand things, but the goal apparently was to guess what they have in prod.
I got this feedback and realized they weren't happy with me, so they added an additional step: "a professional interview" – one with an Architect and another TL discussing my experience and the system I worked on. I thought it went well, but HR called and sayd I"m declined. I asked for feedback and got the same feedback for my home assignment, nothing about the last interview.
