As a Associate - Supply Operations, you will play a pivotal role in streamlining our marketplace supply chain, ensuring seamless coordination between suppliers, logistics partners, and internal teams. You will analyze data to identify bottlenecks, implement process improvements, and collaborate with crossโfunctional stakeholders to meet key performance indicators. Your proactive mindset will help drive cost efficiencies and maintain high supplier satisfaction. You will thrive in a fastโpaced environment, balancing multiple priorities while contributing to the overall growth of the marketplace ecosystem.
This guide is for freshers and working analysts in India preparing for data analyst interviews at product companies, IT services firms, banks, e-commerce and fintech startups. It has 60 questions with model answers in three levels: the basics every fresher is asked, the real-world problems analysts with one to four years face (wrong joins, messy data, conversion drops), and the senior questions on experiment design, metric traps and leading decisions with data. Every SQL query and every number in the answers was run or calculated. Read the question, answer it aloud in your own words, then compare, and take the mock test to practise under time.
Questions you may be asked
What does a data analyst do, and what does a typical day look like?
How is a data analyst different from a data scientist and a data engineer?
What is the difference between WHERE and HAVING? Show it with a query.
What is the difference between an INNER JOIN and a LEFT JOIN, and why can a customer count drop after a join?