Prepare for and practice interview questions from Cerebra Consulting Inc.

Cerebra Consulting Inc Interview Questions

Cerebra Consulting Inc Interview Guides

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

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

Cerebra Consulting Inc Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Hello,Hope you are doing good!!We at Cerebra Consulting, Inc. have an exciting job opening with one of our clients. Please go through the job description below and if you are interested, share your update resume with contact details.Position: Business Data Analyst (only W2)Location: Eden Prairie, MN --- Hybrid Onsite --- Local candidate only Duration: Long Term Contract Our team is responsible for creating and developing flexible applications that determine which members are eligible for dialing based on configurable business rules. We have to balance many features in our applications such as legal compliance, member abrasion, financial goals and client expectations. Reporting is needed to identify data issues as well as track performance for our clients. Here are the job responsibilities: 1. Refine, maintain, and develop proprietary operations dialer loading process 2. Manage the client intake requests and build into ad-hoc request 3. Develop new capability to incorporate target campaigns 4. Establish process to report model output and achieve historical data 5. Provide ad-hoc analysis based on output to business to address short term/long term concerns 6. Work with other teams to incorporate models outputs into downstream process 7. Control quality of work flow and document the process 8. Enhance the accuracy of model outputs to optimize operational performance and achieve financial targets Qualifications:1. 4+ years of experience of performing data analysis and reporting development 2. 4+ years of experience with writing SQL queries and stored procedures with relational databases 3. Intermediate level of proficiency in MS packages 4. Ability to plan, implement, test, and troubleshoot complex technology, software, and system solutions 5. Understanding of statistical tools 6. Experience with SSIS or other tools to move data between platformsContact -: 18148312401 ext.-164mail - vivek.srivastava@cerebra-consulting.com</div></div>

Cerebra Consulting Inc Interview Questions

Cerebra Consulting Inc Interview Guides

Cerebra Consulting Inc Interview Questions

Cerebra Consulting Inc Salaries by Position

Cerebra Consulting Inc Opening Jobs