Revolut Senior Analyst Interview Questions, Process, and Tips

Q1. What makes you right fit for company
Add your answer
Q2. Strength and weakness
Add your answer

SQL
Window functions lead and lead for retention

Quantitative aptitude, verbal ability, critical reasoning

Q1. SQL: find store with highest AOV
Add your answer
Q2. Generic behavioural questions
Add your answer

General SQL Question

Q1. General puzzle questions from GFG
Add your answer
Q2. Normal interview level SQL Question
Add your answer

Q1. There were lot of behavioral questions
Add your answer
Q2. Then there were few questions related to how to navigate through the data
Add your answer

Q1. Project related questions
Add your answer
Q2. Financial instruments knowledge
Add your answer

Q1. General project related questions
Add your answer
Q2. Financial domain in depth questions
Add your answer

Q1. SQL case study for data
Add your answer
Q2. Find nth salary
Add your answer

Q1. SQL Joins and remove duplicates
Add your answer
Q2. Function to create a transaction bin column
Ans. 
Create a function to generate a transaction bin column based on transaction amounts.
• Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)

• Use pandas cut() function in Python to create bins

• Assign bin labels to the transactions based on the bin ranges
Answered by AI
Add your answer

Q1. Difference between Order By and Group By
Ans. 
Order By is used to sort the result set in ascending or descending order, while Group By is used to group the result set by one or more columns.
• Order By is used with SELECT statement to sort the result set based on specified column(s)

• Group By is used with SELECT statement to group the result set based on specified column(s)

• Order By can be used with or without Group By, but Group By requires an aggregate function like C...read more
Answered by AI
Add your answer
Q2. Explain Normalisation concepts in detail
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It reduces data redundancy by eliminating duplicate data

• Normalization helps maintain data integrity by ensuring data is stored in a consistent manner

• There are different levels of normalization, such as First Normal Form (1NF), Second ...read more
Answered by AI
Add your answer
Q3. Difference between Primary and Unique
Ans. 
Primary key uniquely identifies a record in a database table, while a unique key ensures that all values in a column are different.
• Primary key is used to uniquely identify each record in a table

• Primary key does not allow NULL values

• Unique key ensures that all values in a column are different

• Unique key can have NULL values, but only one NULL per column
Answered by AI
Add your answer
Q4. Types of inheritance
Ans. 
Types of inheritance include single, multiple, multilevel, hierarchical, hybrid, and so on.
• Single inheritance: a class inherits from only one base class.

• Multiple inheritance: a class inherits from more than one base class.

• Multilevel inheritance: a class inherits from a class which in turn inherits from another class.

• Hierarchical inheritance: multiple classes inherit from a single base class.

• Hybrid inheritance: a combin...read more
Answered by AI
Add your answer

Q1. Joins outputs for various types of joins
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q2. Query using window functions
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations like ranking, moving averages, and cumulative sums.

• Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
Answered by AI
Add your answer