Technical Analyst

A vessel is filled with liquid, 3 parts of which are water and 5 parts syrup. How much of the mixture must be drawn off and replaced with water so that the mixture may be half water and half syrup?

In what ratio must a grocer mix two varieties of pulses costing Rs. 15 and Rs. 20 per kg respectively to get a mixture worth Rs. 16.50 kg?

Write a SQL query to fetch “FIRST_NAME” from the Student table in upper case and use ALIAS name as STUDENT_NAME.

Write a SQL query to find the second-highest salary from an employee table.

What are super, primary, candidate, and foreign keys?

What problem do we face in computer systems without OS?

What are the uses of view? (Learn)

Client goal:-
Our client is Beautify. Beautify has approached McKinsey for help with exploring new ways to approach its customers.

Situation description:-
Beautify is a global prestige cosmetics company that sells its products mainly inside high-end department stores such as Harrods and Shanghai No. 1. It also has a presence online with speciality retailers like Sephora. Beautify produces a number of makeup, fragrance, and skin care products sold under several different brands.

In department stores, beauty consultants play a critical role with consumers:

approaching “passive” customers
demonstrating their knowledge of the products
actively selling the products
maintaining a loyal customer base of repeat buyers
These consultants are hired directly by Beautify or through specialist, third-party agencies that find new recruits for a fee. Beautify is then responsible for selecting, training, and paying the consultants. Within Beautify, beauty consultants are managed independently by each brand in each country. For example, this may mean a consultant might be part of the Chanel team in a store. However, consumers are shifting more to online shopping, and too many beauty consultants are left working in empty department stores.

Can you work under pressure?

If we hire you, what value can you bring to the position?