Prepare for and practice interview questions from Erpmark inc.

Erpmark inc Interview Questions

Erpmark inc 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

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

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?

Erpmark inc Salaries by Position

Technical Data AnalystMountain View CA – OnsiteFull Time Required Skills: <ul><li>5+ years of work experience involving quantitative data analysis is preferred</li><li>Technical undergraduate degree (Engineering, Computer Science, Statistics, Analytics etc.) or equivalent experience </li><li>Advanced SQL skills to get the data you need from a data warehouse and perform data segmentation and aggregation from scratch. </li><li>Data query and data processing tools/systems (e.g., relational, NoSQL, stream processing) </li><li>Familiarity with AWS (Redshift, Athena, and AWS core concepts) </li><li>Familiarity with Data modeling</li><li>Familiarity in analytical and data modeling tools, such as Python, R, or PyCharm </li><li>Self-starter who attacks the problem with excellent critical-thinking skills, creativity, and end-to-end quantitative and qualitative analysis </li><li>Excellent written and verbal communication skills with the ability to present complex technical information in a clear and concise manner to executives and non-technical leaders </li><li>High level of professionalism, passion, strong organization, time management and task prioritization skills with attention to detail and bias to action </li><li>Inquisitive, curious, and bias towards learning and continuous improvement </li><li>Ability to grasp quickly and get up to speed on instrumentation, clickstream data, data architecture, and complex business system interactions such as Salesforce, Amazon Connect, EWFM preferred</li></ul>

Erpmark inc Interview Questions

Erpmark inc Interview Guides

Erpmark inc Interview Questions

Erpmark inc Salaries by Position

Erpmark inc Opening Jobs