Commonwealth Bank of Australia, India Senior PMO Analyst Interview Questions and Answers

The test will comprise a total of 60 questions, divided as follows: 70% of the questions will focus on finance and accounting, while the remaining questions will cover aptitude and English.

Q1. Zero coupon bonds, long-term liabilities, return on equity, debt-equity ratio, captial budgeting and techniques, bonds and its types, debt instruments meaning, collateral, mortgage, spin off, demerger, mer...read more
Add your answer

Q1. 4-5 SQL questions- Max price, categories in a retail store, no. of products bought per customer, joins, basic python
Add your answer
Q2. Guesstimate: no. of amex credit card users in India. Follow up questions to test business acumen and understanding of the business
Add your answer

Q1. What is shares and kind of shares
Add your answer
Q2. Name different stock exchange internationally
Add your answer

Q1. Explain CDS and credit risk
Ans. 
CDS stands for Credit Default Swap, a financial derivative used to transfer credit risk between parties.
• CDS is a type of insurance contract where one party pays a premium to another party in exchange for protection against a credit event, such as default or bankruptcy.

• The buyer of a CDS makes periodic payments to the seller, who agrees to compensate the buyer in the event of a credit event on a specified reference asse...read more
Answered by AI
Add your answer
Q2. Explain option strategies
Ans. 
Options strategies involve buying and selling options contracts to achieve specific investment goals.
• Buy Call Option: Bullish strategy where investor expects the price of the underlying asset to rise.

• Buy Put Option: Bearish strategy where investor expects the price of the underlying asset to fall.

• Covered Call: Selling a call option while holding the underlying asset to generate income.

• Straddle: Buying both a call and p...read more
Answered by AI
Add your answer

Q1. Questions regarding previous work experience
Add your answer

Q1. Explain different option strategies
Ans. 
Options strategies involve buying or selling options contracts to achieve specific investment goals.
• Some common options strategies include covered calls, protective puts, straddles, and iron condors.

• Covered calls involve selling call options on a stock you own to generate income.

• Protective puts involve buying put options to protect against a decline in the value of a stock.

• Straddles involve buying both a call and a put...read more
Answered by AI
Add your answer

Q1. They first asked the basic like introduction, education , scenarios based question
Add your answer
Q2. They asked what all things were there in job description and related questions
Add your answer

Q1. Can you describe your day-to-day activities?
Ans. 
As a Senior Analyst, my day-to-day activities involve conducting data analysis, creating reports, presenting findings to stakeholders, and providing insights for decision-making.
• Conducting data analysis on various datasets

• Creating reports based on analysis findings

• Presenting findings to stakeholders

• Providing insights and recommendations for decision-making

• Collaborating with team members on projects
Answered by AI
Add your answer
Q2. What is the concept of swing trading in the financial markets?
Ans. 
Swing trading is a trading strategy that aims to capture short- to medium-term gains in a stock or financial instrument.
• Swing traders typically hold a position for a few days to several weeks, as opposed to day traders who hold positions for just a few hours.

• They aim to profit from the 'swings' or price movements in the market, buying at support levels and selling at resistance levels.

• Swing trading involves analyzing t...read more
Answered by AI
Add your answer

IT WAS Difficult and i gave up

Q1. Linked list search binary
Add your answer
Q2. Array search and traverse
Add your answer

Q1. Get the maximum salary of the employee from the employee and department table
Add your answer
Q2. Explain the data analysis process that you would follow for employee salary table
Ans. 
The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.
• Start by cleaning the data to remove any duplicates, missing values, or outliers.

• Explore the data by calculating basic statistics like mean, median, and standard deviation.

• Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.

• Perform statistical modeling to an...read more
Answered by AI
Add your answer
Q3. Explain the challenges you faced in your project
Ans. 
I faced challenges in managing large datasets and ensuring data accuracy in my project.
• Managing large volumes of data from multiple sources

• Ensuring data accuracy and consistency

• Dealing with missing or incomplete data

• Handling data cleaning and preprocessing tasks

• Addressing technical issues with data storage or processing tools
Answered by AI
Add your answer