Paytm Payments Bank Interview Questions, Process, and Tips

Q1. Interview with HR Ritika Asked about my job profile, my home location, my previous job profile, about my family . Inform me about paytm job .
Add your answer

Q1. Interview with Vikrant Chaudhary, asked about my whole work profile, my family, my behaviour, let read some English paragraph to find out english understand. Also tell me about work profile in paytm payme...read more
Add your answer

Q1. Interview done with Shakti singh sir . Asked about family background,all work profile, work timings, work target.
Add your answer

Q1. 1. Tell me about yourself
Ans. 
I am a highly experienced data scientist with a strong background in analytics and team leadership.
• I have over 10 years of experience in data science and analytics.

• I have successfully led teams in developing and implementing data-driven solutions.

• I am proficient in various programming languages and statistical analysis tools.

• I have a track record of delivering actionable insights and driving business growth through dat...read more
Answered by AI
Add your answer
Q2. 2. What experience do you have working on SQL, Excel
Ans. 
I have extensive experience working on SQL and Excel.
• Proficient in writing complex SQL queries for data extraction and manipulation

• Expertise in data analysis and visualization using Excel

• Experience in creating dashboards and reports using Excel

• Familiarity with advanced Excel functions such as VLOOKUP, Pivot tables, etc.
Answered by AI
Add your answer

Q1. 1. Tell me about different type of joins
Ans. 
Different types of joins are inner join, left join, right join, and full outer join.
• Inner join returns only the matching rows from both tables

• Left join returns all the rows from the left table and matching rows from the right table

• Right join returns all the rows from the right table and matching rows from the left table

• Full outer join returns all the rows from both tables, with NULL values in the columns where there is...read more
Answered by AI
Add your answer
Q2. 2. When do you use where clause/ having Clause
Ans. 
Where clause is used to filter rows based on a condition, while having clause is used to filter groups based on a condition.
• Where clause is used with SELECT, UPDATE, DELETE statements.

• Having clause is used with GROUP BY clause.

• Where clause filters rows before grouping, while having clause filters groups after grouping.

• Where clause can use any comparison operator, while having clause can only use aggregate functions.

• Exa...read more
Answered by AI
Add your answer
Q3. 3. Order of execution of an SQL statement
Ans. 
SQL statements are executed in a specific order to ensure accuracy and efficiency.
• FROM and JOIN clauses are executed first to retrieve data from tables

• WHERE clause is executed next to filter the data

• SELECT clause is executed to retrieve specific columns

• GROUP BY clause is executed to group the data based on specified columns

• HAVING clause is executed to filter the grouped data

• ORDER BY clause is executed to sort the data

• L...read more
Answered by AI
Add your answer
Q4. What environment and tech are you used to working on?
Ans. 
I am used to working in a variety of environments and with various technologies.
• I have experience working in both on-premises and cloud environments.

• I am proficient in programming languages such as Python and R.

• I am familiar with data analysis and visualization tools like Tableau and Power BI.

• I have worked with big data technologies like Hadoop and Spark.

• I am comfortable working with SQL databases and querying data.

• I h...read more
Answered by AI
Add your answer

Q1. 1. Similar questions as round 2
Add your answer
Q2. Asked to write a query that used combination of case statements and aggregate functions + group by clause
Add your answer

3 Coding problems to be solved in 90 minutes.

Q1. Introduction, Project Discussion, HTML Tags, Reverse a string, Level order traversal in a binary tree, Minimum swap operations to sort an array.
Add your answer

Q1. N-Queen problem, Coin Change, Number of Islands
Add your answer

Q1. Why you will to change your current job
Add your answer
Q2. What is your 5 best skill
Add your answer

Q1. Normal Details - Personal, Professional
Add your answer

Q1. What Role and Responsibilities and asked about their organization, which they searching for
Add your answer
Q2. About your Last Organization
Add your answer

Q1. Technical round related to your resume
Add your answer