Prepare for and practice interview questions from Aditya Birla Group.

Aditya Birla Group Interview Questions

Aditya Birla Group 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

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?

Aditya Birla Group Salaries by Position

This position is based at our client (part of the Aditya Birla Group) at Thane. This is on a Third Party payroll **Job Title: Data Analyst"Job Description:<ol><li>Dashboard creation</li><li>Support Tickets Management</li><li>Training the users</li><li>Implementation of Analytical tools</li><li>Implementation & support for business requirements</li></ol>Experience required:<ol><li>1 to 2 years as Data Analyst, </li><li>Graduate from any discipline</li></ol>Skills :<ol><li>Proficient in Microsoft Excel( Advanced funtions,Dashboard Creation)</li><li>Basic knowledge of Power-Bi, Tableau or any other analytics tool</li><li>Exposure to coding/markup languages like C++, java, HTML, Nabsic is add on.</li><li>Good written and verbal communication</li></ol> Location : WorliWorkstyle: Work from office ( Mon- Fri) 9:30 to 6:30

Aditya Birla Group Interview Questions

Aditya Birla Group Interview Guides

Aditya Birla Group Interview Questions

Aditya Birla Group Salaries by Position

Aditya Birla Group Opening Jobs