Hi everyone, this topic is for sharing Preparation guidelines and interview experience for Lenskart Business Analyst
The Business Analyst at Lenskart involves a multi-stage assessment and interview process, designed to evaluate both technical skills and business proficiency. Below is a summary of the process and key points from the interviews you provided:
Assessment Test Rounds:
Round 1: Resume Shortlist Screening based on relevance and clarity of resume content.
Round 2: Assignment Round (Excel) Hands-on Excel assignment focused on data handling and summarization.
Round 4: Coding Test (Live) Live analytics coding test covering SQL, Python, and R.
Interview Rounds:
HR Round Profile deep-dive and past experience discussion.
Describe a time you worked cross-functionally to solve a business problem. What was your role and impact?
How do you manage competing priorities and stakeholder requests in a fast-paced environment?
Give an example of how you communicated complex analytical findings to non-technical stakeholders.
Managerial/Leadership/Decision-Making
Walk me through an end-to-end analytics project you led or owned. What decisions did you make and what were the outcomes?
How do you prioritize analytics tasks and communicate trade-offs to stakeholders?
Core Values/Culture Fit
Which of our core values resonates most with you and why?
Describe a time you demonstrated one of our core values in your work.
How do you handle ambiguity and take ownership to drive outcomes?
Interview Preparation Tips
Strengthen hands-on skills in Excel, SQL, Python, and R; be ready for live coding and practical assignments.
Be prepared to discuss Power BI usage and advanced Excel techniques with specific examples.
Keep your resume concise and tailored to the Business Analyst role, highlighting relevant projects and tools.
Practice clear, confident communication about your experiences; prepare a few case studies/real-world scenarios that showcase your analytical thinking and impact.
Review and internalize the company’s core values; prepare examples that demonstrate alignment.
If you have attended the process from your campus, pls share your experiences here; Please follow [guidelines](https://discuss.boardinfinity.com/t/interview-transcript-guidelines/22428?u=abhay-gupta-ebaf4123)
Application Process: I applied through a recruitment consultant and was interviewed in March 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: No specific questions were asked in this round. The focus was on reviewing my resume.
Your Approach: I ensured my resume was concise, highlighting relevant skills and experiences for the Business Analyst role.
Outcome: My resume was shortlisted, and I moved to the next round.
Round 2 - Assignment Round:
Questions Asked: The assignment involved tasks related to Excel.
Your Approach: I carefully completed the Excel tasks, ensuring accuracy and clarity in my work.
Outcome: My performance in the assignment round was satisfactory, and I progressed further in the process.
Preparation Tips:
Focus on sharpening your skills, especially in tools like Excel, SQL, and data analysis.
Keep your resume crisp and tailored to the role you’re applying for.
Conclusion:
The interview process was smooth, and I felt well-prepared for the rounds. Ensuring my resume was strong and my Excel skills were up-to-date played a crucial role in my success. For future candidates, I’d recommend focusing on practical skills and presenting a well-structured resume.
Application Process: I was approached by the company and interviewed in April 2024.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
SQL medium-level questions.
Easy guesstimates.
Your Approach: I focused on solving the SQL queries methodically and used logical reasoning for the guesstimates.
Outcome: Passed this round.
Round 2 - Technical Round:
Questions Asked:
A case study was presented.
Resume grilling was conducted.
Your Approach: I analyzed the case study thoroughly and defended my resume points confidently.
Outcome: Advanced to the next round.
Round 3 - HR Round:
Questions Asked:
Why do you want to join Lenskart?
Salary negotiation discussion.
Your Approach: I highlighted my alignment with the company’s goals and negotiated salary based on market standards.
Outcome: Received a positive response.
Preparation Tips:
The interview was pretty easy. Just brush up on the basics of SQL, case studies, and guesstimates.
Conclusion:
Overall, the interview process was smooth and straightforward. I would recommend focusing on core technical skills and being confident during the HR round. Good luck!
Application Process: Applied through campus placement.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked: The questions were long and seemed irrelevant to the Business Analyst role. It felt like they were asking things that didn’t align with the profile.
Your Approach: Tried my best to answer logically, but it was clear the questions weren’t designed to assess my fit for the role.
Outcome: Didn’t pass. It seemed like they had already decided on someone else from the start.
Conclusion:
The experience was frustrating because it didn’t feel like a fair assessment of my skills for the Business Analyst role. The questions were out of place, and the process seemed biased. My advice for future candidates would be to stay prepared for unexpected questions, but also to recognize when a company might not be evaluating you fairly.
Application Process: Applied via the company website in February 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: No specific questions were asked in this round. The focus was on reviewing the resume.
Your Approach: Ensured the resume was concise and highlighted relevant skills and experiences.
Outcome: Successfully shortlisted for the next round.
Round 2 - One-on-one Round:
Questions Asked:
Tell me about yourself.
Questions about consulting knowledge and other relevant skills.
Your Approach: Prepared a clear and concise introduction about myself and brushed up on consulting concepts to answer confidently.
Outcome: The round went well, but further details about the outcome were not provided.
Preparation Tips:
Be prepared for your first interview and stay confident.
Ensure you can answer questions about your background and relevant skills thoroughly.
Conclusion:
Overall, the interview process was straightforward. Being confident and well-prepared helped me navigate the rounds effectively. For future candidates, I recommend focusing on clarity in your responses and ensuring your resume is polished and relevant to the role.
Application Process: Applied through an online platform.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Tell me about a project where you faced difficulties.
Given a table, asked some SQL questions.
Your Approach:
For the first question, I discussed a challenging project from my past experience, highlighting the difficulties and how I overcame them.
For the SQL questions, I carefully analyzed the table structure and wrote the required queries step-by-step.
Outcome: Cleared the round successfully.
Round 2 - Technical Round:
Questions Asked:
Shared a table and asked to write some SQL queries.
Asked how to derive the same query results in Excel.
Your Approach:
For the SQL queries, I ensured I understood the table schema before writing the queries.
For the Excel question, I explained the equivalent functions and steps to achieve the same results.
Outcome: Cleared the round and moved forward in the process.
Preparation Tips:
Focus on SQL and Excel as they are key for this role.
Practice writing queries for different scenarios.
Be ready to discuss past projects and challenges in detail.
Conclusion:
The interview process was smooth, and the questions were moderate in difficulty. Preparing well for SQL and Excel helped me perform confidently. For future candidates, I’d recommend practicing real-world scenarios and being clear about your past project experiences.
Application Process: I applied via LinkedIn and was interviewed before July 2021.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: None (resume screening round).
Your Approach: Ensured my resume was concise and highlighted relevant skills like data analysis and tools like Power BI and advanced Excel.
Outcome: Shortlisted for the next round.
Round 2 - One-on-one Round:
Questions Asked:
Knowledge about data summarization.
Familiarity with tools like Power BI and advanced Excel.
Your Approach: Answered confidently, explaining my experience with data summarization and how I’ve used Power BI and Excel in past projects.
Outcome: Awaiting results.
Preparation Tips:
Always prepare to speak clearly and confidently about your skills and experiences without hesitation.
Focus on tools and techniques relevant to the role, such as Power BI and advanced Excel.
Conclusion:
The interview process was smooth, and the questions were aligned with the job requirements. I felt confident about my responses, but I could have prepared more case studies to showcase my analytical skills better. For future candidates, I’d recommend practicing real-world scenarios to demonstrate your expertise effectively.
Application Process: I applied via a referral and was interviewed in February 2024.
Interview Rounds:
Round 1 - Coding Test:
Questions Asked:
A 1-hour test consisting of SQL coding questions, including 1 coding question and 2 debugging questions.
Your Approach: I focused on writing efficient SQL queries and debugging the given code snippets carefully.
Outcome: Passed this round.
Round 2 - One-on-one Round:
Questions Asked:
SQL questions involving joins, including a self-join question.
Questions using lag and lead functions.
A question involving rolling averages and rolling sums.
Your Approach: I used my knowledge of SQL functions and joins to solve the problems logically.
Outcome: Passed this round.
Round 3 - One-on-one Round:
Questions Asked:
Root Cause Analysis (RCA) and problem-solving.
“Number of returns has increased; find possible reasons for it.”
Your Approach: I analyzed the problem systematically, considering factors like product quality, customer expectations, and logistics.
Outcome: Passed this round.
Preparation Tips:
Focus on SQL, especially joins, window functions like lag and lead, and rolling calculations.
Practice Root Cause Analysis (RCA) and problem-solving scenarios.
Brush up on statistics and data analysis concepts.
Conclusion:
The interview process was thorough and tested both technical and analytical skills. I found the SQL rounds challenging but manageable with proper preparation. For future candidates, I recommend practicing real-world problem-solving scenarios and ensuring a strong grasp of SQL fundamentals.
Application Process: The application process involved a structured interview process with clear visibility into the rounds.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked: Technical questions relevant to the Business Analyst role, including problem-solving scenarios and analytical thinking.
Your Approach: Focused on demonstrating analytical skills and problem-solving abilities by breaking down the questions logically.
Outcome: Successfully cleared the round.
Round 2 - Technical Round:
Questions Asked: More in-depth technical and situational questions to assess fit for the role.
Your Approach: Used real-world examples to showcase experience and adaptability.
Outcome: Cleared this round as well.
Round 3 - HR Discussion:
Questions Asked: Discussed salary expectations, joining date, and general fit with the company culture.
Your Approach: Was transparent about expectations and open to negotiation.
Outcome: Finalized the offer details.
Preparation Tips:
Focus on analytical and problem-solving skills.
Be prepared to discuss real-world scenarios relevant to the role.
Research the company’s business model to align answers with their needs.
Conclusion:
The overall interview experience was positive, with clear communication about the process. However, the onboarding formalities could be improved. For future candidates, I’d recommend thorough preparation on technical aspects and being clear about your expectations during the HR discussion.
Questions Asked: Questions about embodying the company’s core values.
Your Approach: Aligned my responses with the company’s values and culture.
Outcome: Final round cleared.
Preparation Tips:
Know the company’s core values, understand them, and embody them in your responses.
Be proficient in the skills advertised for the role (e.g., SQL, Python, R, analytics).
Conclusion:
The interview process was thorough but well-structured. Being prepared technically and aligning with the company’s values were key to my success. For future candidates, focus on both your technical skills and cultural fit with the organization.
Application Process: I applied via Naukri.com and was interviewed in January 2022.
Interview Rounds:
Round 1 - One-on-one Round:
Questions Asked:
What do I do in my existing job?
Why do you want to leave your existing job?
Your Approach: I focused on highlighting my current responsibilities and explained my career aspirations for wanting to transition to Lenskart.
Outcome: [Not specified]
Round 2 - HR Round:
Questions Asked:
Tell me about yourself.
Why would you like to join our organisation?
Your Approach: I gave a concise summary of my background and expressed my enthusiasm for Lenskart’s mission and growth opportunities.
Outcome: [Not specified]
Preparation Tips:
Be prepared, be confident, and be humane.
Conclusion:
Overall, the interview process was straightforward. I focused on presenting my skills and aligning my career goals with Lenskart’s vision. For future candidates, I’d recommend researching the company thoroughly and practicing common HR questions to build confidence.
Questions Asked: Focused on core values alignment.
Outcome: Final evaluation.
Preparation Tips:
Know the company’s core values, understand them, and embody them.
Ensure you are proficient in the skills advertised for the role (e.g., SQL, Python, R, analytics).
Conclusion:
The interview process was thorough and involved multiple rounds to assess both technical and cultural fit. Being well-prepared in my technical skills and aligning with the company’s core values were key to my success. For future candidates, I recommend focusing on these aspects to navigate the process smoothly.