Filter interviews by
Clear (1)
Design a database schema to handle data updates with transactions.
Use a relational database management system like MySQL or PostgreSQL.
Create tables for different entities like users, transactions, and data to be updated.
Use transactions to ensure data consistency and integrity.
Implement foreign key constraints to maintain referential integrity.
Consider using stored procedures or triggers for complex update operations.
Top trending discussions
I applied via Referral and was interviewed before Sep 2023. There was 1 interview round.
Question was easy, interviewer was friendly.
DSA question.
1 - stocks buy/sell
I applied via Naukri.com and was interviewed before Aug 2023. There were 4 interview rounds.
Implement a linked list data structure and solve a problem using it.
Understand the basic concepts of linked lists such as nodes and pointers.
Implement functions to insert, delete, and search for elements in the linked list.
Solve a problem like reversing a linked list or finding the middle element using linked list operations.
Design a system similar to TrueCaller for identifying unknown callers.
Implement a database of phone numbers and associated names
Allow users to report spam numbers
Use machine learning algorithms to identify spam calls
Provide a caller ID feature for incoming calls
Led development of a cloud-based inventory management system for a retail company.
Managed a team of 5 developers to design and implement the system
Utilized AWS services for scalability and reliability
Integrated with existing ERP system for seamless data flow
Seeking new challenges and opportunities for growth
Looking for a new challenge to further develop my skills and knowledge
Interested in exploring different technologies and industries
Seeking opportunities for career advancement and growth
Current job lacks opportunities for professional development
I was interviewed before Apr 2021.
Round duration - 45 Minutes
Round difficulty - Medium
It was in the mid day and since I applied for a Frontend role the discussion was majorly around data structure and bit of Javascript.
The interviewer was helping and good listener.
You are provided with two sorted linked lists. Your task is to merge them into a single sorted linked list and return the head of the combined linked list.
...Merge two sorted linked lists into a single sorted linked list without using additional space.
Create a dummy node to start the merged list
Compare the values of the two linked lists and add the smaller value to the merged list
Move the pointer of the merged list and the pointer of the smaller value list
Continue this process until one of the lists is fully traversed
Append the remaining elements of the other list to the me
Given an integer array arr
of size 'N' containing only 0s, 1s, and 2s, write an algorithm to sort the array.
The first line contains an integer 'T' representing the n...
Sort an array of 0s, 1s, and 2s in linear time complexity.
Use three pointers to keep track of 0s, 1s, and 2s while traversing the array.
Swap elements based on the values encountered to sort the array in-place.
Time complexity should be O(N) and space complexity should be O(1).
Round duration - 60 Minutes
Round difficulty - Medium
It was more of a in depth round on the framework I'm working on and problem solving.
The event loop is a mechanism in programming that allows for asynchronous execution of code.
The event loop is a key component in JavaScript's runtime environment, responsible for handling asynchronous operations.
It continuously checks the call stack for any pending tasks and executes them in a non-blocking manner.
The event loop ensures that the program remains responsive by allowing other code to run while waiting for ...
Output-based questions in JavaScript using browser APIs
Example 1: Write a script that uses the Geolocation API to display the user's current location on a map
Example 2: Create a program that uses the Web Audio API to play a sound when a button is clicked
Example 3: Develop a web page that uses the Canvas API to draw a simple animation
Designing a system to support localization in a mobile app
Use resource files to store localized strings for different languages
Implement a language selection feature for users to choose their preferred language
Utilize localization libraries or frameworks to streamline the process
Consider cultural differences when localizing content, such as date formats and currency symbols
Round duration - 75 Minutes
Round difficulty - Hard
It was more of a fitment/managerial round.
Didn't had any coding questions, but was asked more on approaches and optimisations.
Discussions on the project you have worked on.
To find the fastest 3 horses out of a group with 5 horses racing at a time, we can use a tournament style approach.
Divide the horses into groups of 5 and race them against each other. This will give you the fastest horse in each group.
Take the winners from each group and race them against each other. The top 3 horses in this final race will be the fastest 3 overall.
Keep track of the results and compare the timings to d
To debug lag on a screen, analyze code, check for memory leaks, optimize rendering, and use profiling tools.
Analyze code to identify any inefficient algorithms or operations causing lag.
Check for memory leaks that could be impacting performance.
Optimize rendering by reducing the number of draw calls, optimizing shaders, and minimizing overdraw.
Use profiling tools like Xcode Instruments or Android Profiler to identify p
The app I recently worked on is a social media platform for sharing photos and connecting with friends.
The app follows a client-server architecture, with the client being the mobile app and the server handling data storage and processing.
The client side is built using React Native for cross-platform compatibility.
The server side is implemented using Node.js with a MongoDB database for storing user data and photos.
The a...
Tip 1 : Get your JS fundamentals right (if applying for a Frontend role, https://javascript.info/ is a good start)
Tip 2 : Apart from preparing data structures, practise on the communication skills as well (prepare your introduction, be a good listener and on spot improvisation plays key roles)
Tip 1 : highlight projects related to the job profile in your resume and mention what was your contribution in them precisely in 1/2 lines.
Tip 2 : Include URLs to applications/projects that you have build and your achievements/blog (if any)
I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.
Iterative solution using a stack to perform postorder traversal.
Use a stack to simulate the recursive call stack.
Push nodes in the order of right, left, root.
Pop nodes from stack and add to result array.
Repeat until stack is empty.
Design a messaging app like WhatsApp with one-to-one, group messaging, and read receipts functionalities.
Use a relational database to store user information, messages, and group memberships.
Create tables for users, messages, groups, and group memberships.
Include columns for message content, sender, receiver, timestamp, and read status.
Implement a feature to mark messages as read with read receipts.
Use indexes for effic
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
Binary search to find the closest element in a sorted array
Implement binary search to find the target element in the array
Keep track of the closest element found so far while searching
Update the closest element if a closer one is found during the search
Low level design for an online e-commerce website involves designing the architecture and components of the website.
Identify the main components such as user interface, database, payment gateway, product catalog, etc.
Design the database schema to store user information, product details, orders, etc.
Implement user authentication and authorization mechanisms for secure access.
Integrate payment gateway for processing tran...
I applied via Campus Placement
Deep copy is a copy of an object that duplicates all of its attributes, including nested objects, rather than just copying references.
Deep copy creates a new object with its own unique memory space.
Changes made to the original object do not affect the deep copy.
Deep copy is often used when you need to modify an object without affecting the original.
Example: Using JSON.parse(JSON.stringify(object)) in JavaScript to crea
I applied via Referral and was interviewed in Jun 2024. There was 1 interview round.
It was a DSA round with one medium and one hard question.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Software Engineer
44
salaries
| ₹0 L/yr - ₹0 L/yr |
Customer Support Specialist
40
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer2
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Development Representative
12
salaries
| ₹0 L/yr - ₹0 L/yr |
TriNet
Trinet Solution
Paychex IT Solutions India
Automatic Data Processing (ADP)