Filter interviews by
Design schema for a movie booking system.
Create tables for movies, theaters, users, bookings, and payments.
Use foreign keys to establish relationships between tables.
Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.
Consider implementing a booking algorithm to handle seat selection and availability.
Ensure data integrity and normalization for efficient da...
To scale the app database over India, consider sharding, replication, and using cloud services.
Implement sharding to distribute data across multiple servers based on geographic location or other criteria.
Set up replication to ensure data consistency and availability in different regions.
Utilize cloud services like AWS or Azure to easily scale resources based on demand.
Optimize queries and indexes to improve databa...
Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.
Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.
Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defi...
Approaching unfamiliar coding problems requires a structured method to break down and solve them effectively.
Understand the problem: Read the question carefully and identify key requirements.
Break it down: Divide the problem into smaller, manageable parts or steps.
Research: Look for similar problems or solutions online, such as on Stack Overflow or GitHub.
Pseudocode: Write pseudocode to outline your logic before c...
We have used a combination of containerization and orchestration tools like Docker and Kubernetes for our microservices architecture.
We have followed the principles of domain-driven design to identify the boundaries of our microservices.
We have used RESTful APIs for communication between microservices.
We have implemented fault tolerance and resilience patterns like circuit breakers and retries.
We have used event-d...
Indexing strategy is a method of organizing and optimizing data retrieval from a database.
Choose appropriate data structures for indexing
Consider the size and complexity of the database
Regularly analyze and optimize the indexing strategy
Examples: B-tree, hash index, bitmap index
A multi-level parking system schema design involves creating a database to manage parking spots and their availability.
Create a database to store information about parking spots, levels, and availability
Design a user interface for customers to view available spots and reserve them
Implement a system to track the entry and exit of vehicles
Incorporate sensors or cameras to monitor parking spot availability
Consider in...
Indexing internals refer to the mechanisms and structures used to efficiently retrieve data from databases.
B-trees are commonly used for indexing in databases, allowing for efficient searching, insertion, and deletion.
Hash indexing uses a hash function to map keys to specific locations, providing fast access for equality searches.
Bitmap indexes are effective for columns with a limited number of distinct values, op...
The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.
Data: the actual information stored in the database, such as customer records or product details.
Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.
Software: the database management system (D...
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
Design schema for a movie booking system.
Create tables for movies, theaters, users, bookings, and payments.
Use foreign keys to establish relationships between tables.
Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.
Consider implementing a booking algorithm to handle seat selection and availability.
Ensure data integrity and normalization for efficient data re...
To scale the app database over India, consider sharding, replication, and using cloud services.
Implement sharding to distribute data across multiple servers based on geographic location or other criteria.
Set up replication to ensure data consistency and availability in different regions.
Utilize cloud services like AWS or Azure to easily scale resources based on demand.
Optimize queries and indexes to improve database pe...
Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.
Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.
Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defined c...
The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.
Data: the actual information stored in the database, such as customer records or product details.
Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.
Software: the database management system (DBMS) ...
I applied via LinkedIn and was interviewed before Oct 2022. There were 7 interview rounds.
Approaching unfamiliar coding problems requires a structured method to break down and solve them effectively.
Understand the problem: Read the question carefully and identify key requirements.
Break it down: Divide the problem into smaller, manageable parts or steps.
Research: Look for similar problems or solutions online, such as on Stack Overflow or GitHub.
Pseudocode: Write pseudocode to outline your logic before coding...
I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 5 interview rounds.
A multi-level parking system schema design involves creating a database to manage parking spots and their availability.
Create a database to store information about parking spots, levels, and availability
Design a user interface for customers to view available spots and reserve them
Implement a system to track the entry and exit of vehicles
Incorporate sensors or cameras to monitor parking spot availability
Consider integra...
Indexing strategy is a method of organizing and optimizing data retrieval from a database.
Choose appropriate data structures for indexing
Consider the size and complexity of the database
Regularly analyze and optimize the indexing strategy
Examples: B-tree, hash index, bitmap index
Indexing internals refer to the mechanisms and structures used to efficiently retrieve data from databases.
B-trees are commonly used for indexing in databases, allowing for efficient searching, insertion, and deletion.
Hash indexing uses a hash function to map keys to specific locations, providing fast access for equality searches.
Bitmap indexes are effective for columns with a limited number of distinct values, optimiz...
We have used a combination of containerization and orchestration tools like Docker and Kubernetes for our microservices architecture.
We have followed the principles of domain-driven design to identify the boundaries of our microservices.
We have used RESTful APIs for communication between microservices.
We have implemented fault tolerance and resilience patterns like circuit breakers and retries.
We have used event-driven...
Top trending discussions
I applied via Approached by Company and was interviewed before Jun 2021. There were 2 interview rounds.
Frameworks provide structure and pre-built components for software development, but can also limit flexibility and require learning curve.
Advantage: Provides structure and pre-built components for faster development
Advantage: Can improve code quality and maintainability
Disadvantage: Can limit flexibility and customization
Disadvantage: Requires learning curve and potential dependency issues
Example: ReactJS provides a fr...
Oops stands for Object-Oriented Programming. It is a programming paradigm that uses objects to represent real-world entities.
Advantages: code reusability, modularity, encapsulation, inheritance, polymorphism
Disadvantages: complexity, steep learning curve, performance overhead
Example: creating a class 'Car' with properties like 'make', 'model', and 'year', and methods like 'start_engine' and 'stop_engine'
I applied via Naukri.com and was interviewed before Sep 2021. There was 1 interview round.
I applied via Company Website and was interviewed before Jul 2020. There were 3 interview rounds.
I am a software engineer with experience in developing web applications and mobile apps.
Proficient in programming languages such as Java, Python, and JavaScript
Experience in developing RESTful APIs and integrating third-party APIs
Familiarity with front-end frameworks such as React and Angular
Strong understanding of database management systems such as MySQL and MongoDB
Passionate about learning new technologies and keepi...
Software industry offers endless opportunities for innovation and growth.
Software industry is constantly evolving and offers opportunities to work on cutting-edge technologies.
It provides a platform to solve complex problems and create innovative solutions.
The demand for software engineers is high and the industry offers competitive salaries.
Core industries may have limited scope for growth and innovation compared to s...
Program to print a given string in reverse
Create a character array of the given string
Loop through the array from end to start and print each character
Mux is a device that selects one of several input signals and forwards the selected input into a single output line.
Mux stands for Multiplexer.
It is used in digital circuits to select one of several input signals and forward the selected input into a single output line.
It is used in communication systems to combine multiple signals into a single channel for transmission.
It is used in video and audio systems to switch b...
DeMux is short for Demultiplexer. It is a digital circuit that takes one input and directs it to multiple outputs.
DeMux is used in digital communication systems to separate signals that have been combined for transmission.
It is also used in computer memory systems to select a specific memory location.
DeMux is used in video and audio systems to separate different channels of information.
It is used in automation systems ...
Decoder converts encoded data into a readable format while Demux separates a single input into multiple outputs.
Decoder is used to decode encoded data such as binary data into a readable format.
Demux is used to separate a single input into multiple outputs based on the control signals.
Decoder is a combinational circuit while Demux is a sequential circuit.
Decoder is used in applications such as remote controls, computer...
Amadeus Labs is a leading technology company in the travel industry.
Amadeus Labs provides opportunities to work on cutting-edge technologies.
The company has a strong focus on innovation and research.
Amadeus Labs has a global presence and offers a diverse and inclusive work environment.
Working at Amadeus Labs provides the opportunity to make a real impact on the travel industry.
The company values work-life balance and o...
Yes, I am comfortable working for Testing.
I have experience in testing and understand its importance in software development.
I am willing to learn new testing techniques and tools.
I am comfortable working with testing teams and collaborating with them to ensure quality software.
I understand the importance of testing in ensuring customer satisfaction and reducing costs.
Examples: I have experience in manual and automated...
I have the necessary skills and experience to excel in the developer role.
I have a degree in computer science and have completed multiple coding projects.
I am proficient in programming languages such as Java, Python, and C++.
I have experience working with databases and web development frameworks.
I am a quick learner and enjoy solving complex problems.
I am a team player and have collaborated with other developers on var...
I appeared for an interview in Aug 2016.
Some of the top questions asked at the MongoDB Consultant Engineer interview -
based on 2 interview experiences
Difficulty level
Duration
based on 5 reviews
Rating in categories
Data Analyst
30
salaries
| ₹14.8 L/yr - ₹26 L/yr |
Consultant Engineer
29
salaries
| ₹25.5 L/yr - ₹40.1 L/yr |
Senior Data Analyst
19
salaries
| ₹16.9 L/yr - ₹26.2 L/yr |
Solution Architect
15
salaries
| ₹29.6 L/yr - ₹60 L/yr |
Research Associate
14
salaries
| ₹5.6 L/yr - ₹12 L/yr |
Thomson Reuters
Oracle Cerner
Chetu
R Systems International