Prepare for and practice interview questions from Prescient Edge.

Prescient Edge Interview Questions

Prescient Edge 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?

Prescient Edge Salaries by Position

Job Title Mid Data Engineer Location Quantico, VA 22134 US (Primary) Category Research, Development, and Engineering Job Type Full-Time Career Level Staff Education Bachelor's Degree Travel None Security Clearance Required TS/SCI with CI Polygraph Job Description Prescient Edge is seeking a Mid. Data Engineer to support a federal government client. Benefits: At Prescient Edge, we believe that acting with integrity and serving our employees is the key to everyone's success. To that end, we provide employees with a best-in-class benefits package that includes: <ul><li>A competitive salary with performance bonus opportunities.</li><li>Comprehensive healthcare benefits, including medical, vision, dental, and orthodontia coverage.</li><li>A substantial retirement plan with no vesting schedule.</li><li>Career development opportunities, including on-the-job training, tuition reimbursement, and networking.</li><li>A positive work environment where employees are respected, supported, and engaged.</li></ul> Security Clearance: <ul><li>Security clearance required TS/SCI with a CI POLY or the ability to obtain one. </li></ul> Job Requirements Description: <ul><li>Designs, implements, and operates data management systems for intelligence needs. </li><li>Design show data will be stored, accessed, used, integrated, and managed by different data regimes and digital systems. </li><li>Works with data users to determine, create, and populate optimal data architectures, structures, and systems. Plans, designs, and optimizes data throughput and query performance. </li><li>Participates in the selection of backend database technologies (e.g. SQL, NoSQL, HPC, etc.), their configuration and utilization, and the optimization of the full data pipeline infrastructure to support the actual content, volume, ETL, and periodicity of data to support the intended kinds of queries and analysis to match expected responsiveness.</li></ul> Desired Experience: <ul><li>Desired experience minimum 8 years of experience related to the specific labor category with at least a portion of the experience within the last 2 years.</li></ul> Desired Education: <ul><li>Bachelor's degree in an area related to the labor category from a college or university accredited by an agency recognized by the U.S. Department of Education. An additional 4 years of experience in the specific labor category, for a total of 12 years of experience in the specific labor category, may be substituted for a bachelor's degree. </li></ul> Location: <ul><li>Quantico, VA.</li></ul> Prescient Edge is a Veteran-Owned Small Business (VOSB) founded as a counterintelligence (CI) and Human Intelligence (HUMINT) company in 2008. We are a global operations and solutions integrator delivering full-spectrum intelligence analysis support, training, security, and RD&E support solutions to the Department of Defense and throughout the intelligence community. Prescient Edge is an Equal Opportunity Employer (EEO). All applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic that is protected by law. We strive to foster equity and inclusion throughout our organization because we believe that diversity of thought is critical for creating a safe and engaging work environment while also enabling the organization's success.

Prescient Edge Interview Questions

Prescient Edge Interview Guides

Prescient Edge Interview Questions

Prescient Edge Salaries by Position

Prescient Edge Opening Jobs