Prepare for and practice interview questions from Connectedx Inc..

Connectedx Inc. Interview Questions

Connectedx Inc. Interview Guides

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.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

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?

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

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

Connectedx Inc. Salaries by Position

Job title: Sr Data ScientistPlano, TXLong Term <ul><li>Strong experience manipulating data set and building statistical models, has master’s or Ph.D. in statistics, mathematics with focus on ML, NLP, machine learning or another quantitative field.</li><li>Strong Knowledge and experience in statistical and data mining techniques – GLM/regression, Random Forest, Boosting, text and data mining.</li><li>Experience querying database and using statistical computer languages : R , Python, SQL etc.</li><li>Experience creating and using advanced machine learning algorithms and statistics: regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks, etc.</li><li>Experience with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, , MySQL, etc.</li><li>Experience visualizing/presenting data for stakeholders using: Tableau, Business Objects, D3,</li><li>Exp with Prescriptive analysis, predictive analysis.</li><li>Exp leveraging big data and search technologies (e.g., Spark, Elastic Search, Natural Language Processing, Web Crawling) .</li><li>Knowledge of machine learning techniques and algorithms and be able to apply them in data driven natural language processing techniques.</li><li>Ability to quickly prototype ideas / solutions and perform critical analysis and using creative approaches for solving complex problems.</li><li>Exp with Automotive analytics a PLUS</li><li>Excellent written and verbal communication skills</li></ul>

Connectedx Inc. Interview Questions

Connectedx Inc. Interview Guides

Connectedx Inc. Interview Questions

Connectedx Inc. Salaries by Position

Connectedx Inc. Opening Jobs