The process was overall smooth and had the below 6 rounds of interviews:
1) Recruiter Call
2) Background questionnaire
3) Hiring Manager Interview
4) SQL Coding Challenge
5) Product Demo
6) Onsite
Interview questions [1]
Question 1
Sort the data base to show the top 3 users in X categories using SQL
It was difficult and relatively time intensive, with more rounds than I expected. But makes sense in retrospect, the bar is high and colleagues are all very smart and capable
I applied online. The process took 3 weeks. I interviewed at Census (London, England) in May 2024
Interview
1st stage - Interview with HR (video call)
2nd stage - Interview Account Executive (video call)
3rd stage - Presentation to the Account Executive and VP of Revenue
I got rejected after this stage but it the 4th stage is a panel talk and last one is having coffee with the CEO where they provide an offer.
My overall experience was great.
Interview questions [1]
Question 1
Tell me about yourself, past experience, why Census, which sales strategies have you used (for the presentation)