Add office photos
i
Paytm
Compare
Filter interviews by
Paytm Data Analyst and Team Lead Interview Questions and Answers
Paytm Data Analyst and Team Lead Interview Experiences
1 interview found
Selected
I applied via Naukri.com and was interviewed before May 2023. There were 3 interview rounds.
(4 Questions)
- Q1. 1. Types of joins : i) Scenario of 2 tables and output rows of those cases
- Ans.
Types of joins in SQL include inner join, left join, right join, and full outer join.
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 either table.
Example: Inner join - SELE...
- Q2. 2. How to delete duplicate rows in SQL
- Ans.
Use the DELETE statement with a self-join to remove duplicate rows in SQL.
Use a self-join to identify duplicate rows based on a unique identifier column
Use the DELETE statement with the self-join condition to remove the duplicates
Example: DELETE FROM table_name WHERE id NOT IN (SELECT MIN(id) FROM table_name GROUP BY column1, column2)
- Q3. 3. Window functions difference?
- Ans.
Window functions are used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row
They can be used to calculate running totals, moving averages, rank, etc.
Examples include ROW_NUMBER(), RANK(), LAG(), LEAD()
- Q4. 4. Hackerrank medium level 1 question
(1 Question)
- Q1. Asked about yourself? When available to join and current salary?
(1 Question)
- Q1. Final Salary discussion
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Vishwesh Dayama
(2 Questions)
- Q1. SQL Joins and remove duplicates
- Q2. Function to create a transaction bin column
- Ans.
Create a function to generate a transaction bin column based on transaction amounts.
Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)
Use pandas cut() function in Python to create bins
Assign bin labels to the transactions based on the bin ranges
I applied via Referral and was interviewed in Nov 2024. There was 1 interview round.
Cancellation in the number of bookings in an app has increased exponentially in the past few weeks, How would you conduct an RCA on the same.
I applied via Instahyre and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Coding questions on Python and SQL
- Q2. Python basic DS questions
Selected
I applied via Referral and was interviewed in Oct 2024. There were 2 interview rounds.
Medium level questions
(2 Questions)
- Q1. Sorting Python question
- Q2. Hard SQL question
Selected
I applied via Referral and was interviewed in Sep 2024. There were 5 interview rounds.
1 python and 1 SQL coding along with ML questions mostly related to monitoring and basic ML
1 python code and also related to ML ...the recruiter came with a dataset to solve
Guestimates, project discussions and Case Studies
Project indepth discussion and case study related Fraud Detection
(1 Question)
- Q1. Aligning own interest with team requirement
Data Analyst Intern Interview Questions & Answers
Broadridge Financial Solutions
Anonymous
posted on 25 Oct 2024
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. Short cut keys of tools
- Ans.
Short cut keys are keyboard shortcuts that allow users to quickly perform actions in various tools.
Ctrl + C: Copy
Ctrl + V: Paste
Ctrl + X: Cut
Ctrl + Z: Undo
Ctrl + S: Save
Ctrl + P: Print
(1 Question)
- Q1. Project explanation in brief manner
- Ans.
Developed a predictive model to forecast sales based on historical data
Collected and cleaned historical sales data
Performed exploratory data analysis to identify trends and patterns
Built and trained machine learning model using regression techniques
Evaluated model performance using metrics like RMSE and MAE
(1 Question)
- Q1. Basic questions about resume
(2 Questions)
- Q1. Workplace adjustment questions
- Q2. Are you willing to work extra hours
(2 Questions)
- Q1. Internal external tables
- Q2. MySQL questions
(2 Questions)
- Q1. Spark question on optimization
- Q2. SQL writting and optimization
Paytm Interview FAQs
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
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Senior Data Analyst Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Team Lead
2k
salaries
|  ₹2 L/yr - ₹11.4 L/yr |
|
Senior Software Engineer
1.4k
salaries
| ₹10 L/yr - ₹41 L/yr |
|
Software Engineer
1.4k
salaries
| ₹6 L/yr - ₹23 L/yr |
|
Sales Executive
960
salaries
| ₹1 L/yr - ₹6.4 L/yr |
|
Senior Associate
901
salaries
| ₹2.1 L/yr - ₹9 L/yr |
BharatPe
Zerodha
Razorpay
Mobikwik
- Home >
- Interviews >
- Paytm Interview Questions >
- Paytm Data Analyst and Team Lead Interview Questions
