Prepare for and practice interview questions from Crescens Inc..

Crescens Inc. Interview Questions

Crescens Inc. 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?

Crescens Inc. Salaries by Position

<div> Job title: Business Analyst Location: Trenton,NJ(Hybrid) Duration: 6+ months Job Description: Individuals in this position have demonstrated experience in the standard concepts, practices, and deliverables related to Sr. Business Analysis in support of software development projects. Understands how to gather and document requirements. Has a working knowledge of the software development lifecycle. Works under limited supervision with considerable latitude for initiative and independent judgment. Some familiarity with the help of standard market Testing tools. * Coordinate with internal resources and third parties/vendors for the flawless execution of the project. * Review vendor Statement of Works provides feedback and recommendations to the CIO. * Draft and submit budget proposals and recommend subsequent budget changes where necessary. * Update project epics, user stories, and tasks in the Jira Project Management tool and provide summary reports for US DOE. * Review, analyze and evaluate business systems and user needs for Phase 3 - Student and Staff data collection of Student Longitudinal Data Systems project. * Serve as a liaison between stakeholders and users. * Gather critical information from meetings with various stakeholders * Perform requirement analysis and document requirements * Translate business requirements into user stories for execution in agile delivery mode * Manage competing resources and priorities. * Evaluate business processes, anticipate requirements, uncover areas for improvement, and develop and implement solutions. * Demonstrate progressive leadership in the complete life cycle of software development in Agile and Waterfall methodologies and possess excellent written & oral communication skills and interpersonal skills.</div>

Crescens Inc. Interview Questions

Crescens Inc. Interview Guides

Crescens Inc. Interview Questions

Crescens Inc. Salaries by Position

Crescens Inc. Opening Jobs