First interview with HR and the technical team lead, to discuss the company and the role, and my previous experiences. Then they send you to complete a 24-point offline Hackerrank, where 2 are algorithm problems, 1 is SQL, and the rest are questions of all types, but mainly about system design.

They never gave me the Hackerrank results. To summarize, they only sent me an email saying something like "that they continued the process with other candidates with greater solidity in terms of technical skills"...

So I don't know if I actually did poorly (I thought I had done relatively well), or if it was just an excuse, I'll never know...

Regardless, they don't pay for on-call duties or overtime, and you have to go to the office 2 days a week.

Merge two sorted arrays into a new sorted array.

Another algorithm exercise with an array of integers.

Perform an SQL query that involved date parsing, grouping, and sorting.

Produce JSON matching this specification: