Upstox Full Stack Developer Interview: Rounds, Questions and Preparation

What the job involves

A Full Stack Developer at Indian unicorns and high-growth startups builds and maintains both client-side and server-side components of web applications, often working on features that directly impact millions of users in domains like fintech, e-commerce, or SaaS. Day to day, you will write clean, scalable code, collaborate with product managers and designers, debug production issues, and contribute to system design discussions. In fast-paced environments like Upstox, you are expected to own features end-to-end, from database schema to API to UI, and iterate quickly based on user feedback.

Role and Technical Knowledge

1. 1

   Explain the difference between SQL and NoSQL databases. When would you choose one over the other for a fintech application like a trading platform?

   Strong answers cover ACID compliance, scalability, and use cases. For fintech, emphasize transactions and consistency, often favoring SQL, but mention NoSQL for high-volume logs or user activity feeds.

2. 2

   What are the key considerations when designing a REST API for a stock trading app that needs to handle thousands of requests per second?

   Discuss rate limiting, caching (Redis), pagination, versioning, and efficient serialization. Mention idempotency for order placement and WebSockets for real-time updates.

3. 3

   How does React's virtual DOM work, and why is it beneficial for a dashboard that updates stock prices in real time?

   Explain diffing algorithm, batched updates, and efficient re-rendering. Highlight how it minimizes DOM manipulations, crucial for performance with frequent data changes.

4. 4

   Describe how you would implement authentication and authorization in a full stack app. What are the trade-offs between JWT and session-based auth?

   Cover token storage (httpOnly cookies vs localStorage), refresh tokens, and stateless vs stateful. For startups, JWT offers scalability but requires careful security handling.

Practical Scenarios and Problem Solving

1. 5

   You are building a feature to show users their portfolio performance over time. How would you design the database schema and API to support this efficiently?

   Propose a time-series table or aggregated daily snapshots, with indexes on user_id and date. API should support date range queries and caching for repeated requests.

2. 6

   A bug is reported where some users see stale data on their dashboard. How would you debug and fix this, considering both frontend and backend?

   Check caching headers, CDN invalidation, and client-side state management. Discuss logging, monitoring, and reproducing with specific user IDs to trace data flow.

3. 7

   You need to integrate a third-party payment gateway. Outline the steps, including error handling and security considerations.

   Mention API keys, webhook verification, idempotency keys, and retry logic. Emphasize PCI compliance and never storing sensitive card data on your servers.

4. 8

   How would you optimize a slow-loading page in a React app that fetches data from multiple APIs?

   Suggest code splitting, lazy loading, parallel API calls, memoization, and using React Query or SWR for caching. Also consider server-side rendering or static generation.

Behavioural and Situational Questions

1. 9

   Tell me about a time you had to learn a new technology quickly for a project. How did you approach it?

   Use STAR method. Highlight self-learning resources, building a small prototype, and applying it under deadline. Show enthusiasm for continuous learning, key in startups.

2. 10

   Describe a situation where you disagreed with a teammate's technical approach. How did you handle it?

   Focus on data-driven discussion, listening, and compromising for project success. Avoid blaming; emphasize collaboration and outcome.

3. 11

   In a fast-paced startup, priorities often change. Give an example of how you managed multiple tasks with tight deadlines.

   Show prioritization based on impact, communication with stakeholders, and use of tools like Trello or Jira. Mention staying calm and delivering incrementally.

4. 12

   Why do you want to work at a high-growth startup like Upstox rather than a large established company?

   Connect to ownership, rapid learning, and direct impact. Mention specific aspects of the fintech domain or the company's product that excite you, showing you have done research.

HR and Culture Fit

1. 13

   Where do you see yourself in the next 3-5 years?

   Align with growth in technical expertise and possibly leading small teams. Show commitment to the company's mission and a desire to grow with it.

2. 14

   What are your salary expectations?

   Research typical fresher salaries at Indian unicorns (e.g., 12-18 LPA). Give a range and express flexibility based on overall compensation and learning opportunities.

3. 15

   How do you handle feedback and criticism?

   Give a concrete example of receiving feedback and improving. Show you are open, not defensive, and actively seek feedback to grow.

4. 16

   Do you have any questions for us?

   Ask about team structure, tech stack, onboarding process, or challenges the team is facing. Avoid questions about salary or time off at this stage.