Prepare for and practice interview questions from Mavensoft Technologies.

Mavensoft Technologies Interview Questions

Mavensoft Technologies 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>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

<p>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.</p>

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


<p>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?</p>

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?

Mavensoft Technologies Salaries by Position

<p>Job Title: IT Business Analyst -
Duration: 8-Months (Possibility for an extension)
Location: Portland, OR
Key Skills:
IT Background with Integrations and Application Implementations.
Business Analysis
Proficiency with Microsoft Products
Ability to Prioritize Requirements
Adaptability in a Team Environment
Creativity and Critical Thinking
Certified Business Analysis Professional (CBAP) Certification (preferred)
Project Initiatives: Streamline and standardize project and portfolio management by consolidating tools and implementing a new software application.
Applications Used: Quickbase, P6, ERP, Maximo, Coupa, Microsoft Products, WinEst, DevonWay.
Job Responsibilities:
Contribute to information gathering from direct team members and individual contributors to inform software integrations and implementation requirements.
Attend project team meetings and initiate 1:1 meetings with individual contributors to report back to the project manager.
Gather high-value requirements for the implementation of a software application.
Work with individual contributors to identify software needs and develop integrations to implement the new project application.
Drive the requirements elicitation process, identifying required stakeholder input.
Analyze business processes, identify alternative solutions, assess feasibility, and recommend new approaches.
Evaluate financial, cultural, technological, organizational, and environmental factors affecting the change program.
Identify specific measures and mechanisms for measuring benefits and plan to activate these mechanisms at the required time.
Required Skills:
IT background with integrations and application implementations.
Business analysis skills, knowledge of the International Institute of Business Analysis - BABOK processes.
High proficiency with Microsoft Products and ability to create data visualizations and ability to prioritize requirements and negotiate with various stakeholders.
Adaptability in a team environment.
Creativity and critical thinking.
Education and Experience:
Preferred 8 or more years of experience in or knowledge of specific line of business and/or IT environment.
Certified Business Analysis Professional (CBAP) certification preferred.
Summary:
Requires specialized depth and/or breadth of expertise.
Solves complex problems; takes a broad perspective to identify innovative solutions.
Works independently, with guidance in only the most complex situations.
May lead functional teams or projects.
Please Apply Online.

#J-18808-Ljbffr</p>

Mavensoft Technologies Interview Questions

Mavensoft Technologies Interview Guides

Mavensoft Technologies Interview Questions

Mavensoft Technologies Salaries by Position

Mavensoft Technologies Opening Jobs