The whole loop was 5 rounds, and each round felt like beating a boss to level up.
Round 1: SQL + case
The SQL part was basically very similar to another post I've seen on the forum — there were some variations on the questions, but the topics were the same.
After the SQL, there was a case. They gave me a credit card approval rate time series from Jan 2013 to Jan 2015. There was a dip in Feb 2013, a small surge in Nov 2013, and then growth starting Jan 2014. They asked what I thought was going on and what my assumptions were. I said the Feb dip could be an internal issue — a feature launch, something technical... and that Nov 2013 looked like they ran an A/B test that caused the surge, and it looked successful, so they launched it in Jan 2014.
Round 1 went smoothly and I moved on to round 2.
Round 2 was with a Staff DS, going deep on case questions.
First question was also a time series. Similar to round 1, but this time you had to dig into why the dip happened and think about the relationship between the numerator and the denominator (also a conversion rate).
Second question: on the Airwallex page, they want to swap the positions of the "see a demo" and "get started" buttons. What problem does this solve, why would you do it, and if you did it, how would you measure success?
Round 3, with the hiring manager:
The HM round was all classic behavioral and past-experience questions. Might not have been a great match, and I didn't pass.
Discussion
Loading comments…