Prepare for and practice interview questions from Expert Technical Solutions.

Expert Technical Solutions Interview Questions

Expert Technical Solutions Interview Guides

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

Expert Technical Solutions Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><strong>Sr. Infor </strong><strong>M3 </strong><strong>Business Analyst</strong><strong> – Atlanta, GA - Hybrid</strong></div><div><strong> </strong></div><div>Expert Technical Solutions has an immediate opening for an Infor M3 Business Analyst with one of our premier clients in Atlanta, GA. This is a full-time, direct-hire, permanent position with one of the largest and best employers in Atlanta. Hybrid schedule – 2-3 days/wk in the Atlanta office and 2-3 days/wk work from home. </div><div></div><div><strong>Primary Responsibilities:</strong></div><ul><li>Organize and facilitate workshops with Subject Matter Experts (SMEs) based in the US to elicit requirements for each assigned report intended for construction by the technical team using Power BI.</li><li>Gain comprehensive understanding of all scenarios relevant to each report, utilizing expertise of other available Infor M3 specialists as required.</li><li>Develop functional and technical specifications for each assigned report, encompassing detailed descriptions, objectives, wireframes, field mappings, scenarios, and test scripts.</li><li>Develop SQL queries to validate field mappings and conduct Unit Testing on reports post-development by the technical team.</li><li>Coordinate System Integration Testing of reports with SMEs and address any defect or change requests originating from testing.</li><li>Perform regression testing of completed reports as the overall solution evolves with new configurations, co-builds, extensions, etc., and as the BI model expands.</li></ul><div><strong> </strong></div><div><strong>Required Skills</strong><strong>:</strong></div><ul><li>Minimum 5 years of experience working with ERP systems.</li><li>Proficient understanding of Infor M3 ERP Application modules such as Sales/Order Management, Accounting, or Production Planning/IBP, Inventory, and/or warehouse management.</li><li>Expertise in at least one of the following areas: (1) Sales/Order Management, (2) Accounting, or (3) Production Planning/IBP.</li><li>Proficiency in writing SQL queries.</li></ul><div><strong> </strong></div><div><strong>Preferred Qualifications:</strong></div><ul><li>Familiarity with Power BI.</li></ul><div></div></div></div>

Expert Technical Solutions Interview Questions

Expert Technical Solutions Interview Guides

Expert Technical Solutions Interview Questions

Expert Technical Solutions Salaries by Position

Expert Technical Solutions Opening Jobs