Greenway Health Senior Analyst Interview Questions and Answers

A question that is both tricky and simple.

Q1. Questions about biochemistry
Add your answer

Questions based on both numerical data and case studies.

Q1. Can you tell me about yourself?
Add your answer
Q2. What interests you in working for this company?
Ans. 
I am interested in working for this company because of its innovative projects and strong reputation in the industry.
• Innovative projects that challenge me to grow as a programmer

• Strong reputation in the industry for quality work

• Opportunities for career advancement and professional development
Answered by AI
Add your answer

Pretty standard GD on topics around working remotely and country's macroeconomic

Q1. Derivative Knowledge Check
Add your answer
Q2. Alternate Investment Knowledge Check
Add your answer

Q1. Scenario Based and financial instrument level
Add your answer
Q2. Deep dive into derivative and alternative investment
Ans. 
Derivative and alternative investments involve complex financial instruments and strategies beyond traditional stocks and bonds.
• Derivatives are financial contracts whose value is derived from an underlying asset, index, or rate. Examples include options, futures, and swaps.

• Alternative investments are non-traditional assets such as private equity, hedge funds, real estate, and commodities.

• Both derivative and alternative...read more
Answered by AI
Add your answer

Q1. General HR Question
Add your answer
Q2. Strength and Weakness
Add your answer

The aptitude round was easy consisting of three sections

The second aptitude test was conducted by the HR of the company.

Q1. Behaviour based questions
Add your answer
Q2. Situation based questions
Add your answer
Q3. Aptitude based questions
Add your answer

Q1. Highlight the odd cells in excel
Ans. 
Use conditional formatting to highlight odd cells in Excel
• Select the range of cells you want to highlight

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose 'New Rule' and select 'Use a formula to determine which cells to format'

• Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

• Choose the formatting style you want for the odd cells
Answered by AI
Add your answer
Q2. What are Joins in SQL, explain different joins and their outputs
Ans. 
Joins in SQL 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

• INNER JOIN returns rows when there is at least one match 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

• FU...read more
Answered by AI
Add your answer
Q3. Query to give running sum of salary
Ans. 
Use window function to calculate running sum of salary in SQL
• Use window function like SUM() with OVER() clause

• Partition the data by employee ID if needed

• Order the data by date or any other relevant column
Answered by AI
Add your answer

Q1. What is role of business analyst in different industries?
Add your answer

Easy qstns with java and sql

Coding qstn based on your perferred language