Prepare for and practice interview questions from Captivation Software.

Captivation Software Interview Questions

Captivation Software 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

Captivation Software Salaries by Position

Build to something to be proud of. Captivation has built a reputation on providing customers exactly what is needed in a timely manner. Our team of engineers take pride in what they develop and constantly innovate to provide the best solution. Captivation is looking for software developers who can get stuff done while making a difference in support of the mission to protect our country. Description Captivation Software has an immediate need for a mid/senior level Software Engineer supporting software with Linux experience and will be working on Front-End Development. Requirements Security Clearance: <ul><li>Must currently hold a Top Secret/SCI U.S. Government security clearance with a favorable Polygraph, therefore all candidates must be a U.S. citizen</li></ul>Minimum Qualifications: <ul><li>Shall have a minimum of seven (7) years experience as a Software Engineer</li><li>Bachelor's degree in Math, Science, Engineering, Statistics, Engineering Management, or related discipline from an accredited college or university is required.</li></ul>Required Skills: <ul><li>Front end development experience</li><li>Flutter</li><li>React</li><li>Kotlin</li><li>Java</li><li>UI prototyping (wireframes, etc.)</li><li>Agile experience</li><li>Experience using standard formats - Photobuf, JSON, etc.</li></ul>Desired Skills: <ul><li>Cross-platform UI experience</li><li>Test automation/DevOps</li><li>Complex data analysis/visualization UI experience</li><li>Full stack development experience</li></ul> This position is open for direct hires only. We will not consider candidates from third party staffing/recruiting firms. Benefits <ul><li>Annual Salary: $130,000 - $270,000 (Depends on the Years of Experience)</li><li>Up to 20% 401k contribution (No Matching Required and Vested from Day 1)</li><li>Above Market Hourly Rates</li><li>$3,200 HSA Contribution</li><li>5 Weeks Paid Time Off</li><li>Company Paid Employee Medical/Dental/Vision Insurance/Life Insurance/Short-Term & Long-Term Disability/AD&D</li></ul>

Captivation Software Interview Questions

Captivation Software Interview Guides

Captivation Software Interview Questions

Captivation Software Salaries by Position

Captivation Software Opening Jobs