The first step before an interview was a coding assignment where you import a web access log into MySQL and use Java/Spring/JPA to query the database for narrowing down log statements by query. The use cases were pretty basic.

After the screening of my resume, they sent me an exercise based on the development of an ETL to load log data into a mysql database. I was also supposed to develop query for aggregation and to run those queries on the resulting database. The exercise was not complex but a bit long. I passed this step and I was contacted by one of their recruiter for another step. I had the interview with her and she explained me (after almost one week of work to complete the exercise) that I was supposed to work at least 50hours per week, not sure about holidays and also I should have been working during their working hours even if I am based in another timezone. All this information were provided to late in the process, after I spent one week of my (free) time to deliver the solution. She asked me to think about it. Then we met for another technical task of 20 minutes, you have to provide solution to two task without googling using your ide. I will list the question below. For both problems I started with a unit test and I provided an algorithm that was working, probably at least for the first problem was not the best solution. She told she would have contacted me in two weeks but I have never been contacted by them again. For me it's a very negative experience, they asked you to spend a lot of time on an exercise and only after that they provide some very peculiar information about their proposal that you should know as soon as possible in my opinion and I really think it's always important to provide a feedback to people that spend time during a recruiting process.