AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Paytm
Compare
Filter interviews by
Paytm Business Analyst Interview Questions, Process, and Tips
Top Paytm Business Analyst Interview Questions and Answers
- Q1. Sum of Squares of First N Natural Numbers Problem Statement You are tasked with finding the sum of squares of the first N natural numbers for given test cases. Input: Th ...read more
- Q2. What is the order of execution of SQL clauses?
- Q3. How do you find the count of visitors that came today and the count of new visitors that arrived today?
Paytm Business Analyst Interview Experiences
18 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Mar 2024. There were 3 interview rounds.
(2 Questions)
- Q1. What are diiferent types of join in sql ?
- Ans.
Different types of joins in SQL include inner join, left join, right join, and full outer 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.
Full outer join: Returns rows when there is a match in one of the tables.
- Q2. Difference between rank and dense_rank ?
- Ans.
Rank assigns unique ranks to each distinct row, while dense_rank assigns consecutive ranks to rows with the same values.
Rank leaves gaps in rank numbers if there are ties, while dense_rank does not
Rank function is used to assign unique ranks to each distinct row in the result set
Dense_rank function is used to assign consecutive ranks to rows with the same values
Example: If there are two rows with the same value, rank w...
(2 Questions)
- Q1. Project I have done
- Q2. Internship learning
(2 Questions)
- Q1. Work experience
- Q2. Behavioural Questions
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. SQL joins inner join, outer join and left join
- Q2. It was about window function , like we have to use row_number.....don't remberer exact question
PAWAN KUMAR
(2 Questions)
- Q1. SQL joins inner join, outer join and Inner join
- Q2. It was about window function, need to use Row_number
Abhayjyot Singh Grover
(1 Question)
- Q1. Sql joins like basic one
(1 Question)
- Q1. Case study on maruti suzuki
Paytm interview questions for designations
Sanyam Kapoor
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Why looking for change
- Ans.
Seeking new challenges and opportunities for growth and development.
Looking to expand skill set and knowledge in different industries
Interested in working on diverse projects with varying complexities
Seeking a more dynamic and stimulating work environment
Wanting to make a greater impact and contribute to innovative solutions
- Q2. Impactful tasks
Get interview-ready with Top Paytm Interview Questions
I applied via Referral and was interviewed in Jan 2024. There were 2 interview rounds.
SQL codes on window function and group by
(1 Question)
- Q1. SQL ,Data visualization, data analysis
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about your self. Tell about past background. About education and past employment.
- Q2. Advance Excel questions.
Interview Preparation Tips
(2 Questions)
- Q1. About projects i have written in resume
- Q2. Sql simple queries on window functions
(2 Questions)
- Q1. Asked few sql queries
- Q2. General discussions on my daily work in office
Interview Preparation Tips
(2 Questions)
- Q1. Tell me about yourself
- Q2. Explain my role in previous company
Suaib Akhtar
Selected
I was interviewed before Jan 2024.
(1 Question)
- Q1. Asked me to write a complex SQL query and 2-3 questions from Advanced excel.
(1 Question)
- Q1. Can you explain your previous projects and work experience?
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before Sep 2023. There were 2 interview rounds.
SQL and python questions on group by , joins and pivot were asked .
(2 Questions)
- Q1. How SQL joins work ?
- Ans.
SQL joins are used to combine rows from two or more tables based on a related column between them.
SQL joins are used to retrieve data from multiple tables based on a related column between them.
Types of SQL 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 rig...
- Q2. How group by function works ?
- Ans.
Group by function is used to group data based on a specific column or expression.
Group by function is used in SQL to aggregate data based on a specific column.
It is often used with aggregate functions like SUM, COUNT, AVG, etc.
For example, SELECT department, SUM(salary) FROM employees GROUP BY department will group employees by department and calculate the total salary for each department.
Skills evaluated in this interview
Top trending discussions
Paytm Interview FAQs
The duration of Paytm Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Paytm Interviews By Designations
- Paytm Software Engineer Interview Questions
- Paytm Team Lead Interview Questions
- Paytm Software Developer Interview Questions
- Paytm Senior Software Engineer Interview Questions
- Paytm Sales Executive Interview Questions
- Paytm Field Sales Executive Interview Questions
- Paytm Key Account Manager Interview Questions
- Paytm Business Analyst Interview Questions
- Show more
Paytm Business Analyst Interview Process
based on 15 interviews
2 Interview rounds
- Technical Round
- One-on-one Round
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Paytm Business Analyst Reviews and Ratings
based on 28 reviews
Rating in categories
|
Team Lead
2k
salaries
|  ₹2.2 L/yr - ₹11.4 L/yr |
|
Software Engineer
1.4k
salaries
| ₹6 L/yr - ₹23 L/yr |
|
Senior Software Engineer
1.4k
salaries
| ₹10 L/yr - ₹40 L/yr |
|
Sales Executive
946
salaries
| ₹1 L/yr - ₹6.4 L/yr |
|
Senior Associate
918
salaries
| ₹2.2 L/yr - ₹9 L/yr |
BharatPe
Zerodha
Razorpay
Mobikwik
- Home >
- Interviews >
- Paytm Interview Questions >
- Paytm Business Analyst Interview Questions
