Prepare for and practice interview questions from Plaid.

Plaid Interview Questions

Plaid 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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

Plaid Salaries by Position

The Network Enablement team is developing an end-to-end consent and privacy management system along with diverse data insight products for consumers, customers, and financial data partners, fostering a user-friendly and compliant open finance experience while enhancing Plaid's network value. We are looking for a team member to design, build, and scale up the Open Finance products. In addition, this person will also be expected to set the technical direction for the team to solidify Plaid's leading position in CFPB 1033 compliance and increase our network value. Additionally this team member will provide feedback on technical designs, product requirements, and conduct code reviews. You will also mentor/help grow engineers on the team and partner with the Engineering Manager on planning and goal-settings. Responsibilities <ul><ul><li>Developing solutions that make a difference for consumers, fintechs, and financial institutions.</li><li>Collaborating with cross functional stakeholders.</li><li>Working on both the 0 to 1 stage and the 1 to 10 stage of problems.</li><li>Having an industry impact with the system you designed and implemented. </li></ul></ul> Qualifications <ul><ul><li>Product sense and understanding of customer needs.</li><li>Passion for both prototyping early-stage products and scaling them up with robust platform solutions. </li><li>Ability to be hands-on by contributing to system architecture and through individual code contributions.</li><li>A successful record of mentoring junior engineers and help them grow. </li><li>Experience of building data-intensive products, involving offline ETL, online serving, and public facing APIs. </li><li>Experience of implementing modern risk/compliance/privacy management systems. </li></ul></ul> $162,000 - $243,000 a year Target base salary for this role is between $162,000 and $243,000 per year. Additional compensation in the form(s) of equity and/or commission are dependent on the position offered. Plaid provides a comprehensive benefit plan, including medical, dental, vision, and 401(k). Pay is based on factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience and skillset, and location. Pay and benefits are subject to change at any time, consistent with the terms of any applicable compensation or benefit plans.

Plaid Interview Questions

Plaid Interview Guides

Plaid Interview Questions

Plaid Salaries by Position

Plaid Opening Jobs