AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Instawork India Interview Questions, Process, and Tips
Top Instawork India Interview Questions and Answers
- Q1. How will a live migration occur in a production database where 100% uptime is expected ?asked in Software Engineer2 interview
- Q2. How will you optimise a frequently searched items list ?asked in Software Engineer2 interview
- Q3. What teconologies are you interested in ?asked in Software Engineer2 interview
Instawork India Interview Experiences
7 interviews found
Anonymous
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.
(4 Questions)
- Q1. Optimising indexes in Postgres
- Ans.
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
- Q2. Name some HTTP verbs
- Ans.
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
- Q3. How will a live migration occur in a production database where 100% uptime is expected ?
- Ans.
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
- Q4. How will you optimise a frequently searched items list ?
- Ans.
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
(3 Questions)
- Q1. Why do you want to work with us ?
- Q2. What impact will you be remembered for at your last company ?
- Q3. What teconologies are you interested in ?
- Ans.
I am interested in technologies related to artificial intelligence, machine learning, and cloud computing.
Artificial Intelligence
Machine Learning
Cloud Computing
Interview Preparation Tips
After 5 rounds if you are ghosted then thats a lot of your hours wasted.
Hiring manager was disinterested in the interview. She read cliche questions off a list and wasn't interested in my answers. She only wanted to move on to the next question and get it over with. Besides her and the HR which doesn't care about informing or updating everyone else was nice and the interview was adjusted as per my previous experience.
Skills evaluated in this interview
Software Engineer2 Interview Questions asked at other Companies
I applied via Campus Placement
Hacker Rank test , DSA , aptitute & SQL
(1 Question)
- Q1. In detail about myself , resume , projects , basic DSA , devlopment concepts
Software Developer Intern Interview Questions asked at other Companies
I applied via Instahyre and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. Basics Introduction
(2 Questions)
- Q1. Are you a people person or Process person
- Q2. Are you a Builder or Climber
Interview Preparation Tips
- SQL
- Google sheet
- People Management
Team Lead Operations Interview Questions asked at other Companies
I applied via Approached by Company and was interviewed in Nov 2023. There were 4 interview rounds.
(1 Question)
- Q1. My current job roles and responsibilities and case study.
(1 Question)
- Q1. Conflict and Metrics derive questions
(1 Question)
- Q1. Metric Derive questions
Interview Preparation Tips
Team Lead Interview Questions asked at other Companies
Instawork India interview questions for popular designations
Prajwal D
An Excel sheet for research purposes.
Data Operations Analyst Interview Questions asked at other Companies
(1 Question)
- Q1. System Design questions
Senior Software Engineer Interview Questions asked at other Companies
Jobs at Instawork India
I applied via LinkedIn and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical questions related to market research and real time assignments
Interview Preparation Tips
Data Operations Analyst Interview Questions asked at other Companies
Interview questions from similar companies
I appeared for an interview before Dec 2020.
(2 Questions)
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.
- Q1.
Binary Tree Traversals Problem Statement
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...
- Ans.
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
- Q2.
Reverse Linked List Problem Statement
Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.
Input:
The first line of input is an intege... - Ans.
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
(1 Question)
Round duration - 45 Minutes
Round difficulty - Medium
This round basically tested some concepts from Data Structures and File Manipulation .
- Q1.
Intersection of Two Arrays Problem Statement
Given two arrays
AandBwith sizesNandMrespectively, both sorted in non-decreasing order, determine their intersection.The intersection of two arrays in...
- Ans.
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.
Interview Preparation Tips
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.
Skills evaluated in this interview
I applied via Campus Placement
Interview Preparation Tips
Experience: They selected 10 students from our college from CS and IT .They are looking for guys with extra projects done during college .App development will be a bonus ,contribution to open source and competitive programming will help for shortlisting.
Some of my friends had research papers published and they too got selected.
Round: Test
Experience: Have to write code snippet for 4 questions in 45 minutes
1.Difference between hour hand and minute hand
2.longest palindromic sub string.
3.Product Array puzzle
4.Some question related to matrix
Tips: All question were from geeksforgeeks
So practice it well ..u will make through it
Round: Test
Experience: Long Discussion on projects
They will scan each and every line of your Resume ,so dont write bullshits..
I wrote about interest in AI and got screwed..Discussion on college projects and final year project.
Then asked me to design a snake and ladder game OOPS concepts
Told me to find sum of all elements of sub matrix..(hint pre-processing the matrix)
Asked me about sessions and cookies
Gave a query to write on database indexing (dont remember exactly)
Asked me the code of the difference between hour hand and minute hand and extended it wid the second hand
Asked me as how to implement a dictionary
asked about TRIES ,CODE SNIPPET ON THE SHARED DOCS
One of my friend was asked to implement (set) of STL
Tips: The interviewer was cool guy..helped me a lot always made me comfortable.Interact with them as much as possible
Round: Test
Experience: Wid the CTO of the company .
Started wid the projects again .ACID properties,Database transactions,Concurrency Control
Optimization in database.
Then he asked me to code a function
Given a hash function applied on letters of English words ,un-hash it.Took me 45 minutes to reach the solution ,he helped me a lot.
Asked me to write the code for diameter of a binary tree
Asked me write the code for Boolean Matrix
One of my friend was asked to a question in which there was a bug in a m*n matrix and we have to find the bug(hint dfs or bfs)
Tips: keep calm ,,just keep talking ad he will help u a lot...
Round: HR
Experience: This was the toughest round for me...I had cleared all the rounds but they rejected me in the HR round ,,,dont know where I screwed..Learn every thing of Zomato..
They offered me an internship and thereafter they would look to give a PPO ...!!!lets see what happens
Skills: Coding Skills And Knowledge On Data Structures
Duration: 3
College Name: NIT Srinagar
Interview Questionnaire
9 Questions
- Q1. Write a regex for email validation?
- Ans.
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
- Q2. Parse the XML? and store the output in JSON. Discussed different approaches?
- Q3. Print prime numbers in a given range and optimize the solution?
- Ans.
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
- Q4. Puzzle – 25 horses – 5 lanes, find fastest 3 horses?
- Q5. Web related questions on Sessions and cookies?
- Q6. A lot of discussion on my resume, experience etc
- Q7. Find angle between hour hand and minute hand in clock if time is given? Write a program or pseudo code?
- Ans.
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
- Q8. A hash function was written to convert a string into a hash. Write a un-hash function to revert it(from hash to string)?
- Ans.
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
- Q9. He discussed about expectations and role. Asked me if I have any questions. He said to me “yaha aana hai to marwani padegi. tyar ho”? I smiled and asked what are the work timings? He said 9-9 and I was kin...
Interview Preparation Tips
Skills: Web development, JSON, Algorithm
College Name: na
Motivation: Overall process was not very tough. But they have start up culture. People work their for 11-12 hours a day. Sometimes on Saturday as well. So people who are geeks or have nothing in life to do except their job can go and join
Skills evaluated in this interview
Instawork India Interview FAQs
Tell us how to improve this page.
Instawork India Interviews By Designations
- Instawork India Data Operations Analyst Interview Questions
- Instawork India Team Lead Operations Interview Questions
- Instawork India Senior Software Engineer Interview Questions
- Instawork India Software Engineer2 Interview Questions
- Instawork India Software Developer Intern Interview Questions
- Instawork India Team Lead Interview Questions
Interview Questions for Popular Designations
Instawork India Interview Process
based on 8 interviews
Interview experience
Interview Questions from Similar Companies
Instawork India Reviews and Ratings
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
- Home >
- Interviews >
- Instawork India Interview Questions
