Upload Button Icon Add office photos

Filter interviews by

Royal Finserv Junior Data Analyst Interview Questions and Answers

Updated 29 Mar 2024

Royal Finserv Junior Data Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Tell me something about your self
  • Q2. Why do you want to work with us
  • Q3. What is your achievements in your proffesional life
Round 2 - Technical 

(3 Questions)

  • Q1. What is the diffrence betwe.en credit and debit note
  • Ans. 

    Credit note is issued to reduce the amount payable by a customer, while debit note is issued to increase the amount payable by a customer.

    • Credit note is issued when a customer has been overcharged or returned goods, resulting in a reduction of the amount owed.

    • Debit note is issued when a customer has been undercharged or additional goods/services have been provided, resulting in an increase of the amount owed.

    • Credit not...

  • Answered by AI
  • Q2. Why do we use Macro
  • Ans. 

    Macros are used to automate repetitive tasks in Excel, saving time and reducing errors.

    • Automate repetitive tasks in Excel

    • Save time by reducing manual work

    • Reduce errors by eliminating human input

  • Answered by AI
  • Q3. Why do we use index and match
  • Ans. 

    Index and match are used in Excel to look up values in a table based on specific criteria.

    • Index and match are used together to perform a vertical lookup in Excel.

    • Index returns the value of a cell in a table based on the row and column numbers provided.

    • Match is used to find the position of a value in a range of cells.

    • Index and match are often used instead of VLOOKUP when dealing with large datasets or when the lookup va

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good place to work and upgrade skills.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

30 questions on critical thinking, reasoning

Round 2 - Technical 

(5 Questions)

  • Q1. The interview for the internship after that We join the company
  • Q2. Tell me about your self
  • Q3. Questions regarding projects
  • Q4. Why you wanna join this company
  • Q5. For Which role you want to work

Interview Preparation Tips

Topics to prepare for State Street Corporation Junior Data Analyst interview:
  • DSA
  • programming

Junior Data Analyst Interview Questions & Answers

Wells Fargo user image Pemmareddy Sreevardhan

posted on 22 Aug 2023

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Some basic excel and Rstudio
Round 3 - Technical 

(1 Question)

  • Q1. Questions on projects and ur analytical skills

I applied via Naukri.com and was interviewed in Jun 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. What is the main difference between data mining and data analysis?
  • Ans. 

    Data mining involves discovering patterns and relationships in large datasets, while data analysis focuses on interpreting and drawing insights from data.

    • Data mining is the process of extracting useful information from large datasets.

    • Data analysis involves examining and interpreting data to draw conclusions and make informed decisions.

    • Data mining uses techniques like clustering, classification, and association to disco...

  • Answered by AI
  • Q2. What is data validation?
  • Ans. 

    Data validation is the process of ensuring that data is accurate, complete, and consistent.

    • Data validation involves checking data for errors, inconsistencies, and anomalies.

    • It helps to ensure data quality and reliability.

    • Validation can be done through various techniques such as range checks, format checks, and cross-field validation.

    • Examples of data validation include verifying that a phone number has the correct numbe...

  • Answered by AI
  • Q3. Explain the main steps involved in data analysis ?
  • Ans. 

    Data analysis involves several steps including data collection, data cleaning, data exploration, data modeling, and data visualization.

    • Data collection: Gathering relevant data from various sources.

    • Data cleaning: Removing any errors, inconsistencies, or missing values from the data.

    • Data exploration: Analyzing the data to understand its characteristics and identify patterns or trends.

    • Data modeling: Applying statistical o...

  • Answered by AI
  • Q4. Explain what data cleansing is
  • Ans. 

    Data cleansing is the process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in datasets.

    • Data cleansing involves identifying and handling missing values in datasets.

    • It also includes removing duplicate records or entries.

    • Data cleansing may involve correcting spelling mistakes or formatting issues in data.

    • It helps improve data quality and reliability for analysis and decision-making.

    • E...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Why do you want to work at our company
Round 4 - Assignment 

Assignments based on data analyst

Interview Preparation Tips

Interview preparation tips for other job seekers - Encourage yourself up and stay positive :)

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I was interviewed before Oct 2023.

Round 1 - One-on-one 

(1 Question)

  • Q1. SQL query joins, cte,windows
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Group Discussion 

ABOUT YOURSELF ABOUT BUISNESS AND SOME LOAN RELATED QUESTIONS ETC

Interview Preparation Tips

Interview preparation tips for other job seekers - NO PROBLEM
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Solid principal
  • Q2. SOLID SRP OCP LSP ISP DIP
Round 3 - HR 

(2 Questions)

  • Q1. Salary disscus sio
  • Q2. Negotiable or not cleared the test

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Numerical aptitude methametics etc general knowledge

Round 2 - HR 

(2 Questions)

  • Q1. Normal question and basic information
  • Q2. Basic information
Round 3 - HR 

(2 Questions)

  • Q1. General knowledge basic information
  • Q2. Basic and introduction
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Aptitude Test 

It was good experience as a. Fresher

Round 3 - Technical 

(1 Question)

  • Q1. How are you feeling right now
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Wht is tuple and how it is dif from list
  • Ans. 

    A tuple is an immutable collection of elements, while a list is a mutable collection in Python.

    • Tuples are created using parentheses (), while lists are created using square brackets []

    • Tuples are immutable, meaning their elements cannot be changed once defined

    • Lists are mutable, allowing for elements to be added, removed, or modified

    • Tuples are typically used for fixed collections of items, while lists are used for dynami

  • Answered by AI

Skills evaluated in this interview

Royal Finserv Interview FAQs

How many rounds are there in Royal Finserv Junior Data Analyst interview?
Royal Finserv interview process usually has 2 rounds. The most common rounds in the Royal Finserv interview process are HR and Technical.
What are the top questions asked in Royal Finserv Junior Data Analyst interview?

Some of the top questions asked at the Royal Finserv Junior Data Analyst interview -

  1. What is the diffrence betwe.en credit and debit n...read more
  2. why do we use index and ma...read more
  3. Why do we use Ma...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
Axis Bank Interview Questions
3.8
 • 1.4k Interviews
Wells Fargo Interview Questions
3.9
 • 552 Interviews
Bajaj Finserv Interview Questions
4.0
 • 490 Interviews
HSBC Group Interview Questions
4.0
 • 485 Interviews
Xyz Company Interview Questions
3.8
 • 440 Interviews
American Express Interview Questions
4.2
 • 354 Interviews
View all
Sales Manager
15 salaries
unlock blur

₹1.8 L/yr - ₹6 L/yr

Manager
7 salaries
unlock blur

₹2.2 L/yr - ₹8 L/yr

Telecalling Executive
5 salaries
unlock blur

₹1.2 L/yr - ₹1.8 L/yr

Branch Manager
5 salaries
unlock blur

₹1.5 L/yr - ₹4.5 L/yr

Back Office Executive
5 salaries
unlock blur

₹2 L/yr - ₹2.2 L/yr

Explore more salaries
Compare Royal Finserv with

Bajaj Finserv

4.0
Compare

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Kotak Mahindra Bank

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview