Prepare for and practice interview questions from Pacer Staffing.

Pacer Staffing Interview Questions

Pacer Staffing 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>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

Pacer Staffing Salaries by Position

<p>Experience in data engineering, with a specialization in creating and managing cloud-based data infrastructure.</p><p>Experience with Databricks, Apache Spark, and cloud platforms </p><p>Proficient in dimensional modeling with a solid grasp of warehouse construction principles</p>

<p>Description

Pay Rate XX28XX

Analyze business processes and systems, identify inefficiencies and/or required controls, document procedures, track key performance indicators; Participate in developing new products and programs, lead process design/redesign activities, and identify Change Management impacts; Participate in planning initiatives, feasibility studies, cost/benefit analyses, and new systems design; Prepare test scenarios, cases, and schedules; Document and manage functional requirements; Create, extract, and modify ad-hoc and standardized reports based on financial and operational data as needed to support the activities of the company; Possess a thorough understanding of the data, sources of data, and relationships of data in order to generate meaningful information for management and others throughout the company Enter Shift Start and End Time

Additional Details

Enter Shift Start and End Time : M-F
Shift : Shift 1
Time System : FIELDGLASS

#J-18808-Ljbffr</p>

Pacer Staffing Interview Questions

Pacer Staffing Interview Guides

Pacer Staffing Interview Questions

Pacer Staffing Salaries by Position

Pacer Staffing Opening Jobs