PB Fintech Interview Questions and Answers

Q1. What factors influenced your decision to choose this company?
Add your answer
Q2. What is the total number of employees in the company?
Add your answer

Q1. Any insurance company work with you
Add your answer
Q2. What are your salary expectations?
Add your answer

5 sql coding questions from hacker rank. Basic sql questions, if you are experienced you will solve them in 15 to 20 min

Q1. How do you seperate name from emails for example *****,***** etc.. We need to get name form those mails in sql
Ans. 
Use SQL string functions like SUBSTRING and CHARINDEX to separate name from emails.
• Use CHARINDEX to find the position of the '@' symbol in the email address.

• Use SUBSTRING to extract the characters before the '@' symbol as the name.

• Consider handling cases where there are multiple names or special characters in the email address.
Answered by AI
Add your answer
Q2. There is a table matches which has team 1,team 2 and winner columns. Sample data like ind pak pak and pak ind ind and sl ban sl. So a team can play mutliple matches. Final output should be team, no of matc...read more
Ans. 
Calculate the number of matches won and lost by each team based on the given data in the matches table.
• Group the data by team and count the number of matches won and lost for each team.

• Use the winner column to determine the outcome of each match.

• Create a query to calculate the number of matches won and lost for each team.

• Example: Team A won 2 matches and lost 1 match.

• Example: Team B won 1 match and lost 2 matches.
Answered by AI
Add your answer
Q3. Table a has 1, 1,0,0,null and table b has 1,0,null,null. Resultant rows for all joins
Ans. 
The resultant rows for all joins between table a and table b with given values.
• Inner join: 1

• Left join: 1, 1, 0, 0, null

• Right join: 1, 0, null, null

• Full outer join: 1, 1, 0, 0, null, null
Answered by AI
Add your answer
Q4. Explain primary and secondary indexing. And more questions on indexing
Add your answer

Q1. Explain about your projects
Ans. 
I have worked on various projects involving data analysis, visualization, and predictive modeling.
• Developed predictive models to forecast sales trends and customer behavior

• Created interactive dashboards using Tableau for data visualization

• Performed data cleaning and preprocessing to ensure accuracy and consistency

• Utilized machine learning algorithms such as regression and clustering for analysis

• Collaborated with cross-...read more
Answered by AI
Add your answer
Q2. Follow up questions on projects
Add your answer
Q3. Write a query to seperate first name, midle name and last name from full name in sql
Ans. 
Use SUBSTRING_INDEX function in SQL to separate first name, middle name, and last name from full name.
• Use SUBSTRING_INDEX function to extract first name by specifying space as delimiter

• Use SUBSTRING_INDEX function to extract last name by specifying space as delimiter and -1 as position

• Use combination of SUBSTRING_INDEX and REPLACE functions to extract middle name if present
Answered by AI
Add your answer

Q1. L1 Manager Round Basic Question about Previous JOB & Task and your achivements & check fit Role
Add your answer

Q1. L2 Manager Round Technical about Insurance & Business Understanding about Data & Fitment Check along with Grooming .
Add your answer

Q1. HR Round & Fitment & Salary Releated .
Add your answer

After 3 sections of aptitude, English and core subjects, there were two coding problems both based on string one was easy and other was medium.

Q1. Explain the projects in your resume
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines
• Utilized HTML, CSS, JavaScript for front-end development

• Used PHP and MySQL for back-end functionality

• Implemented user authentication and authorization features

• Integrated calendar and notification system for task reminders
Answered by AI
Add your answer
Q2. Explain the backend side of your project
Ans. 
The backend of my project is responsible for handling server-side logic and data processing.
• Implemented RESTful APIs for communication between frontend and backend

• Used Node.js and Express for server-side scripting

• Utilized MongoDB for database management

• Implemented authentication and authorization using JWT tokens
Answered by AI
Add your answer
Q3. How did you implement concepts of OOP in your projects
Ans. 
I implemented concepts of OOP in my projects by creating classes, objects, inheritance, encapsulation, and polymorphism.
• Used classes to represent real-world entities

• Implemented inheritance to reuse code and create a hierarchy of classes

• Utilized encapsulation to hide data and restrict access to it

• Applied polymorphism to allow objects of different classes to be treated as objects of a common superclass
Answered by AI
Add your answer
Q4. How to handle duplicate entries in the database
Ans. 
Duplicate entries in the database can be handled by using unique constraints, deduplication scripts, or merging duplicate records.
• Use unique constraints in the database schema to prevent duplicate entries.

• Implement deduplication scripts to regularly scan and remove duplicate records.

• Merge duplicate records by updating one record with the information from the other duplicate record.
Answered by AI
Add your answer
Q5. Write a code to tell whether a string is palindrome or not
Ans. 
Code to check if a string is a palindrome or not
• Create a function that takes a string as input

• Remove all non-alphanumeric characters and convert to lowercase

• Compare the string with its reverse to check if it's a palindrome
Answered by AI
Add your answer

Q1. No Questions. Typing - Screen manipulation
Add your answer
Q2. Finding information using provided sources
Add your answer

Q1. Tell me about a time when you had to utilize multiple applications in order to process a claim.
Ans. 
I had to utilize multiple applications to process a claim for a customer who had both auto and home insurance policies.
• I accessed the auto insurance system to verify coverage and details of the claim.

• I then logged into the home insurance system to gather information on the property and any relevant policies.

• I used a claims processing software to input and track the details of the claim across both policies.

• I communicat...read more
Answered by AI
Add your answer
Q2. Are you willing to work occasional overtime when needed?
Ans. 
Yes, I am willing to work occasional overtime when needed.
• I understand the importance of meeting deadlines and am willing to put in extra hours when necessary

• I have previous experience working overtime and have been able to successfully manage my time and workload

• I am committed to the success of the team and am willing to go above and beyond to ensure tasks are completed on time
Answered by AI
Add your answer

Q1. Blood in RUA reasons
Add your answer
Q2. Changes need to adapt in underwriting manual
Ans. 
Underwriting manual should be regularly updated to adapt to changes in the industry.
• Regularly review and update underwriting guidelines to reflect current market trends and regulations

• Consider feedback from underwriters, actuaries, and other industry experts when making changes

• Ensure that underwriters are trained on any updates to the manual to maintain consistency and accuracy

• Monitor the performance of underwriting de
Answered by AI
Add your answer

Q1. Financial underwriting
Add your answer

Q1. Reimbursement claim Check delay reason Check intimation Check diagnosis Check claim form Check member id and patient id Check final bill and discharge summary Check payment receipt Check all investig...read more
Add your answer
Q2. Cashless claim Check intimation Check diagnosis Check policy coverage Check all claims documents (claim form discharge summary final bill breakup check tariff Check check capping Check mou discount ...read more
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why did you choose this subject in PG
Add your answer

Q1. Why change this job
Add your answer
Q2. What is salary except
Ans. 
Salary except refers to additional benefits or perks offered in addition to the base salary.
• Includes bonuses, commissions, stock options, and other forms of compensation

• May also include benefits such as healthcare, retirement plans, and paid time off

• Can vary depending on the company and industry

• Example: A salesperson may receive a base salary plus commission based on sales performance
Answered by AI
Add your answer

Q1. What is notice period
Ans. 
Notice period is the amount of time an employee must continue working after resigning before they can leave the job.
• Notice period is typically stated in the employment contract.

• It allows the employer time to find a replacement for the resigning employee.

• During the notice period, the employee is expected to fulfill their job responsibilities.

• The length of notice period can vary depending on the company and position.

• For ...read more
Answered by AI
Add your answer
Q2. When you can join
Ans. 
I can join within two weeks of receiving an offer.
• I am currently serving a two-week notice period at my current job.

• I need time to wrap up my current projects before starting a new role.

• I am available to start immediately if needed.
Answered by AI
Add your answer