Prepare for and practice interview questions from Lorven Technologies Inc.

Lorven Technologies Inc Interview Questions

Lorven Technologies Inc Interview Guides

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

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.

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

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

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?

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?

Lorven Technologies Inc Salaries by Position

Job Title: Technical Business Analyst with an Airline Industry backgroundLocation: Chicago, IL - Hybrid (3 days/ week) Project Description<ul><li>One of the ongoing initiatives of the DOT COM area is looking for a well-experienced Tech BA who worked in a large-scale integration program.</li><li>This is a Chicago-based onsite position with a long-term opportunity.</li></ul> Responsibilities<ul><li>This role involves serving as a liaison between business challenges and technology solutions.</li><li>The key responsibilities include analyzing business processes, identifying business needs, and proposing solutions that may involve software system development, process improvements, or organizational changes.</li><li>A Technical Business Analyst is responsible for gathering and documenting requirements, conducting business and systems analysis, creating specifications for systems to meet business requirements, and overseeing the implementation of these systems.</li><li>This role requires a combination of IT and business skills, as well as the ability to communicate effectively with both technical and non-technical stakeholders.</li><li>Looking for an experienced BA who can write the user stories for the dev and EQA team with enough details without much supervision</li><li>Prefer local to Chicago since they have worked with product owners and participate in PI planning sessions etc.</li><li>Experience with media players, entertainment domain</li></ul> Skills Must have<ul><li>Technical Degree or related work experience</li><li>Proven experience in an analytics and systems development capacity</li><li>Proficiency with digital analytics e.g. Google Analytics, Google Ad Manager</li><li>Proven analytical abilities</li><li>Excellent communicator with the ability to translate data into actionable insights</li><li>Knowledge of SAFe and Scrum</li><li>Experience in the JIRA tool</li></ul> Nice to have<ul><li>Prefer local to Chicago since they have worked with product owners and participate in PI planning sessions etc.</li></ul>

Lorven Technologies Inc Interview Questions

Lorven Technologies Inc Interview Guides

Lorven Technologies Inc Interview Questions

Lorven Technologies Inc Salaries by Position

Lorven Technologies Inc Opening Jobs