Mercury Laboratories Liquidity Analyst Interview Questions, Process, and Tips

Q1. Work experience
Add your answer
Q2. Process validation
Add your answer

Q1. Background of the organization
Ans. 
Our organization is a leading retail company specializing in high-quality fashion and accessories.
• Founded in 2005 by a group of fashion enthusiasts

• Over 100 stores nationwide

• Focus on sustainable and ethical sourcing practices

• Collaborations with renowned designers like Stella McCartney

• Strong online presence with e-commerce platform
Answered by AI
Add your answer
Q2. Product knowledge in the mfg site
Add your answer

Q1. Salary requirements
Add your answer
Q2. Time period of joining
Ans. 
I am available to start immediately.
• I can start as soon as possible.

• I am flexible with my start date.

• I am ready to join the team whenever needed.
Answered by AI
Add your answer

Q1. What is your current cost to company (CTC)?
Ans. 
My current CTC is confidential and I prefer not to disclose it.
• My current CTC is competitive based on industry standards.

• I am open to discussing my salary expectations for this role.

• I believe my skills and experience make me a strong candidate for this position.
Answered by AI
Add your answer

2/3 coding questions+technical questions on dbms,os,cn

Q1. Its much about managerial related to project kept in resume and some basic tech questions on skills kept in resume
Add your answer

Q1. Behavioural questions and few questions on project
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. What does your previous colleagues describe you?
Add your answer
Q3. Self introduction
Add your answer
Q4. General questions from resume
Add your answer

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. What projects have you handled?
Ans. 
I have handled various projects including implementing new sales strategies, launching new products, and improving customer service processes.
• Implemented new sales strategies to increase revenue by 15%

• Launched a new product line which resulted in a 20% increase in market share

• Improved customer service processes leading to a 30% decrease in customer complaints
Answered by AI
Add your answer
Q2. What challenges did you face while working on the project?
Ans. 
I faced challenges with coordinating team members, managing tight deadlines, and adapting to unexpected changes.
• Coordinating team members with different schedules and priorities

• Managing tight deadlines and ensuring all tasks were completed on time

• Adapting to unexpected changes in project scope or requirements
Answered by AI
Add your answer