After passing the pre-selection phase, they gave me a coding exercise to complete within 5 days. After wasting time to prepare it well, they tell me that my code wasn't updating the events (a table in the database) when all the selections were in an inactive state. Essentially, they didn't even look at the code carefully. I am speechless. I'm pasting the code for the update that they overlooked. Guys, don't waste your time with these people, look elsewhere. You would be disappointed working with such unprofessional individuals. cursor.execute( """ SELECT COUNT(CASE WHEN se.active = FALSE THEN 1 END) AS inactive_count, COUNT(*) AS total_count FROM event e JOIN selection se on e.name = se.event WHERE e.name = %s; """, (event,)) counter_results = cursor.fetchone() if counter_results["inactive_count"] == counter_results["total_count"]: update_query = 'UPDATE event SET active = %s WHERE name = %s' cursor.execute(update_query, (False, event))

I secured the interview through a recruitment agency and found the process to be well structured and exactly what I would have expected it to be, in hindsight. The interviewers made everything very comfortable and relaxed, focusing on my goals, the company goals and how I could help them. Round 1: Personal/Professional questions related to my experience and the company. Round 2: Multiple Choice tech questions and a code challenge. I think I did fine on the MC questions but was very underprepared for the code challenge. MC Questions were related to basic programming logic(Python) and included basic questions on SQL and Linux. The tech challenge wasn't difficult(it was in Python), but was enough to throw me for a loop since I didn't expect it. I was stopped at this round. Round 3: As described would have been a "Take-Home" technical challenge that would be reviewed in the next round. Round 4: As described would have been a meet and greet/informal chat about the take home and with other members of the company. In total, the process would have likely taken roughly a week and a half; a couple of days per section. All in all, despite not making it through round 2, the experience chatting with the technical recruiters and the agency I applied through was incredibly positive and, given better prep, is absolutely the kind of place I'd love to pursue in the future.