Rejected and taking it hard

Posted by Odd_Departure_9511@reddit | ExperiencedDevs | View on Reddit | 154 comments

Hello. I’m mostly venting. I am a software engineer with 7 YOE. Senior in my org but I know that levels vary.

I had an interview for a job I really wanted. 5 interviews, 7 interviewers, 8 hours, 6 yesses and 1 neutral maybe no (couldn’t tell from what the recruiter said) and no offer.

There was a debugging round, a leetcode round with 4 problems (I solved 3 and ran out of time on the last), two behaviorals, and a system design. Apparently it was the system design round that got me. The only thing the recruiter could tell me is that the interviewer didn’t like that I didn’t use a queue in my solution.

It was an analytics system design problem. I asked if it was real-time analytics and he said no and suggested batch processing instead. I asked about how the data was infested and he said to imagine a file upload. I asked about reporting and he suggested a delayed reporting.

So I suggested a file upload service that stores data in S3. And then I asked if we should talk about post processing the file and he said no (which is where I would have used a queue). He said no focus on the analytics so I hand waved that part and said that there would be something to process the file so the data could end up in a DB. So then I started suggesting some architecture to read from a DB, including airflow for scheduling and spark for processing, and then an analytics DB for performant timeseries queries.

I will be the first to admit I don’t think my solution was perfect but I feel like this was not a disastrous performance and I am taking it really hard that I got rejected. This was basically a dream job for me.