Daewoong Pharmaceutical Interview Questions and Answers

Q1. Filters in Tableau
Ans. 
Filters in Tableau allow users to focus on specific data points within a visualization.
• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only
Answered by AI
Add your answer
Q2. Blending and joins in Tableau
Ans. 
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more
Answered by AI
Add your answer
Q3. LOD expressions in Tableau
Ans. 
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more
Answered by AI
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Ans. 
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual
Answered by AI
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Q1. Why are you switching?
Ans. 
Seeking new challenges and growth opportunities in a dynamic industry.
• Desire for new challenges and growth

• Interest in the dynamic nature of private equity

• Opportunity to expand skill set and knowledge

• Excitement for the potential to make a significant impact
Answered by AI
Add your answer
Q2. Tell me a time you took feedback procatively
Ans. 
I actively sought feedback from my manager after a project to improve my performance.
• Requested feedback from manager after completing a project

• Implemented suggestions for improvement

• Showed initiative in seeking feedback proactively
Answered by AI
Add your answer
Q3. Do you have experience in sales
Ans. 
Yes, I have experience in sales through my previous role as a sales representative.
• I have worked as a sales representative for XYZ company for 2 years

• I consistently exceeded sales targets by 20% each quarter

• I have experience in cold calling, client meetings, and negotiating deals
Answered by AI
Add your answer
Q4. What is understanding of private equity
Ans. 
Private equity involves investing in private companies to provide capital and expertise for growth.
• Private equity involves investing in private companies that are not publicly traded on the stock exchange

• Private equity firms raise funds from investors to acquire ownership stakes in companies

• The goal of private equity is to improve the performance and value of the companies in which they invest

• Private equity investors t...read more
Answered by AI
Add your answer

You will be given an assignment where you will be asked to interview and then make an excel sheet accordingly.

Q1. Tell me about your achievements?
Add your answer
Q2. Why you want to leave the current organization?
Add your answer

Bunch of quant probability questions

Bunch of dp and graph theory

Q1. How much brokerage you used to generate a day
Ans. 
I used to generate an average of $X in brokerage per day
• On average, I used to generate $X in brokerage per day

• The amount of brokerage generated per day varied based on market conditions and client activity

• For example, on a busy trading day, I could generate $Y in brokerage, while on a slow day it could be lower at $Z
Answered by AI
Add your answer
Q2. Total brokerage generationin a day
Ans. 
The total brokerage generation in a day is the sum of all the brokerage fees earned by the equity dealer from executing trades.
• Calculate the brokerage earned from each trade executed during the day

• Add up all the brokerage fees to get the total brokerage generation for the day

• Consider different types of trades and their respective brokerage rates

• Example: If a dealer earns $10 from Trade A, $15 from Trade B, and $20 from...read more
Answered by AI
Add your answer

Q1. What is capital market
Ans. 
Capital market is a financial market where long-term debt or equity-backed securities are bought and sold.
• Capital market facilitates the buying and selling of long-term financial instruments such as stocks, bonds, and other securities.

• It provides a platform for companies and governments to raise funds for their operations or projects.

• Investors can invest in capital market securities to earn returns through dividends, i...read more
Answered by AI
Add your answer
Q2. What is coporate action
Ans. 
Corporate action refers to an event initiated by a public company that impacts its shareholders and securities.
• Corporate actions can include dividends, stock splits, mergers, acquisitions, rights issues, and more.

• These actions can affect the value of securities, ownership structure, and voting rights of shareholders.

• Investors need to stay informed about corporate actions to make informed decisions about their investmen
Answered by AI
Add your answer