Prepare for and practice interview questions from Sage it.

Sage it Interview Questions

Sage it Interview Guides

<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

<p>Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.</p>

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


<p>What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?</p>

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Sage it Salaries by Position

<h3>Job Description</h3><div>Job Description<div><p><b>Job Description:</b></p><p> Experience with financial data (knowledge of a trade lifecycle, exposure to different types of data such as positions, transactions, and income across asset classes including derivatives)</p><p> Financial background preferably in custody or back office data</p><p> Experience with SQL, EXcel for Back office data analysis</p><p> Experience with in depth data analysis with the ability to review many different data sets to determine common components and define normalization strategy</p><p> Apply functional business knowledge when deriving platform requirements</p><p> Ability to gain understanding of data and transform into data marts that are useful to the client/consumer</p><p> Ability to perform gap analysis between source of data and existing data model to determine model additions</p><p> Previous experience implementing software or data services</p><p> Effective communicator can summarize succinctly and can provide details when needed.</p><p> Team oriented capable of working in a global setting.</p><p> Detail oriented and strong sense of responsibility.</p><p> Flexible and can adapt easily to changing/evolving role requirements</p><p> Self-motivated & self-sufficient</p><p> Previous State Street Back Office experience a big plus MCH / FDR / OTC</p></div></div>

Sage it Interview Questions

Sage it Interview Guides

Sage it Interview Questions

Sage it Salaries by Position

Sage it Opening Jobs