AQM Technologies Capital Market Analyst Interview Questions and Answers

There are approximately 70,000 petrol bunks in India.

• India has a population of over 1.3 billion people, and a large number of them own vehicles.

• The number of petrol bunks varies from state to state, with some having more than others.

• According to a report by the Petroleum Planning and Analysis Cell, there were 69,648 petrol bunks in India as of January 2021.

Approximately 10 million cricket balls are sold in India every year.

• Consider the number of cricket matches played in India each year

• Take into account the number of cricket academies and schools in India

• Factor in the popularity of cricket in India

• Assume an average lifespan of a cricket ball

• Approximately 10 million cricket balls are sold in India every year

I am a highly motivated and detail-oriented business analyst with experience in data analysis and project management.

• Experienced in data analysis and project management

• Highly motivated and detail-oriented

• Strong communication and problem-solving skills

Short term goal is to gain experience and contribute to the company's success. Long term goal is to become a respected industry expert.

• Short term goal: Gain experience and contribute to company's success

• Long term goal: Become a respected industry expert

• Examples: Attend industry conferences, take on challenging projects, seek mentorship

No major issues working in Gurgaon.

• Traffic congestion during peak hours

• Limited public transportation options

• High cost of living compared to other cities

• Pollution levels can be high

• Availability of skilled resources

Develop a market entry strategy for new player XYZ.

• Conduct market research to identify target audience and competition.

• Develop a unique value proposition and brand identity.

• Determine pricing strategy and distribution channels.

• Create a marketing plan to build brand awareness and attract customers.

• Establish partnerships with local businesses and organizations.

• Consider regulatory and legal requirements for entering the ma...read more

Market sizing of red cars in a village.

• Determine the total number of cars in the village

• Estimate the percentage of cars that are red

• Calculate the number of red cars based on the percentage

• Consider any factors that may affect the accuracy of the estimate

• Use data from previous years or neighboring villages for comparison

SQL is a programming language used to manage and manipulate relational databases.

• Use SELECT statement to retrieve data from tables

• Use WHERE clause to filter data based on conditions

• Use JOIN to combine data from multiple tables

• Use GROUP BY to group data based on a column

• Use ORDER BY to sort data based on a column

Major data analytics tools include Tableau, Power BI, SAS, R, Python, Excel, and Google Analytics.

• Tableau

• Power BI

• SAS

• R

• Python

• Excel

• Google Analytics

I have worked with Java, Python, and SQL.

• Proficient in Java for developing enterprise applications

• Experience in Python for data analysis and automation

• Skilled in SQL for database management and querying