Prepare for and practice interview questions from Apptad Inc..

Apptad Inc. Interview Questions

Apptad Inc. Interview Guides

<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

<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>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?

Apptad Inc. Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><b>Job Title: Business Analyst/Production Analyst with Teller Applications<br /> Job Location : Columbus/OH, Plano, TX/ Jersey City, NJ (Onsite)<br /> Job Duration: Long Term</b></div><div><br /><b>Job Description:</b></div><ul><li>Knowledge of Teller applications and/or Argo products</li><li>Excellent confluence development skills</li><li>Superior organizational skills</li><li>JIRA card structure and writing (Business/product acumen)</li><li>Experience with JPMC view of products</li><li>Excellent oral and written communication skills to capture functional and noon-functional requirements</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div><p><b>Job Title : Jr. Business Analyst</b><br /><b>Location : Stamford, CT </b></p><p> Must be in Stamford locals or ready to travel all 5 days or relocate (Only USC) & Max years of Exp is only 4-6 Years<br /> BA<br /> Good critical thinking is must.<br /> Extremely strong communication skills written and verbal must.<br /> Strong PPT skills must.<br /> In 2-3 Months, candidate should be ready for C2H with client<br><br> Person would help take whiteboard level ideas or discussion and turn them into executive level presentations. The content could be people / process / technology related. They don't necessarily need telecom or billing or any specific experience like that, if they are strong at critical thinking, they'll pick it up. The PPT / communication skills is biggest factor.<br><br> If person works out. Client would like to convert them to FTE.</p><p><b>*If interested, revert back with your updated resume.</b></p></div></div>

Apptad Inc. Interview Questions

Apptad Inc. Interview Guides

Apptad Inc. Interview Questions

Apptad Inc. Salaries by Position

Apptad Inc. Opening Jobs