Zoho Creator Backend Engineer Interview: Rounds, Questions and Preparation

What the job involves

Backend engineers in Indian SaaS and B2B product companies build and maintain the server-side systems that power multi-tenant web applications, APIs, and data pipelines. They work on database design, business logic, authentication, integrations, and performance tuning to support thousands of business customers. Day to day involves writing code, reviewing pull requests, debugging production issues, and collaborating with frontend and product teams.

Role and technical knowledge

1. 1

   Explain how you would design a REST API for a simple task management feature in a multi-tenant SaaS product.

   Cover tenant isolation (e.g., tenant_id in every table and request), resource naming, HTTP methods, status codes, and pagination.

2. 2

   What is database indexing, and how would you decide which columns to index in a B2B application with heavy read queries?

   Explain B-tree indexes, selectivity, covering indexes, and the trade-off between faster reads and slower writes. Mention composite indexes for common filter combinations.

3. 3

   How does session management work in a stateless REST API, and what role do tokens play?

   Describe JWT or opaque tokens, statelessness, token expiry, refresh tokens, and how this helps horizontal scaling in a SaaS environment.

4. 4

   What is the difference between SQL and NoSQL databases? When would you choose one over the other for a B2B product?

   Compare schema flexibility, ACID transactions, scaling patterns, and give a concrete example like using PostgreSQL for transactional billing data versus MongoDB for flexible form definitions.

Practical scenarios

1. 5

   A customer reports that their dashboard loads slowly only during peak hours. How would you debug and fix this?

   Walk through checking slow query logs, adding indexes, caching frequent queries, analysing connection pool limits, and load testing. Mention monitoring tools.

2. 6

   You need to add a new feature that sends email notifications when a record is updated. Outline your backend implementation.

   Cover database triggers or application-level events, a message queue for reliability, idempotency, retry logic, and avoiding blocking the main request.

3. 7

   How would you handle a situation where a third-party API your product depends on starts timing out frequently?

   Discuss timeouts, circuit breakers, fallback responses, caching, async retries, and alerting. Show awareness of not cascading failures to users.

4. 8

   You are asked to write a SQL query that finds the top 5 customers by number of orders in the last month. How would you approach it?

   Write a query using JOIN, WHERE with date range, GROUP BY, ORDER BY COUNT, and LIMIT. Explain how an index on order date and customer ID helps.

Behavioural and HR

1. 9

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

   Use STAR format, highlight self-learning resources, a concrete outcome, and how you applied it under a deadline.

2. 10

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

   Show respectful communication, focus on data and trade-offs, willingness to compromise, and putting the product first.

3. 11

   Why do you want to work in a SaaS product company rather than a services company?

   Mention interest in building long-term products, working on scalable systems, continuous learning, and direct impact on many business users.

4. 12

   How do you prioritise tasks when you have a bug fix, a code review, and a feature deadline all at once?

   Explain assessing urgency and impact, communicating with your manager, using a simple framework like Eisenhower matrix, and avoiding context-switching penalties.

Problem-solving and coding

1. 13

   Given an array of integers, find two numbers that add up to a target sum. Write an efficient solution.

   Use a hash map for O(n) time. Explain the brute-force O(n^2) approach first, then optimise. Discuss edge cases like duplicates and no solution.

2. 14

   Write a function to reverse a linked list iteratively and recursively. What are the trade-offs?

   Show both implementations, compare space complexity (iterative O(1) vs recursive O(n) call stack), and handle empty or single-node lists.

3. 15

   How would you find the first non-repeating character in a string? What is the time and space complexity?

   Use a hash map or array of size 256 to count frequencies in one pass, then scan again. Aim for O(n) time and O(1) space for ASCII.

4. 16

   Explain how you would detect a cycle in a linked list without using extra memory.

   Describe Floyd's tortoise and hare algorithm, why it works, and its O(n) time and O(1) space complexity. Mention edge cases like a single node pointing to itself.