I applied online. The process took 4 weeks. I interviewed at Unilever (Sharnbrook, England) in Sep 2024
Interview
The technical round was well structured, I received a case study beforehand which I needed to solve and give my solution with reasoning at the interview. The Hiring Manager was very good with her questions.
However, after the first round, I got to know that they were not going for an external candidate as they would go for an internal candidate whose position was identified at risk by the HR team.
The recruiter was fantastic, great guy with good follow ups. The actual interview and team you'd be working on, not as much. Quite low pay for the seniority they are asking for as well. The interviewers were much much "down to business" types in my experience, and that's fine. But what is insulting is that they required two completely online interviews before even meeting them. See the questions below.
It seemed to be more of a showing off what they know and you don't kind of interview.
Interview questions [1]
Question 1
1. Work Break -> Found on leetcode.
2. SQL question - You are working for a large e-commerce company that receives daily customer transaction logs from multiple sources. The data may contain duplicates, missing values, and incremental updates.
3. SQL Question - Below is a streaming service company's customer subscription date table. Find the start/end date of each customer (each customer can have multiple sub/unsub actions)
4. Python Question - Given a list of words l_words = ['Apple', 'Pear', 'Orange']. Write a function to determine if a string can be segmented from the list of words given (i.e. s == "AppleOrange"). Try not to import any libraries.
5. Slowly Changing Dimensions in dimension tables, how do you handle their evolution. How to move data from multicloud tenants without data loss
I applied online. The process took 2 months. I interviewed at Unilever in Dec 2023
Interview
Was contacted via HR through WA and went through 1 round of interview with tech lead.
Overall, HR took very long time to respond on the status of the application and arranged an interview timeslot which was missed by the tech lead.
A very unprofessional culture.
