Revolut Senior Analyst Interview Questions, Process, and Tips

Q1. What makes you right fit for company
Ans. 
My extensive experience in data analysis, strong analytical skills, and ability to communicate complex findings make me the right fit for the company.
• 10+ years of experience in data analysis

• Proven track record of delivering actionable insights

• Strong analytical skills and attention to detail

• Excellent communication skills to present findings to stakeholders

• Ability to work effectively in a team environment
Answered by AI
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. SQL Joins and remove duplicates
Add your answer
Q2. Function to create a transaction bin column
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

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a 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.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Q1. Common question like about yourself
Add your answer
Q2. Questions like stlc and roles responsibilities
Add your answer
Q3. How to do uat testing
Ans. 
UAT testing involves testing the system in a real-world scenario by end users to ensure it meets their requirements.
• Understand the requirements and scope of the system

• Create test cases based on user scenarios

• Execute test cases with real users

• Document and report any issues found

• Obtain user feedback for improvements
Answered by AI
Add your answer
Q4. What is agile process
Ans. 
Agile process is a project management approach that emphasizes flexibility, collaboration, and incremental development.
• Agile process involves breaking down projects into small, manageable tasks called user stories.

• It focuses on frequent communication and collaboration between team members.

• Iterations, or sprints, are used to deliver working software in short timeframes.

• Adaptability and responding to change are key princ...read more
Answered by AI
Add your answer
Q5. What kind of testing is done in past
Ans. 
Various types of testing were conducted in the past including functional testing, regression testing, performance testing, and user acceptance testing.
• Functional testing to ensure the software functions as expected

• Regression testing to check for any new bugs introduced after changes

• Performance testing to assess the speed and stability of the software

• User acceptance testing to validate if the software meets user require
Answered by AI
Add your answer

Basic coding questions based on array, strings were asked.

Q1. Explain doubly linked list. And one coding question was asked about doubly linked list and I had to explain the solution.
Add your answer
Q2. HR round was covered in this round only so interviewer asked me some HR round questions.
Add your answer