OpenBet Senior Software Engineer Interview Questions and Answers

Q1. Nth Greatest Element III (Leetcode)
Ans. 
Find the Nth greatest element in an array without sorting
• Use a priority queue to keep track of the N greatest elements

• Iterate through the array and add elements to the priority queue

• Return the top element from the priority queue as the Nth greatest element
Answered by AI
Add your answer
Q2. Heater Problem (Leetcode)
Ans. 
Heater Problem - Find minimum radius to cover all houses with heaters
• Sort the houses and heaters arrays

• For each house, find the closest heater using binary search

• Calculate the minimum radius needed to cover all houses
Answered by AI
Add your answer

Q1. Tell me about Yourself?
Add your answer
Q2. Resume and current project related questions
Add your answer

Q1. C#, OOPS concepts, Asp.net, MVC, Rest APIs
Add your answer

Q1. This was Managerial round Asked few things about current project again and checked suitability for the role
Add your answer

Q1. Location, shift timings, Salary discussion
Add your answer

Q1. All the questions were from SQL server.
Add your answer
Q2. How to get 3rd highest salary ?
Ans. 
To get the 3rd highest salary, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query to select distinct salaries in descending order.

• Use the 'LIMIT' keyword to limit the results to 3.

• Use the 'OFFSET' keyword to skip the first 2 highest salaries.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q3. Inner join result of 2 table. Table one [1,1,1,1] table two [1,1,1,1,1,1]
Ans. 
The inner join of two tables with duplicate values results in a combined set of common values.
• Inner join combines rows from both tables where the key columns match

• In this case, the result would be [1,1,1,1,1,1] as all values are common in both tables
Answered by AI
Add your answer
Q4. SSIS Package creation.
Add your answer
Q5. Latest project explanation
Ans. 
Developed a web application for tracking and managing project tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express

• Utilized MongoDB for database management

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer

Q1. What is difference between SQL and NoSQL
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases are table-based, NoSQL databases are document, key-value, graph, or wide-column stores

• SQL databases use structured query language for defining and manipulating data, NoSQL databases use different query languages

• SQL databases are vertically scalable, NoSQL databases are horizontally scalable

• SQL databa...read more
Answered by AI
Add your answer
Q2. Why is NoSQL better then SQL
Ans. 
NoSQL is better for handling unstructured data, providing scalability and flexibility.
• NoSQL databases are better suited for handling unstructured data like social media posts, user-generated content, and IoT data.

• NoSQL databases provide better scalability as they can easily distribute data across multiple servers, allowing for horizontal scaling.

• NoSQL databases offer more flexibility in terms of data model, allowing fo...read more
Answered by AI
Add your answer
Q3. Explain the data pipeline you have worked on.
Ans. 
Designed and implemented a real-time data pipeline for processing and analyzing user behavior data.
• Used Apache Kafka for real-time data streaming

• Utilized Apache Spark for data processing and analysis

• Implemented data transformations and aggregations using Scala

• Stored processed data in a data warehouse like Amazon Redshift

• Built monitoring and alerting systems to ensure data pipeline reliability
Answered by AI
Add your answer
Q4. Managing team
Add your answer
Q5. What will you do if you have conflict with your manager.
Ans. 
I would address the conflict directly and professionally, seeking to understand the root cause and find a mutually beneficial solution.
• Schedule a private meeting with the manager to discuss the conflict

• Listen actively to the manager's perspective and express your own calmly

• Seek to find common ground and propose potential solutions

• If necessary, involve HR or a mediator to help resolve the conflict
Answered by AI
Add your answer
Q6. What do you love to do when you are free
Ans. 
I love to spend my free time hiking, reading, and trying out new recipes in the kitchen.
• Hiking in the mountains or local trails

• Reading fiction and non-fiction books

• Experimenting with new recipes and cooking techniques
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Family background
Add your answer

Aptitude test for roughly around, 30-40 mins. Easy test.

Coding test on mettle. Good Data structure questions.

Q1. Basic Android questions like DI, MVVM, Clean architecture.
Add your answer
Q2. What is MVVM and design patterns
Ans. 
MVVM is a design pattern that separates the UI from the business logic, promoting code reusability and maintainability.
• MVVM stands for Model-View-ViewModel

• Model represents the data and business logic

• View is the UI components that the user interacts with

• ViewModel acts as a mediator between the Model and View, handling user inputs and updating the Model

• Design patterns are reusable solutions to common problems in software...read more
Answered by AI
Add your answer
Q3. Explain Clean Architecture
Ans. 
Clean Architecture is a software design approach that separates concerns and enforces a clear structure for code organization.
• Clear separation of concerns between different layers (e.g. presentation, domain, data)

• Dependency Rule: inner layers should not depend on outer layers

• Use of interfaces to define boundaries between layers

• Focus on testability and maintainability

• Examples: Hexagonal Architecture, Onion Architecture
Answered by AI
Add your answer
Q4. Explain solid principles
Ans. 
SOLID principles are a set of five design principles in object-oriented programming to make software designs more understandable, flexible, and maintainable.
• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be re...read more
Answered by AI
Add your answer
Q5. Intents in android
Ans. 
Intents in Android are messaging objects used to request an action from another app component.
• Intents are used to start activities, services, and broadcast receivers in Android.

• There are two types of intents: explicit intents and implicit intents.

• Explicit intents specify the component to start by name, while implicit intents specify the action to perform.

• Example: Intent intent = new Intent(this, SecondActivity.class);
Answered by AI
Add your answer

Length based question on train and pole, classic apti question from mettl were asked

Find longest repeated char from a string with count eg aaabbaa

10 min aptitude test

3 coding problem to solve on hackerrank

Multiple choice test

Q1. Technical interview
Add your answer

Q1. HR discussion and salary negotiations
Add your answer