I applied through a recruiter. The process took 1 day. I interviewed at Code District (Lahore) in Sep 2025
Interview
I recently interviewed with Code District, and I’d like to share my experience.
The interviewer they assigned had around 3 years of experience — the same as mine. While that isn’t necessarily a problem, it did feel unusual since we were essentially on the same level.
The questions throughout the session were heavily focused on databases. While I do have DB knowledge, my primary expertise is in frontend development. The interviewer, being a backend developer, seemed to expect backend-style solutions from me, which felt mismatched with the role I applied for.
Another point was the duration — the interview lasted 38 minutes. Typically, if a candidate doesn’t align with expectations, it’s clear within the first 10–15 minutes. Extending the interview unnecessarily wastes both sides’ time.
Overall, I found the process disappointing. The mismatch between the role and the questions asked, along with the unnecessarily long duration, made this one of the less professional interviews I’ve attended.
Interview questions [1]
Question 1
Suppose you are designing an e-commerce system. There are millions of users, millions of orders, and a very high read/write frequency. How would you design the database schema to ensure:
Fast lookups of orders by user,
Scalability across multiple servers,
Data consistency when multiple users are placing orders at the same time,
And also ensure no user can see another user’s data?
Explain whether you would use SQL or NoSQL, justify your choice, and discuss indexing strategies, sharding, and transaction isolation levels."