Fino Payments Bank Interview Questions, Process, and Tips

Basic aptitude time and direction questions

Q1. Question on SQL , group by , how to remove duplicate rows , basic hr family questions
Add your answer
Q2. Type of joins inSQL
Ans. 
Different types of joins in SQL allow combining data from multiple tables based on specified conditions.
• Inner Join: Returns rows that have matching values 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 all rows when there is a match in either left ...read more
Answered by AI
Add your answer
Q3. How to remove duplicate rows from table
Ans. 
Use SQL query with DISTINCT keyword to remove duplicate rows from a table.
• Use SELECT DISTINCT * FROM table_name to retrieve unique rows.

• Use DELETE FROM table_name WHERE rowid NOT IN (SELECT MIN(rowid) FROM table_name GROUP BY column1, column2, ...); to delete duplicates.

• Use ROW_NUMBER() OVER(PARTITION BY column1, column2, ... ORDER BY column1) AS rn to assign row numbers and then delete rows with rn > 1.
Answered by AI
Add your answer

Q1. Our experience related questions and team helping
Add your answer
Q2. What is the importance of customer relationship management?
Ans. 
Customer relationship management is crucial for building loyalty, increasing customer satisfaction, and driving business growth.
• Enhances customer loyalty by building strong relationships

• Improves customer satisfaction through personalized interactions

• Drives business growth by increasing repeat purchases and referrals

• Helps in understanding customer needs and preferences

• Enables targeted marketing and communication strateg...read more
Answered by AI
Add your answer

Q1. I was asked for personal information
Add your answer
Q2. My qualification was asked
Add your answer

Q1. My work experience was asked
Add your answer
Q2. I was asked about my salary
Add your answer

Sorting of linked list
Find the number of strings which are substrings of a given big string

Q1. Where do you see 5 years from now
Ans. 
In 5 years, I see myself as a senior Build Engineer leading a team of developers, implementing cutting-edge technologies, and streamlining the build process.
• Leading a team of developers in implementing new technologies

• Streamlining the build process for efficiency

• Continuing professional development to stay current with industry trends
Answered by AI
Add your answer
Q2. How do you come to know about our company
Ans. 
I came to know about your company through a job search website.
• I found your company listed on a job search website like Indeed or Glassdoor.

• I read about your company in a job posting on LinkedIn.

• A friend or colleague recommended your company to me.

• I researched companies in the industry and came across yours.
Answered by AI
Add your answer