16 questions · from 4 interviews
Celigo interview questions
Every question candidates reported from their Celigo interviews, most frequently asked first. Each links to the write-up it came from, so you can see the round and how it went.
Celigo coding and DSA questions
- 01
Unique Paths II
I was asked to solve the Unique Paths II problem. The goal is to find the number of unique paths from the top-left corner to the bottom-right corner of a grid with obstacles. I solved it using recursion and was later asked to optimize the solution.
Medium · From Celigo Interview Experience for SDE2/3
- 02
Implement LRU Cache
Implement a Least Recently Used (LRU) cache. The cache should support get and put operations with O(1) average time complexity.
Medium · From Senior Software Engineer at Celigo
- 03
Design LFU Cache
Design an LFU Cache. I built the approach from scratch, and the interview turned into more of a collaborative discussion where we talked through design trade-offs and implementation details. At the end, I was asked to write the code. I started, but couldn’t…
From 🚀 Celigo Interview Experience – Software Engineer-2(and How I Got the Offer Through a Cold Email!)
- 04
Container With Most Water
Medium · From SSE 2 | Celigo | Offer
- 05
O(1) Query Data Structure
A simple Data Structures based question to answer few queries in O(1) time.
- 06
Best Time to Buy and Sell Stock II (Variation)
A slight variation of the 'Best Time to Buy and Sell Stock II' problem.
Medium · From SSE 2 | Celigo | Offer
Celigo system design questions
- 01
Design Database Schema for LinkedIn
I was asked to design a database schema for a platform similar to LinkedIn. This involved considering various entities like users, connections, job postings, messages, etc., and defining their relationships. Additionally, I had to discuss multiple queries and…
- 02
Design and Scale a Job Scheduler
I was tasked with designing a Job Scheduler from scratch. This involved outlining its core components, how it would manage and execute scheduled jobs, and how it would handle various scenarios like retries, prioritization, and distributed execution. I also…
- 03
Elevator Low-Level Design
Design an elevator system, focusing on its low-level components, classes, and interactions (e.g., how to handle requests, movement, and state).
- 04
Distributed Counter System Design
Design a distributed counter system that can handle a high volume of concurrent increment operations while maintaining accuracy and fault tolerance.
Hard · From Senior Software Engineer at Celigo
- 05
Explain Current Product Architecture
The interviewer asked me to explain the architecture of the product I currently work on. I opened up Draw.io and walked through each part of the system — why we use certain tools, how components communicate, and how the system scales.
From 🚀 Celigo Interview Experience – Software Engineer-2(and How I Got the Offer Through a Cold Email!)
- 06
Extend Current System to Support New Features
Discuss how we’d extend the system to support new features, which turned into a really engaging, deep product-level conversation.
From 🚀 Celigo Interview Experience – Software Engineer-2(and How I Got the Offer Through a Cold Email!)
- 07
Ordered Parallel File Copy System Design
Design and pseudo code: Given a set of files and their required processing order, copy them to a destination. Reads can be parallelized, but writes to the destination must maintain the exact given order (e.g., F2 must be written only after F1 is written if F2…
Hard · From SSE 2 | Celigo | Offer
- 08
E-commerce Order System & Best-Selling Books Feature
High-Level Design (HLD) and database discussion focusing on the order placing part of an e-commerce system (like Amazon). How would you modify this system to support features such as 'best selling books'?
Hard · From SSE 2 | Celigo | Offer
Celigo behavioural and HR questions
- 01
Discuss Projects and Challenges
In the technical manager round, I was asked to explain my past projects in detail and elaborate on the challenges I had faced during their development. This included describing the nature of the problems, my approach to solving them, and the outcomes.
Celigo other questions
- 01
PostgreSQL vs. MySQL & Kafka Discussion
Discuss the key differences between PostgreSQL and MySQL, including their strengths, weaknesses, and appropriate use cases. Additionally, discuss core concepts and applications of Kafka.
Celigo interview questions FAQ
What questions are asked in Celigo interviews?
Candidates reported 16 distinct questions across 4 Celigo interviews. 6 coding and DSA questions, 8 system design questions, 1 behavioural and HR questions, 1 other questions.
How difficult are Celigo interview questions?
Of the questions candidates rated, 0% were easy, 57% medium and 43% hard.