Prepare for and practice interview questions from Occam solutions, inc..

Occam solutions, inc. Interview Questions

Occam solutions, inc. Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

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?

Occam solutions, inc. Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Salary: We are seeking Data Analysts to provide support to a customer to integrate as part of a team that will provide advanced analytical knowledge of data on the data science team, with a focus on conducting big data analysis, data conditioning, programming advanced computing, developing algorithms, developing software and data models, executing predictive analytics and utilizing visualization tools.   Responsibilities  ·        Use technology to mine complex, voluminous, and different varieties of data from various sources and platforms in order to collect, analyze, and compile data to meet customer needs  ·        Identify new sources of data and methods to improve data collection, analysis, and reporting  ·        Collect customer requirements  ·        Determine technical issues  ·        Design algorithms and data manipulation capabilities using R, Python, C++, JavaScript, Go, and other known programming languages  ·        Build data solutions, tools, and capabilities to enable self-service frameworks for data consumers to monitor and report on data  ·        Improve the quality of data use and usability by driving an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions  ·        Work collaboratively with Intelligence and Data analysis teams to produce qualitative and quantitative data that support Intelligence products. Requirements/ Qualifications -      Possess a minimum of a bachelor's degree in a computer science discipline.  -     Experience providing services similar in required tasks, scope, and complexity. -     Direct hands on experience as a Data Analyst is required  -     Experience with working for or in support of SOF (Special Operations Forces) -     Experience with coding and understanding algorithms -     MUST HAVE Current TS/SCI  or TS clearance and eligible for SCI access and ACCM read-on.   Location – Location:  Ft. Bragg, NC</div></div>

<h3>Job Description</h3><div>Job Description<div>Salary: We are seeking Data Analysts to provide support to a customer to integrate as part of a team that will provide advanced analytical knowledge of data on the data science team, with a focus on conducting big data analysis, data conditioning, programming advanced computing, developing algorithms, developing software and data models, executing predictive analytics and utilizing visualization tools. Responsibilities <ul><li>Use technology to mine complex, voluminous, and different varieties of data from various sources and platforms in order to collect, analyze, and compile data to meet customer needs </li><li>Identify new sources of data and methods to improve data collection, analysis, and reporting </li><li>Collect customer requirements </li><li>Determine technical issues </li><li>Design algorithms and data manipulation capabilities using R, Python, C++, JavaScript, Go, and other known programming languages </li><li>Build data solutions, tools, and capabilities to enable self-service frameworks for data consumers to monitor and report on data </li><li>Improve the quality of data use and usability by driving an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions </li><li>Work collaboratively with Intelligence and Data analysis teams to produce qualitative and quantitative data that support Intelligence products.</li></ul> Requirements/ Qualifications <ul><li>Possess a minimum of a bachelor's degree in a computer science discipline.</li><li>Experience providing services similar in required tasks, scope, and complexity.</li><li>Direct hands-on experience as a Data Analyst is required</li><li>Experience with working for or in support of SOF (Special Operations Forces)</li><li>Experience with coding and understanding algorithms</li><li>MUST HAVE Current TS/SCI or TS clearance and eligible for SCI access and ACCM read-on.</li></ul> </div></div>

<h3>Job Description</h3><div>Job Description<div>Salary: We are seeking Data Analysts to provide support to a customer to integrate as part of a team that will provide advanced analytical knowledge of data on the data science team, with a focus on conducting big data analysis, data conditioning, programming advanced computing, developing algorithms, developing software and data models, executing predictive analytics and utilizing visualization tools. Responsibilities <ul><li>Use technology to mine complex, voluminous, and different varieties of data from various sources and platforms in order to collect, analyze, and compile data to meet customer needs </li><li>Identify new sources of data and methods to improve data collection, analysis, and reporting </li><li>Collect customer requirements </li><li>Determine technical issues </li><li>Design algorithms and data manipulation capabilities using R, Python, C++, JavaScript, Go, and other known programming languages </li><li>Build data solutions, tools, and capabilities to enable self-service frameworks for data consumers to monitor and report on data </li><li>Improve the quality of data use and usability by driving an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions </li><li>Work collaboratively with Intelligence and Data analysis teams to produce qualitative and quantitative data that support Intelligence products.</li></ul> Requirements/ Qualifications <ul><li>Possess a minimum of a bachelor's degree in a computer science discipline.</li><li>Experience providing services similar in required tasks, scope, and complexity.</li><li>Direct hands-on experience as a Data Analyst is required</li><li>Experience with working for or in support of SOF (Special Operations Forces)</li><li>Experience with coding and understanding algorithms</li><li>MUST HAVE Current TS/SCI or TS clearance and eligible for SCI access and ACCM read-on.</li></ul> Location – Location: Ft. Bragg, NC</div></div>

Occam solutions, inc. Interview Questions

Occam solutions, inc. Interview Guides

Occam solutions, inc. Interview Questions

Occam solutions, inc. Salaries by Position

Occam solutions, inc. Opening Jobs