Prepare for and practice interview questions from Flexjobs.

Flexjobs Interview Questions

Flexjobs Interview Guides

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

Flexjobs Salaries by Position

<p>Subscribe to FlexJobs today and gain access to 25,000 hand-screened remote, work from home, & flexible schedule job listings. FlexJobs makes it easier, faster, and safer to find a job that better fits your life with professional job opportunities from entry-level to executive, startup to Fortune 500 - no ads, junk, or scams. Plus get exclusive access to both Career Coaching and Resume Reviews at a deep discount, as well as expert skills tests, valuable job search tips and articles, webinars with job search advice, educational guides and courses, and more. FlexJobs was founded in 2007 and has been featured on NPR, Good Morning America, Fox Business Channel, and thousands of other media outlets. Join today</p>

<p>Subscribe to FlexJobs today and gain access to 25,000 hand-screened remote, work from home, & flexible schedule job listings. FlexJobs makes it easier, faster, and safer to find a job that better fits your life with professional job opportunities from entry-level to executive, startup to Fortune 500 - no ads, junk, or scams. Plus get exclusive access to both Career Coaching and Resume Reviews at a deep discount, as well as expert skills tests, valuable job search tips and articles, webinars with job search advice, educational guides and courses, and more. FlexJobs was founded in 2007 and has been featured on NPR, Good Morning America, Fox Business Channel, and thousands of other media outlets. Join today! </p>

Flexjobs Interview Questions

Flexjobs Interview Guides

Flexjobs Interview Questions

Flexjobs Salaries by Position

Flexjobs Opening Jobs