The interview process at Optimove was well-structured and fully transparent. It consisted of a home technical assignment, followed by an analytical interview, a director-level interview, an HR interview, and finally, reference checks. Each stage was clearly communicated in advance, and I appreciated the thoughtful progression and professionalism throughout the process. During the proccess I recieved more information regarding the requirments and responsibilities of the role.
Interview questions [1]
Question 1
Explain a situation you previously had where you belived your solution was superior to your manager's solution. How did you handle it?
I applied online. The process took 2 weeks. I interviewed at Optimove
Interview
Recruiter call, SQL assessment, Technical Interview, Interview with director then HR. A lot of steps for an entry level position, interviewers were not that friendly and confusing. Fast process, expect to hear back quickly.
I applied online. The process took 2 weeks. I interviewed at Optimove
Interview
5 Stage process.
1. Initial screening call with Recruiter.
2. SQL-based tests (60 mins). (Basic and advanced timed questions. Also required to explain what an SQL script is doing. Lastly, had to explain my interpretation of a diagram.
3. Technical interview (90-120 mins long). The interview is split into general questions, project-based questions (ensure to explain involvement and steps taken), Q&A, SQL script explanation, and logic-based question (ensure to consider how you order your approach to the problem).
4. Interview with the Director.
5. Interview with HR.
6. Meet the team in person (they said this is 'optional').
Overall, I find it's a lot of steps for a standard position. Interviewers were not that friendly, not to say they are mean, but it was a little off-putting. If it's indicative of the team I may have worked with, I'm not sure if I'd want to accept.
Be prepared to be asked several questions on projects you've taken, your answer to the technical problem, and your answer to the logic-based question. You need to make sure your explanation is clear and easy to understand.
Interview questions [1]
Question 1
Without using writing code, explain throughly (ideally in SQL), how you would generate scores in a game of Yahtzee based on a list of possible answers with dice that randomly return 5 numbers.