Sollicitatievraag bij Progyny

General questions about their tech stack (Python, Docker, MySQL). Mostly Python and SQL related. Code walk for a submitted project to purchase crypto currencies.

Antwoord op sollicitatievraag

Anoniem

21 mei 2022

I wouldn't say the project or interviews were difficult, but the final one was definitely time-consuming. In hindsight, I would have preferred a "hard" coding interview asking me to implement a binary tree or something similar just because it would have taken less time overall. I might have had a different view if I got the job though =) I assume I failed the third and final interview after uploading a small project to buy crypto currencies to GitHub and doing a call/share screen to review it with them. I would hope if I didn't meet their criteria on the 1st or 2nd interviews they wouldn't have put me through to the 3rd because doing a project is at least some hours of work, regardless of skill level. The primary negative feedback they gave on the solution I submitted: I didn't use an ORM like SQLAlchemy for queries and didn't clean input (SQL Injection might be an issue if the API I was tapping for coin market info was compromised). This is definitely a fair point: I did in fact not use .execute() correctly for a couple of queries and instead formatted the string putting it in, which is bad practice. I only structured the DB and application to handle purchases and not sales. I noted this fact pretty early on, stating I took that approach because sales weren't a requirement in the spec prior to them bringing it up, but even after I mentioned that when we got to it in the code they addressed it as a problematic point. I didn't stop general execution when logging critical errors. The positive feedback was that I structured and documented things well. I was left with the impression they accepted I had provided a working solution. They mentioned at the top of the call that they recognized it as a working solution because I included a ~5m video in my repo demonstrating me pulling it down from GitHub as a new clone and running it, which no other interviewees had done. It'd be nice to get feedback on if I wasn't selected based on a skill shortfall so I could improve on those areas for other hiring organizations, but I recognize that's unlikely feedback to receive and there are many reasons I may not have been selected that wouldn't be shared with me.

3