Paytm (One97 Communications Limited) interview experience Real time questions & tips from candidates to crack your interview

Business Analyst

Paytm (One97 Communications Limited)
upvote
share-icon
3 rounds | 8 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 12 Months
Topics: SQL , Python, Machine Learning, Statistics, Guestimates, Probability, Puzzles
Tip
Tip

Tip 1 : Do prepare well for SQL ..for theory concepts learn from W3SCHOOLS and practice it from Hackerrank.
Tip 2 : Try to do one end to end Machine learning project.
Tip 3 : Apart from technical, business understanding is also important so read some business case study and solve guestimates.

Application process
Where: Other
Eligibility: No criteria
Resume Tip
Resume tip

Tip 1 : Mention your GitHub profile 
Tip 2 : Project related to machine learning can definitely help you in shortlisted.

Interview rounds

01
Round
Medium
Video Call
Duration60 Minutes
Interview date1 May 2021
Coding problem2

Interview was in afternoon.
The interviewer was very polite and clearly explained me each and every detail about the questions.

1. Sum Of Squares Of First N Natural Numbers

Easy
15m average time
85% success
0/40
Asked in companies
SamsungPaytm (One97 Communications Limited)Sprinklr

You are given an integer 'N'. You need to find the sum of squares of the first 'N' natural numbers.

For example:
If 'N' = 4. You need to return 1^2 + 2^2 + 3^2 + 4^2 = 30.
Try solving now

2. Technical Questions

Given a dataframe ..how to filter the and aggregate the data using pandas

What is linear Regression and assumptions

02
Round
Medium
Video Call
Duration30 minutes
Interview date7 May 2021
Coding problem3

Interview was in the afternoon. 
Interviewer was very friendly.

1. DBMS Question

What is the order of execution of sql clause.

2. DBMS Question

Finding the count of visitors that came today and count of new visitors that come today

3. DBMS Question

Find the Department wise highest salary of the employees.

03
Round
Medium
Video Call
Duration90 Minutes
Interview date12 May 2021
Coding problem3

Interview held in the evening.
There were two interviewer.
One was asking the technical questions related to sql and python and other related to business case study and Machine learning.

1. DBMS Question

Find the salary of each employee per month.

2. ML Question

What is underfitting and overfitting of ML models

3. ML Question

Explain the concept of Random Forest

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

To make an AI less repetitive in a long paragraph, you should increase:

Choose another skill to practice
Similar interview experiences
company logo
Business Analyst
3 rounds | 5 problems
Interviewed by Paytm (One97 Communications Limited)
1314 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 3 problems
Interviewed by Paytm (One97 Communications Limited)
923 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 5 problems
Interviewed by Paytm (One97 Communications Limited)
716 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 8 problems
Interviewed by Paytm (One97 Communications Limited)
522 views
0 comments
0 upvotes