RWS Group Senior Software Engineer Interview Questions and Answers

Q1. Architecture discussion around projects
Add your answer

Q1. Caching, auth discussion in depth
Add your answer

Q1. Android interview asked about coroutines, flow, why we use MVVM instead of MVP, viewmodel pros and cons, security and how to hide keys in package
Add your answer

2nd round was about again Android but more focused on security features of android

3rd round was live coding . I was asked to make an app from scratch in 1 hour without even using google.

Fundamentals of Data Structures and Algorithms, including SQL.

Q1. Basics of DSA and Algo and sql
Add your answer
Q2. Basics
Add your answer

Q1. Details on previus project
Add your answer
Q2. B
Add your answer

Q1. Basics of DSA and algo ..sql
Add your answer

Q1. Regarding all basic java , sprint boot questions
Add your answer
Q2. More focused on Spring and microservices
Add your answer

Q1. Advance java questions
Add your answer

Q1. Simple task to fetch cart and display items in the cart
Ans. 
Fetch cart items and display them
• Create a function to fetch cart items from database

• Display the items in the cart on the user interface

• Handle empty cart scenarios

• Consider pagination for large number of items
Answered by AI
Add your answer
Q2. React hooks, life cycle methods, error boundaries, hoc
Add your answer

Q1. Simple task to fetch characters and their movies
Ans. 
Fetch characters and their movies
• Use API like IMDb or The Movie Database to fetch movie data

• Parse the data to extract characters and their associated movies

• Store the characters and movies in an array of strings
Answered by AI
Add your answer

Q1. Culture based questions
Add your answer

Q1. Explain advantages of Angular
Ans. 
Angular offers advantages such as two-way data binding, dependency injection, and modular architecture.
• Two-way data binding allows automatic synchronization of data between the model and the view, reducing the need for manual DOM manipulation.

• Dependency injection helps manage dependencies and promotes code reusability by allowing components to be easily injected with their dependencies.

• Modular architecture enables deve...read more
Answered by AI
Add your answer
Q2. Explain about ngmodel
Ans. 
ngModel is a directive in AngularJS that binds the value of HTML controls to application data.
• ngModel is used for two-way data binding in AngularJS.

• It can be used with input, select, textarea, and custom form controls.

• Example:
Answered by AI
Add your answer

Q1. Java coding questions
Add your answer
Q2. Core java and spring questions
Add your answer

Q1. Salary expectation
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

Q1. Asked to explain past project and contribution
Add your answer
Q2. Write sql querying to count employees per department
Ans. 
SQL query to count employees per department
• Use GROUP BY clause to group employees by department

• Use COUNT() function to count the number of employees in each department

• Join the employee table with the department table if necessary
Answered by AI
Add your answer
Q3. Write a program using Java Stream API
Ans. 
Program using Java Stream API to filter even numbers from a list
• Create a list of numbers

• Use stream() method to convert list to stream

• Use filter() method with lambda expression to filter even numbers

• Collect the filtered numbers using collect() method
Answered by AI
Add your answer
Q4. Questions related to Java 8 features
Add your answer