2 Heckerrank question. One SQL one coding challenge. The SQL problem is very easy, takes about 10 minutes. The coding challenge is hard. Asking a prime factor problem. The test cases are large and will easy cause TLE problem.
Interview questions [1]
Question 1
given a list of number, find all its prime factor and use those prime factor to flip the blubs.
first round and around 45 minutes after online assessmen and data cleaning exercise, with a data analyst in the team, All the questions is about python and sql and data frame.
I applied online. The process took 4 weeks. I interviewed at Millennium in Oct 2024
Interview
In total there will be around 6 stages
1. around 1 hour Hackerrank test: 1 sql; 1 python
2. take-home data cleaning exercise
3. online interview with live-coding in hackerrank (python)
4. face-to-face interview
5. caliper test
6. Online interview with Head of department
Passed the first two stages but failed in the live-coding round.
Interview questions [1]
Question 1
What is your technical expertise? What data did you work with, what insights did you get?
Data Analyst applicants have rated the interview process at Millennium with 3.5 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 44.9% positive. This is according to Glassdoor user ratings.
Here are the most commonly searched roles for interview reports -