I applied through LinkedIn and was contacted by the hiring manage within a week's time.
Round 1 : 30 Min call with the hiring manager. It started off as a casual conversation and went a little technical at the end. We talked about imp kpi's to track product success, what ML model will I use to detect and increase supply and why
Round 2: HR called and told how happy their team is and would want me to do a take home exercise which consisted of 3 SQL questions (1 - Easy, 2 Semi Medium Level). Raw data with 5 open ended questions. I was asked to do this in 2 hours (un realistic expectations)
Round 3: HR called me 30 min after my take home submission that they want to move ahead and are excited. He tried negotiating on salary and getting a number out of me. Their range 90-110 Base + Equity (which is useless at this time) + Benefits + Relocation. I clearly stated that I make more than this and am looking for a higher number. FYI : They want you in office which is in Utah. He called back after a week and said they want to move ahead for further rounds
Round 4 : 3 Back to back rounds.
1 - Hiring manager and data analyst : They asked product based questions and were impressed
2. Co Founder : He went through my background and asked standard behavioral questions. Seemed impressed
3. VP Data Engineering: Asked standard DE questions like : what is star schema, fact table and dimensions table, how would I create a Data Warehouse, ETL pipelines and tools discussion. Seemed happy
I thought that I did well and would receive an offer. Twist : I texted the hiring manager that I have not been to my country in last 3 years. Need to be there in till dec mid and can join after that. He appreciated informing him about it and rejected me the next day :D
Irrespective the people were nice and I enjoyed talking to them. It was very competitive and I think my salary ask and talking about joining them after 1.5 months went against me. Still waiting for a feedback!