Purnartha Investment Advisors Equity Research Analyst Interview Questions and Answers

Q1. Type of Joins, Syntax of Join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Syntax of join: SELECT columns FROM table1 JOIN table2 ON table1.column = table2.column

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Q1. Introduction , knowledge about capital market
Add your answer

Nothing as such just basic

Logical, mathematical, profile based questions and derivatives

Q1. Basic introduction
Add your answer

Q1. Technical questions based on profile
Add your answer

Q1. Introduction work experience profile
Add your answer

Q1. Introduction in brief. About your last company. Why you want to change your job.
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced financial analyst with a strong background in financial modeling and data analysis.
• Over 5 years of experience in financial analysis

• Proficient in financial modeling and forecasting

• Skilled in data analysis and interpretation

• Strong attention to detail and problem-solving skills
Answered by AI
Add your answer
Q2. Why smbc and why this role
Ans. 
I chose SMBC because of its strong reputation in the financial industry and this role because of my passion for financial analysis.
• SMBC has a solid reputation in the financial industry, which aligns with my career goals.

• I am impressed by SMBC's commitment to innovation and growth in the financial sector.

• This role offers me the opportunity to utilize my skills in financial analysis and contribute to the success of the c
Answered by AI
Add your answer

Q1. Brief about experience
Add your answer
Q2. Roles and responsibilities
Add your answer

Q1. Questions related to finance
Add your answer
Q2. Financial ratios
Add your answer