Filter interviews by
I applied via Company Website and was interviewed in Apr 2024. There were 4 interview rounds.
There was a round 0 which was basically a screening round, where the interviewer did a rapid fire of a number of questions on NoSQL vs SQL, concurrency, green threads,.etc
Round 1 was a coding round with Smit Patel. The question was given a job graph, i.e job X depends on job A, B,.etc produce any valid ordering in which the set of jobs can complete. We could freely choose the approach and language. I messed this one a little and completed the requirement just in the nick of time.
Optimising indexes in Postgres involves understanding query patterns and using tools like EXPLAIN to analyze performance.
Understand the query patterns to determine which indexes are necessary
Use tools like EXPLAIN to analyze query performance and identify areas for optimization
Consider using composite indexes for queries that involve multiple columns
Regularly monitor and maintain indexes to ensure optimal performance
HTTP verbs are used to indicate the action to be performed on a resource in a RESTful API.
GET - Retrieve data from a server
POST - Send data to a server to create/update a resource
PUT - Update a resource on the server
DELETE - Remove a resource from the server
PATCH - Update a resource partially
Live migration in a production database with 100% uptime
Use database replication to create a secondary database that mirrors the primary one
Gradually switch traffic from the primary to the secondary database
Once traffic is fully switched, perform the migration on the primary database
Switch traffic back to the primary database once migration is complete
Monitor for any issues during the migration process
Optimise frequently searched items list by implementing caching, indexing, and prioritising popular items.
Implement caching to store frequently searched items in memory for quick access.
Use indexing to efficiently search and retrieve items from the list.
Prioritise popular items by tracking search frequency and displaying them prominently.
Consider implementing autocomplete or predictive search to suggest items as users ...
HLD round, taken by Ratnesh Neema.
We went through work history. Then I was asked to design a feature for a cab platform like uber to generate a heatmap of future cab demand in a city. We spoke about market effects of speaking
I am interested in technologies related to artificial intelligence, machine learning, and cloud computing.
Artificial Intelligence
Machine Learning
Cloud Computing
I applied via Campus Placement
Hacker Rank test , DSA , aptitute & SQL
I applied via Instahyre and was interviewed in Apr 2024. There were 2 interview rounds.
I applied via Approached by Company and was interviewed in Nov 2023. There were 4 interview rounds.
Instawork India interview questions for popular designations
An Excel sheet for research purposes.
I applied via LinkedIn and was interviewed in Oct 2021. There were 3 interview rounds.
I appeared for an interview before Dec 2020.
Round duration - 60 Minutes
Round difficulty - Medium
This round was purely based on Data Structures and Algorithms . One has to be fairly comfortable in solving Algorithmic problems to pass this round . Both the questions asked were quite common and luckily I had already prepared them from CodeStudio and LeetCode.
Given a Binary Tree with 'N' nodes, where each node holds an integer value, your task is to compute the In-Order, Pre-Order, and Post-Order traversals of the binar...
Compute the In-Order, Pre-Order, and Post-Order traversals of a Binary Tree given in level-order format.
Implement functions to perform In-Order, Pre-Order, and Post-Order traversals of a Binary Tree.
Use level-order input to construct the Binary Tree.
Traverse the Binary Tree recursively to generate the required traversals.
Ensure proper handling of null nodes represented by -1 in the input.
Return the three traversals as
Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.
The first line of input is an intege...
Reverse a singly linked list by altering the links between nodes.
Iterate through the linked list and reverse the links between nodes
Use three pointers to keep track of the current, previous, and next nodes
Update the links between nodes to reverse the list
Return the head of the reversed linked list
Round duration - 45 Minutes
Round difficulty - Medium
This round basically tested some concepts from Data Structures and File Manipulation .
Given two arrays A
and B
with sizes N
and M
respectively, both sorted in non-decreasing order, determine their intersection.
The intersection of two arrays in...
The problem involves finding the intersection of two sorted arrays efficiently.
Use two pointers to iterate through both arrays simultaneously.
Compare elements at the pointers and move the pointers accordingly.
Handle cases where elements are equal and update the intersection array.
Return the intersection array as the result.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Campus Placement
Regex for email validation
Start with a string of characters followed by @ symbol
Followed by a string of characters and a period
End with a string of characters with a length of 2-6 characters
Allow for optional subdomains separated by periods
Disallow special characters except for . and _ in username
Print prime numbers in a given range and optimize the solution.
Use Sieve of Eratosthenes algorithm to generate prime numbers efficiently
Start with a boolean array of size n+1, mark all as true
Loop through the array and mark all multiples of each prime as false
Print all the indexes that are still marked as true
Find angle between hour and minute hand in a clock given the time.
Calculate the angle made by the hour hand with respect to 12 o'clock position
Calculate the angle made by the minute hand with respect to 12 o'clock position
Find the difference between the two angles and take the absolute value
If the angle is greater than 180 degrees, subtract it from 360 degrees to get the smaller angle
To un-hash a string, use a reverse algorithm to convert the hash back to the original string.
Create a reverse algorithm that takes the hash as input and outputs the original string
Use the same logic as the hash function but in reverse order
If the hash function used a specific algorithm, use the inverse of that algorithm to un-hash the string
based on 8 interviews
Interview experience
based on 15 reviews
Rating in categories
Data Operations Analyst
51
salaries
| ₹2.8 L/yr - ₹4 L/yr |
Community Operations Specialist
10
salaries
| ₹4 L/yr - ₹5.8 L/yr |
Data Analyst
6
salaries
| ₹3 L/yr - ₹3.5 L/yr |
Senior Data Operations Analyst
6
salaries
| ₹4 L/yr - ₹5.5 L/yr |
Product Manager
5
salaries
| ₹33 L/yr - ₹70 L/yr |
Urban Company
Quikr
Zomato
Swiggy