Noom interview questions

I was required to do a quick interview and then a mock chat with a client. The interviewer doing the mock chat was late and the process was a bit confusing. I was ultimately not offered a position, but the experience was ok.

The are two rounds for me. First round: had a phone call with HR who is very helpful, an impressive call overall, and she also mentioned the next steps of hiring process. There are 3 steps in the following, which are sql test, coding test, and data modeling analysis test. Second round: this is for sql testing, there are two persons, the test requires the proficiency of using sql on Looker. Since my current job doesn’t use looker so they had a walkthrough, and they also introduced the tables for the coding test, which were okay but no comprehensive (the interview is 1 hour, and you had to make join of 3 tables you were not familiar with)! There were 2 tests, one is using count() to aggregate a column and group by date - google is allowed during interview, since I use MySQL database normally, but they use redshift which means I had to google for some nuances of syntax, but that’s totally fine. the second one was really wordy, the question is confusing, but the answer is pretty straightforward, you have to use dense rank, min, max, avg etc. to aggregate data from 3 tables, they could have use a query result of example to let me know what they want to test instead of only writing the confusing question which is not classy. I sent the answers to them and got no-reply reject after few days, no surprising nor regret. Before the code interview, i tried to contact the HR for looker many times but got no response, and i watched tutorial about looker to ensure i could be comfortable with it during interview but bad luck. Anyways, that’s normal. i did several coding tests, this was the worst! it’s better to improve coding experience using the processional code pad instead of on looker which you’re not comfortable with until you pay for it. Otherwise, never waste time on the stupid process.