Prepare for and practice interview questions from Indotronix Avani Group.

Indotronix Avani Group Interview Questions

Indotronix Avani Group Interview Guides

<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 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>In an A/B test, how can you check if assignment to the various buckets was truly random?</p>


<p>In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?</p>

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Indotronix Avani Group Salaries by Position

<p><strong>W2 Only</strong></p><p><br></p><p><strong>This position requires extensive hands-on data system design and coding experience, as well as the development of modern data pipelines (AWS Step functions, Prefect, Airflow, Luigi, Python, Spark, SQL) and associated code in AWS. </strong></p><ul><li>We are looking for senior AWS Cloud Architect with 10+ Years of experience.</li><li>10+ years of related experience in developing data solutions and data movement.</li><li>Proficiency in at least one programming language C#, GoLang, JavaScript or ReactJs </li><li>Experience with AWS S3, AWS Lambda and AWS API Gateway.</li><li>Strong experience in Go Programming Language.</li><li>SaaS application development experience.</li><li>Bachelor's Degree.</li></ul>

Indotronix Avani Group Interview Questions

Indotronix Avani Group Interview Guides

Indotronix Avani Group Interview Questions

Indotronix Avani Group Salaries by Position

Indotronix Avani Group Opening Jobs