Instawork India Software Engineer2 Interview Questions, Process, and Tips

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.

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
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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 ...read more
Answered by AI
Add your answer

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

Q1. Why do you want to work with us ?
Add your answer
Q2. What impact will you be remembered for at your last company ?
Add your answer
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
Answered by AI
Add your answer