i
Sequoia Group
Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 3 interview rounds.
Find all unique triplets in an array that sum up to a given target value.
Sort the array first to easily identify duplicates.
Use two pointers approach to find the triplets.
Skip duplicates to avoid duplicate triplets.
Example: Given array [1, 2, 3, 4, 5] and target sum 8, output should be ['1, 3, 4'].
Design a like and comments system for a social media platform
Use a relational database to store user likes and comments
Implement a feature to allow users to like posts and comments
Include a feature to display the number of likes and comments on each post
Allow users to comment on posts and reply to comments
Implement a notification system for users to be notified of new likes and comments on their posts
I applied via Instahyre and was interviewed before Sep 2023. There were 3 interview rounds.
90 minutes.
Problem on graph - Evaluate division (leetcode).
Binary Search Problem.
Design a database for Instagram platform.
Create tables for users, posts, comments, likes, followers, etc.
Use primary keys and foreign keys to establish relationships between tables.
Store user information such as username, email, password, profile picture, etc.
Store post information such as image, caption, likes, comments, etc.
Implement indexing for faster retrieval of data.
Consider scalability and performance in databa
posted on 23 Sep 2024
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
After 3 sections of aptitude, English and core subjects, there were two coding problems both based on string one was easy and other was medium.
Developed a web-based project management tool for tracking tasks and deadlines
Utilized HTML, CSS, JavaScript for front-end development
Used PHP and MySQL for back-end functionality
Implemented user authentication and authorization features
Integrated calendar and notification system for task reminders
The backend of my project is responsible for handling server-side logic and data processing.
Implemented RESTful APIs for communication between frontend and backend
Used Node.js and Express for server-side scripting
Utilized MongoDB for database management
Implemented authentication and authorization using JWT tokens
I implemented concepts of OOP in my projects by creating classes, objects, inheritance, encapsulation, and polymorphism.
Used classes to represent real-world entities
Implemented inheritance to reuse code and create a hierarchy of classes
Utilized encapsulation to hide data and restrict access to it
Applied polymorphism to allow objects of different classes to be treated as objects of a common superclass
Duplicate entries in the database can be handled by using unique constraints, deduplication scripts, or merging duplicate records.
Use unique constraints in the database schema to prevent duplicate entries.
Implement deduplication scripts to regularly scan and remove duplicate records.
Merge duplicate records by updating one record with the information from the other duplicate record.
Code to check if a string is a palindrome or not
Create a function that takes a string as input
Remove all non-alphanumeric characters and convert to lowercase
Compare the string with its reverse to check if it's a palindrome
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
Dependency injection in .NET is a design pattern where dependencies are injected into a class rather than the class creating them itself.
Dependency injection helps in achieving loose coupling between classes.
In .NET, dependency injection can be implemented using frameworks like Unity, Ninject, or built-in .NET Core DI container.
Dependencies can be resolved through constructor injection, property injection, or method in...
I applied via Job Fair and was interviewed in Nov 2023. There were 2 interview rounds.
Customer service is an essential element in software development.
Customer service involves providing support and assistance to users of software applications.
It includes addressing user queries, resolving issues, and ensuring customer satisfaction.
Software developers may interact with customers through various channels like email, phone, or live chat.
Good customer service can lead to positive user experiences and incre...
Challenges in development include managing project timelines, debugging complex issues, and staying updated with new technologies.
Managing project timelines to ensure timely delivery of software
Debugging complex issues that arise during development
Staying updated with new technologies and tools to remain competitive in the industry
String and arrays duplicate and sorting questions
Apache Kafka is a distributed streaming platform used for building real-time data pipelines and streaming applications.
Kafka is designed to handle high-throughput, fault-tolerant, and scalable real-time data streams.
It uses a publish-subscribe messaging system where producers publish messages to topics and consumers subscribe to topics to receive messages.
Kafka stores messages in topics for a configurable retention per...
SQL is a relational database management system, while NoSQL is a non-relational database management system.
SQL databases are table-based and have a predefined schema, while NoSQL databases are document-based, key-value pairs, graph databases, or wide-column stores and have dynamic schema for unstructured data.
SQL databases are good for complex queries and transactions, while NoSQL databases are better for hierarchical ...
posted on 20 May 2024
I applied via Job Portal
Reasoning and aptitude question
Product Manager
4
salaries
| ₹25 L/yr - ₹30 L/yr |
Senior Software Engineer
4
salaries
| ₹38 L/yr - ₹45 L/yr |
Data Engineer
4
salaries
| ₹12 L/yr - ₹27.5 L/yr |
Software Development Engineer II
4
salaries
| ₹26 L/yr - ₹29 L/yr |
Senior Data Engineer
4
salaries
| ₹46 L/yr - ₹56 L/yr |
KPMG India
Deloitte
PwC
Ernst & Young