Prepare for and practice interview questions from Zeomega.

Zeomega Interview Questions

Zeomega 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?

Zeomega Salaries by Position

Position SummaryAssociate Product Analyst is responsible to be expert in assigned Jiva Modules/components. This role will assist Product Analysts & Managers in conceptualizing solution framework for product requirements. Create & delivery product artifacts (BRD & PRD/FRS) and work closely with engineering teams to deliver winning products.PRINCIPLE JOB RESPONSIBILITIES:* Manage product life cycle from strategic planning to tactical activities.* Accountable to own & maintain the functionalities for assigned modules/group of modules.* Be an expert on assigned product components & understand our competition very well* Review Gap analysis for assigned projects and projects in pipe and provide expert solution.* Work on Jiva core product track and client specific solutions track side by side.* Deliver product artifacts (BRDs and PRD/FRS).* Provide artifacts walkthrough sessions to all cross functional teams and answer their queries.* Assist in market research, competitor's research, policy & tech feasibility impacts.* Work with PD teams to clarify queries, resolve issues & provide solutions.* Work with SME's to review solutions for ER/CR & NPI's due to policy & customer practices impact.* Be creative & curious to bring NPI, continuous enhancements* Minimum of 0-4 years of experience in relevant technology and industryEducationBE/ B Tech/ ME/ M Tech/ MBA from reputed collegeSkillsBC - Dependability and ReliabilityBC - InitiativeBC - Time ManagementFC - Client FocusFC - Data Analysis ( Metrics and Measurement)FC - Oral CommunicationFC - Written CommunicationPC - Jiva Product KnowledgeCompetenciesDC - US Healthcare domain KnowledgeBC - Collaboration & Interpersonal SkillsFC - Analytical SkillsPC - Jiva Product KnowledgeFC - QualityFC - Communication SkillsTC - Product Catalog DevelopmentTC - Documentation DevelopmentFC - Business Analysis

Zeomega Interview Questions

Zeomega Interview Guides

Zeomega Interview Questions

Zeomega Salaries by Position

Zeomega Opening Jobs