Prepare for and practice interview questions from Expert Institute.

Expert Institute Interview Questions

Expert Institute 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>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?

Expert Institute Salaries by Position

<p>Job Description

The Role

As a Staff Software Engineer on the Expert iQ development team, you’ll play a pivotal role in building and optimizing web applications that enhance the efficiency of connecting legal teams with expert witnesses. You will collaborate with cross-functional teams, designing and implementing innovative solutions that align with business objectives while ensuring a seamless user experience. You’ll be expected to contribute to both new and existing projects, develop and maintain secure APIs, and drive the adoption of infrastructure-as-code using tools like Terraform or CloudFormation. Your ability to navigate cloud platforms, optimize performance, and provide technical leadership will be crucial in tackling complex challenges. You will also play a key role in fostering a culture of continuous learning and innovation by embracing new technologies and frameworks.

Why You’ll Love This Role:

High-impact projects: Your work will directly influence our platform, helping legal professionals solve complex cases with expert data.

Innovation at its core: We foster a culture of continuous learning and creativity, encouraging you to work with the latest technologies like AI, cloud infrastructure, and more.

Collaborative environment: Be part of a cross-functional team where your voice matters and your contributions are highly valued.

Career growth: Grow your technical and leadership skills as you work on complex challenges in a fast-growing company.

Key Responsibilities

Collaborate with the engineering team to enhance web applications, system designs, and best practices.

Work with cross-functional teams to deliver innovative solutions aligned with business goals.

Participate in both existing projects and new developments, always focusing on the end user's needs.

Develop and maintain APIs for web applications, ensuring robust security and authentication.

Solve complex technical challenges, balancing requirements, design considerations, and trade-offs. You should feel comfortable with in-place re-architecture.

Embrace new technologies and frameworks, fostering a culture of innovation.

Implement infrastructure-as-code using tools like Terraform or CloudFormation.

Engage with cloud technologies and platforms to optimize performance and efficiency.

Deliver high-quality solutions, ensuring unit, integration, and end-to-end testing.</p>

Expert Institute Interview Questions

Expert Institute Interview Guides

Expert Institute Interview Questions

Expert Institute Salaries by Position

Expert Institute Opening Jobs