PSW GLOBAL SOLUTIONS Interview Questions and Answers

SQL, QA skills, finance, API, logics

Q1. QA skills was asked automation manual.
Add your answer
Q2. SQL questions was asked.
Add your answer

Coding round with 4 coding problem

Q1. Interviewer give coding problems which we have to solved face to face
Add your answer

Q1. Then question answer regarding coding language and you knowledge regarding programming
Add your answer

30min- Analytical questions

Q1. Everyhting from resume
Add your answer
Q2. What is your experience
Add your answer
Q3. Sql,powerbi, python
Add your answer
Q4. Explain your resume
Add your answer

Q1. Why should i hire you situation based questions
Add your answer

Haacker Rank Test - 3 question . 2 questions were coding and 1 SQL query

Q1. Automatic Parking System - LLD -> class diagram, APIs , models and sequence diagram
Add your answer

Q1. What is securitization?
Ans. 
Securitization is the process of converting illiquid assets into marketable securities.
• Securitization involves pooling together assets such as mortgages, auto loans, or credit card debt.

• These assets are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the assets.

• Investors can then buy these securities, which offer a return based on the cash flows from the underlying ass...read more
Answered by AI
Add your answer
Q2. Walk me through your CV
Add your answer
Q3. How do you arrive at the terminal growth rate while preparing a financial model?
Ans. 
The terminal growth rate is arrived at by considering the long-term growth prospects of the company.
• Consider the industry growth rate and the company's historical growth rate

• Analyze the company's competitive position and market share

• Evaluate the company's future investment plans and potential for expansion

• Take into account any regulatory or economic factors that may impact growth

• Use a range of values to account for unc
Answered by AI
Add your answer
Q4. If you have two ropes that burn in 60 seconds but not at the same rate. They burn unevenly. Given a match and the two ropes how would you figure out the 45 seconds mark?
Add your answer
Q5. Explain indirect and offset functions in excel
Ans. 
Indirect and Offset are functions in Excel used to reference cells or ranges indirectly.
• Indirect function is used to reference a cell or range using a text string that contains the cell or range address.

• Offset function is used to reference a cell or range that is a specified number of rows and columns away from a given cell or range.

• Both functions are useful for creating dynamic formulas that can be updated easily.

• Exam...read more
Answered by AI
Add your answer
Q6. What do you understand by loan servicing?
Ans. 
Loan servicing refers to the management of loans after they have been issued.
• It involves collecting payments from borrowers, managing escrow accounts, and handling delinquencies and defaults.

• Loan servicing can be done by the lender or a third-party servicer.

• Servicers may also provide customer service and support to borrowers.

• Examples of loan types that require servicing include mortgages, student loans, and auto loans.
Answered by AI
Add your answer

Q1. What's spark and what is it used for?
Ans. 
Spark is a distributed computing framework used for big data processing and analytics.
• Spark is an open-source framework developed by Apache Software Foundation.

• It is used for processing large datasets in a distributed computing environment.

• Spark provides APIs for programming in Java, Scala, Python, and R.

• It supports various data sources including Hadoop Distributed File System (HDFS), Cassandra, and Amazon S3.

• Spark inc...read more
Answered by AI
Add your answer
Q2. How to handle a difficult and vague client requirement?
Ans. 
Listen actively, ask clarifying questions, and provide options based on their needs.
• Listen actively to understand their needs and concerns.

• Ask clarifying questions to get more information.

• Provide options based on their needs and limitations.

• Collaborate with the client to come up with a solution.

• Document the requirements and get their approval.
Answered by AI
Add your answer

Q1. Real time discussions
Add your answer

Q1. BD, p&l, team mgmt, client success stories
Add your answer