Prepare for and practice interview questions from Intellibee Inc.

Intellibee Inc Interview Questions

Intellibee Inc Interview Guides

<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

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


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

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?

Intellibee Inc Salaries by Position

<p>Objective: This Resource will support data engineer and data analysis work for the Integrated Justice System and BI Platform Modernization projects.

Typical Deliverables:

To be defined based on project requirements.

Required Skills & Abilities:

3+ years experience in Relational Data Modeling design and development of conceptual, logical, and physical data models.

User Interface to DB field mapping to support development teams.

Report writing and Dashboard design, development, and transition.

Peer Reviews and recommendations.

Documentation, including knowledge capture and diagramming.

Troubleshooting, Root Cause Analysis, Workarounds, and fixes.

Good written and verbal communications with peers and at times stakeholders.

Tools: Microsoft SQL SSIS, SSAS, SSRS.

5+ years experience with Power BI Report Server, Power BI Service, and understanding of CJIC and public safety and justice systems and associated datasets.

Education:

Bachelor’s degree or higher in a quantitative field (i.e., Computer Science, Statistics, Engineering) or equivalent work experience.

#J-18808-Ljbffr</p>

Intellibee Inc Interview Questions

Intellibee Inc Interview Guides

Intellibee Inc Interview Questions

Intellibee Inc Salaries by Position

Intellibee Inc Opening Jobs