ZS Senior Associate Consultant Interview Questions and Answers

Basic sql and Qlik questions

Q1. Great interview basic Sql question and join keep and different commponents of qliksense
Add your answer

Q1. Case studies on insurance sector
Add your answer

Q1. Case study on FMCG sector
Add your answer

Q1. About manual and Automation testing
Add your answer

Q1. Questions around project management were asked
Add your answer

Again aptitude and analytical abilities were tested

Q1. Show architecture of multiple microservice in MS Paint..
Add your answer
Q2. Why we use dependency injection, draw it inms paint...,first told me give real life example and when I gave the answer he cut me off again..
Add your answer

Q1. Questions related to Smart metering technology and integration of Smart meters with HES and MDM
Add your answer
Q2. Challenges faced during the project implementation and how were those addressed
Add your answer
Q3. API integration process and test cases
Add your answer
Q4. Smart metering standards and polices
Add your answer
Q5. Questions related to MS project ,MS PPT,MS word and Excel.
Add your answer

Q1. Question related to communication skills and behavioral skills
Add your answer
Q2. Salary negotiation
Add your answer
Q3. Discussions on benefits other than salary compensation
Add your answer

Q1. Introduce yourself and your experience
Add your answer
Q2. Explain the Software Testing Lifecycle
Add your answer
Q3. Explain SQL joins
Add your answer
Q4. Which python libraries do you use for data analysis and visualization and why?
Add your answer

Was shared a dataset and had to answer the following questions:
Q1. Write a query to calculate the recovery rate and mortality rate.
Q2. Find out the top 5 states with 20% active cases and declining new cases in Feb 2022, July 2022, and Sept 2022.
Q3. Write a query to obtain relevant records from the state name table ordered by state name in ascending order and date in descending order.
q4. When did the cases in India cross 30 Lakhs?
Q5. Create a dashboard for recovered case trends and mortality death trends

Q1. Introduce yourself and your experience.
Add your answer
Q2. Are you comfortable relocating to Delhi Location?
Add your answer

Q1. Introduce yourself and your experience.
Add your answer
Q2. Do you know how to build a dashboard?
Add your answer
Q3. Are you an immediate joiner?
Add your answer

Market sizing and entry strategy

Q1. Why do you want to pursue in this role?
Add your answer
Q2. How do you do a cold call?
Ans. 
A cold call involves reaching out to potential clients or customers without any prior contact or relationship.
• Research the company or individual you are calling to tailor your pitch

• Introduce yourself and explain the purpose of your call

• Highlight the benefits of your product or service

• Handle objections professionally and try to schedule a follow-up meeting

• Follow up with an email or additional information as needed
Answered by AI
Add your answer

Q1. What is commercial due diligence?
Ans. 
Commercial due diligence is the process of evaluating a company's commercial potential and risks before making an investment or partnership.
• Involves analyzing market trends, competition, customer base, and growth potential

• Assesses the target company's business model, revenue streams, and key performance indicators

• Helps investors make informed decisions by identifying potential opportunities and threats

• May include inter...read more
Answered by AI
Add your answer
Q2. How do you handle a difficult client?
Add your answer