Prepare for and practice interview questions from Falconwood.

Falconwood Interview Questions

Falconwood 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

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?

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?

Falconwood Salaries by Position

Overview: Falconwood is seeking Software Engineers. Software Engineers research, design, and develop computer and network software or specialized utility programs. This opportunity is contingent upon award There are 6 openings for candidates with an active Secret clearance Responsibilities: <ul><li>Analyze user needs and develop software solutions, applying principles and techniques of computer science, engineering, and mathematical analysis.</li><li>Update or enhance existing software capabilities.</li><li>Work with other functional disciplines (e.g., project management, acquisition, logistics, security, etc.) to integrate hardware and software systems, develop specifications, and performance requirements.</li><li>Maintain databases within an application area</li></ul> Qualifications: <ul><li>Bachelors degree in a quantitative field such as engineering or mathematics (e.g. Electrical Engineering, Computer Engineering, Computer Science, Information Technology, or Information Systems)</li><li>3 years of professional experience with software engineering</li><li>Experience with applying programming concepts in a professional or academic setting.</li><li>Experience with applying modern software development methodologies (e.g. agile, DEVOPS/DEVSECOPS) in a professional or academic setting.</li><li>Agile Developer certification or Certified Scrum Developer certification</li></ul> Pay Range: 126k-136k dependent upon experience level

Falconwood Interview Questions

Falconwood Interview Guides

Falconwood Interview Questions

Falconwood Salaries by Position

Falconwood Opening Jobs