Prepare for and practice interview questions from Wise Skulls.

Wise Skulls Interview Questions

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

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

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

Wise Skulls Salaries by Position

Business Analysts with in-depth experience in Investment Banking with Eagle Investment Accounting Product Knowledge. Investment Management Business areas supported include Corporate Actions, Trade Operations, Portfolio Accounting, Pricing, Collateral Management, and Derivatives Trade workflow. Business and Operational knowledge of Equities, Futures, Forwards, Options, OTC and Cleared Swaps, Mutual Funds, Structured Products, ETF, Fixed Income Securities and Alternative Investments like Private Equity & Hedge Funds is necessary. Mandatory Skills: Eagle STAR Application/PACE expertiseBusiness Analysis expertise in Investment operations or similarAsset Management/Capital Markets Knowledge Qualifications <ul><li>Preferred Experiences:</li><li>8 to 12 years of experience in Eagle implementation or BAU projects</li><li>Strong expertise on the following Eagle Investment Systems suite of products: STAR Accounting, PACE, Pricing Center, Reporting, and Performance Measurement module</li><li>Understanding of Trade Processing, Portfolio Accounting, Pricing and Collateral Management business concepts are required</li><li>Ability to write complex SQL to query large data sets within Eagle PACE across multiple schemas</li><li>Ability to document current and target state business functional workflows using tools such as Microsoft Visio and PowerPoint</li><li>Good working knowledge of trading workflow and interface between various OMS systems such as Charles River and Murex, and Eagle for the various Asset Classes is a plus. </li><li>Also desirable would-be direct experience working with external financial market data vendors like Bloomberg, IDC, S&P, Reuters, & FACTSET.</li></ul>

Wise Skulls Interview Questions

Wise Skulls Interview Guides

Wise Skulls Interview Questions

Wise Skulls Salaries by Position

Wise Skulls Opening Jobs