I applied through an employee referral. The process took 1 week. I interviewed at Confluent in June 2021
Interview
Technical interview with 2 intermediate to advanced SQL questions and one easy to intermediate python question. SQL functions and keywords were provided after some struggling with the material. Interviewer was good about responding to questions.
Interview questions [1]
Question 1
2 SQL questions and one python question. Python question involved string manipulation and casting. SQL questions used pivot and window functions.
Interviewed with Confluent two times for two different positions. First one I ended up getting ghosted after 2 rounds and I foolishly decided to interview again for another position after a different recruiter reached out after over 6 months since the first interview period (long enough for me to forget what happened). Ended up finishing another 2 rounds for the new position before getting ghosted again and told a month later the position would be outsourced. Unprofessional and fooled me twice.
Interview questions [1]
Question 1
Signed NDA but normal data science questions with nothing too difficult or out there.
The process was a set of SQL and Python problems. There were 3 SQL problems and 1 Python problem. The next round consisted of a case study related to their product.