Prepare for and practice interview questions from Shell.

Shell Interview Questions

Shell Interview Guides

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?

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

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Shell Salaries by Position

We are looking for a Java Developer with experience in Big Data environments for an exciting opportunity with a globally recognized tech leader, renowned for its innovation and shaping the digital landscape. This product-based company has a strong presence in technology and financial services, backed by decades of industry expertise and a vast global reach. Preferred Background: We require developers with a background in finance, fintech, or banking to bring domain expertise to this role We Required Developers from fianance, fintech or banking ground.<ul><li>Design, develop and maintain the data platform and data-driven monitoring tools for risk and data science solutions in Big Data platform, using cutting edge technologies.</li><li>Work closely with partner team to build solution dependency and implement the lifecycle monitoring with good understanding of Java based platforms.</li><li>Look for improvement opportunities with business impact, participate in the documentation and implementation of processes, procedures, and policies for Live monitoring, investigation and data team.</li></ul>Requirements<ul><li>Familiar with Java, SQL and Linux shell.</li><li>Have experience with big data(Hadoop, Spark, Hive...) is a plus.</li><li>Have experience monitoring tools like DataDog is a plus</li><li>Strong passion in problem solving.</li></ul> Good documentation habit and can sync up with teams across different locations remotely<ul><li>Highly motivated, goal driven, innovative, curious, and open minded.</li></ul>

Shell Interview Questions

Shell Interview Guides

Shell Interview Questions

Shell Salaries by Position

Shell Opening Jobs