Upload Button Icon Add office photos

Paytm Payments Bank

Compare button icon Compare button icon Compare

Filter interviews by

Paytm Payments Bank Business Analyst Interview Questions and Answers

Updated 19 Aug 2022

Paytm Payments Bank Business Analyst Interview Experiences

1 interview found

I applied via Job Portal and was interviewed in Feb 2022. There were 4 interview rounds.

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. 1. Introduce yourself 2. SQL Query using windows Function 3. What are different joins and there usage 4. Basic Questions on Excel 5. Difference between Data Analyst and Business Analyst
Round 3 - Technical 

(1 Question)

  • Q1. 1. Introduction 2. Explain any end to end live project you have done. 3. SQL Advanced queries using windows function. 4. SQL query using Windows function 5. Guestimate.
Round 4 - HR 

(1 Question)

  • Q1. 1. Introduce yourself. 2. Why do you want to change the company now. 3. Why Paytm 4. Salary Expectation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a great command on Writing SQL queries and Concepts of Excel

Interview questions from similar companies

I was interviewed in Aug 2017.

Interview Questionnaire 

1 Question

  • Q1. About my current status

Interview Preparation Tips

Round: HR Interview
Experience: I have discussed about present and able to attend the training

I applied via Recruitment Consultant and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Just started myself introduction.
  • Q2. Inform about myself and nothing so much they asked.

Interview Preparation Tips

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

I applied via Job Portal and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Difference between rank & dense rank
  • Ans. 

    Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.

    • Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

    • Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

    • For example, if there are two rows with the same value and rank 1, the n...

  • Answered by AI
  • Q2. Given two tables Tell how many values would be there for left right inner outer join
  • Ans. 

    The number of values in different types of joins depends on the relationship between the tables.

    • In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

    • In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...

  • Answered by AI
  • Q3. Find the newest customer id for every product
  • Ans. 

    Use SQL query to find the newest customer id for every product

    • Use GROUP BY clause to group by product

    • Use MAX() function to find the newest customer id for each product

    • Join the tables if necessary

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude reasoning quant and permutations and combinations

Round 2 - Group Discussion 

A topic was given for a group ..eg cryptocurrency is boon or bane

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and prepare accordingly for the role .
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Python was asked and data warehousing

Round 2 - One-on-one 

(2 Questions)

  • Q1. Data warehouses concept
  • Ans. 

    Data warehouses are centralized repositories that store integrated data from various sources for analysis and reporting.

    • Data warehouses are designed for query and analysis rather than transaction processing.

    • They consolidate data from multiple sources to provide a single, comprehensive view of the organization's data.

    • Data warehouses often use a dimensional model with facts (measurable, quantitative data) and dimensions ...

  • Answered by AI
  • Q2. Sql question was asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare databases well.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Referral and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

36 questions of cognitive ability

Round 2 - Group Discussion 

How social media is killing the creativity

Interview Preparation Tips

Interview preparation tips for other job seekers - Hey!
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql round question were asked
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Excel and spreadsheet
Round 2 - Technical 

(1 Question)

  • Q1. SQL and business understanding data handling
Round 3 - Technical 

(1 Question)

  • Q1. Problem solving
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Sql questions checking basic concepts
  • Q2. Excel task based questions

Paytm Payments Bank Interview FAQs

How many rounds are there in Paytm Payments Bank Business Analyst interview?
Paytm Payments Bank interview process usually has 4 rounds. The most common rounds in the Paytm Payments Bank interview process are Technical, Resume Shortlist and HR.
How to prepare for Paytm Payments Bank Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Paytm Payments Bank. The most common topics and skills that interviewers at Paytm Payments Bank expect are SQL, Business Analysis, Analytics, Python and Statistics.

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
Vodafone Idea Interview Questions
4.1
 • 551 Interviews
PhonePe Interview Questions
4.0
 • 297 Interviews
DBS Bank Interview Questions
3.8
 • 157 Interviews
City Union Bank Interview Questions
3.2
 • 87 Interviews
CSB Bank Interview Questions
3.2
 • 75 Interviews
View all
Paytm Payments Bank Business Analyst Salary
based on 26 salaries
₹8.1 L/yr - ₹9.1 L/yr
11% less than the average Business Analyst Salary in India
View more details

Paytm Payments Bank Business Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

5.0

Salary

3.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Associate
368 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
278 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
254 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
189 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
168 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Paytm Payments Bank with

Airtel Payments Bank

4.0
Compare

Fino Payments Bank

3.9
Compare

Jio Payments Bank

4.2
Compare

India Post Payments Bank

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview