Prepare for and practice interview questions from Ispace.

Ispace Interview Questions

Ispace 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

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.

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

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

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?

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?

Ispace Salaries by Position

*** IT"S A CONTRACT - W2 POSITION, NO C2C/1099***. Position Title: Systems Analyst / Business Analyst IT L2 Location: Torrance, CA (Hybrid- Less than 60%) Duration: 12 + Months with possibility of an extension Required Skills and Expertise: <ul> <li>BA/BS or master’s degree in management information systems, Computer Science, or equivalent working experience. </li> <li>6+ years of experience working in the IT landscape with a strong focus on Systems Analysis/Business Systems Analysis. </li><li>Proven experience delivering features in complex multi-team environments with dependencies. </li><li>Experience producing technical documents such as system requirements specifications (SRS) and system design specifications. </li><li>Advanced ability to develop and update technical design specifications, diagrams, flowcharts, architecture documents, and deployment plans. </li><li>Strong analytical and logical thinking ability, with advanced skills in Excel, pivot tables, charting, and databases. </li> <li>Experience integrating systems with other software applications, databases, and APIs. </li><li>Working knowledge of software engineering, software development, solution architecture, and implementation of medium to large-scale systems across multiple platforms. </li><li>Must be capable of understanding customer data management platforms, data governance, and data privacy regulations (e.g., GDPR, CCPA). </li> <li>Ability to communicate findings to technical and non-technical stakeholders, support decision-making processes, and present complex technical information clearly. </li> <li>Experience with Agile delivery processes and methodologies. </li><li>Excellent analytical and creative problem-solving skills. </li> <li>Strong organizational skills, time management, portfolio prioritization, and accountability. </li> <li>Excellent listening, interpersonal, written, and oral communication skills. </li> <li>Proficiency in working hands-on with both Confluence and Jira. </li></ul>

Ispace Interview Questions

Ispace Interview Guides

Ispace Interview Questions

Ispace Salaries by Position

Ispace Opening Jobs