Prepare for and practice interview questions from Veridic Solutions.

Veridic Solutions Interview Questions

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

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

Veridic Solutions Salaries by Position

Job Description:Middle Office/Investment Operations domain knowledge - with financial data (knowledge of a trade lifecycle, exposure to different types of data such as positions, transactions, and income acrossasset classes including7-10 years of Experience with indepth data analysis and the ability to review different data sets to determine common data components and define normalization strategyApply functional business knowledge when building platform requirementsAbility to gain understanding of data and transform intodata marts thatare useful to the client/consumerAbility to performgap analysis betweensource of dataand existing datamodel to determine model additionsPrevious experience implementing software or data servicesEffective communicator – can summarizesuccinctly and can provide detailswhen needed.Team oriented – capable of workingin a global setting.Detail orientedand strong senseof responsibility.Flexible and can adapt easily to changing/evolving role requirementsStrong criticalthinking and problem-solving skillsPrevious State Street Middle Office experience is a advantageStrong experience with SǪL

Veridic Solutions Interview Questions

Veridic Solutions Interview Guides

Veridic Solutions Interview Questions

Veridic Solutions Salaries by Position

Veridic Solutions Opening Jobs