Prepare for and practice interview questions from Swiggy.

Swiggy Interview Questions

Swiggy Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Swiggy Salaries by Position

Job Profile: Principal Product Manager (Payments)Location: Bangalore | KarnatakaYears of Experience: 7 - 10yrsWay of working - Hybrid: Employees will come to the office twice or thrice a week at their base location and work remotely for the remaining days. About the team & roleIf you are excited about transforming the way millions order food, groceries and utilities in India, we would like to have you join our team as a Principal Product Manager in Swiggy Payments team. This person will be responsible for leading Swiggy’si) Payments platform for all business units andii) Payment-led growth products. In this role, you will work with various internal product teams, UX researchers/designers, data scientists, analytics, marketing and business to build a strategy and roadmap for Swiggy payment’s charter. What will you get to do here?<ul><li>Establish & own long term vision for several products & platforms at Swiggy while strategizing ,planning and influencing to deliver on the planned roadmap</li><li>Partnering with business, operations, product, marketing, supply and Analytics teams to deliver on the roadmap while unlocking long term value for our customers and internal stakeholders. Collaborate with cross-functional teams to define strategic roadmaps across Swiggy's focus areas based on the AOP targets and execute as per the aligned roadmaps</li><li>Collaborate with product teams across the org to ideate and find win-win-win solutions on common objectives’ across multiple categories and product lines impacted</li><li>Manage, facilitate and nurture team members at all levels to design and build differentiated experience for Foster a culture of innovation & learning with high emphasis on sustainable rituals</li><li>Determine the targets / success metrics for the org based on the organizational strategy and be the custodian for these metrics.</li></ul> What qualities are we looking for?<ul><li>Minimum 7 years of work experience in Product Management with extensive experience in user research, consumer backward thinking, design thinking and building consumer experiences in the e-commerce/consumer internet industry.</li><li>Experience in core payments products would be a huge plus</li><li>Must have a deep understanding of the broader payments ecosystem, new technologies and their applications to improve payment experience.</li><li>Proven track record of building and shipping high-quality data products in large internet company impacting millions of users.</li><li>You are consumer obsessed, but you can walk a tightrope balancing consumer delight with potentially orthogonal org goals.</li><li>Well versed with running experiments & is considered an expert in analyzing data, showcasing a deep understanding of the 360-degree interaction effects and potential long-term impacts, can cull out the unknowns and hedge against them.</li><li>Ability to lead a high performing team of data science, analytics, engineering, technology, and business folks.</li><li>You have demonstrated experience in working across multiple products, various stakeholders and exerted a high degree of influence across several teams/functions leading to successful outcomes. You thrive in managing a charter with big impact & multiple intersections in a large org.</li><li>Excellent problem solving, critical thinking, and communication skills. Highly customer-obsessed thinking with a deep understanding of customer needs and aspirations.</li></ul> “We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability status, or any other characteristic protected by the law”.

Swiggy Interview Questions

Swiggy Interview Guides

Swiggy Interview Questions

Swiggy Salaries by Position

Swiggy Opening Jobs