Prepare for and practice interview questions from Captivation Software.

Captivation Software Interview Questions

Captivation Software Interview Guides

<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>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.</p>

<p>What factors could have biased this result, and what would you look into?</p>


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

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?

<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

Captivation Software Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><strong>Build to something to be proud of.</strong><hr /><p>Captivation has built a reputation on providing customers exactly what is needed in a timely manner. Our team of engineers take pride in what they develop and constantly innovate to provide the best solution. Captivation is looking for software developers who can get stuff done while making a difference in support of the mission to protect our country.</p><p></p></div>Description<hr /><p>Captivation Software is seeking a Data Engineer who will play a critical role in ensuring the successful acquisition and management of mission-critical and mission support data sets. You will work closely with our team of experts to design and implement data solutions that meet the unique needs of our clients in the military space. Whether you have experience as a developer, analyst, or engineer, we want to hear from you. Your expertise in this area will be invaluable as we work to provide our clients with the highest quality data solutions possible. The successful candidate will have an understanding of data structures, algorithms, and software design principles, as well as experience working with large and complex data sets. They will work closely with our engineers to build and optimize our data pipeline and analytics systems. As a hybrid role, this position will require some on-site work, but you will also have some flexibility to work remotely.</p><p>You will be part of a dynamic team of professionals who are passionate about their work and committed to delivering exceptional results. If you are a self-starter who thrives in a fast-paced environment and is eager to take on new challenges, we encourage you to apply for this exciting opportunity.</p>Responsibilities<hr /><ul><li>Build and maintain data models and schema designs that support our analytics needs.</li><li>Monitor and optimize the performance and scalability of our data infrastructure.</li><li>Participate in code reviews, testing, and deployment processes to ensure high-quality code and system reliability.</li><li>Stay up-to-date with emerging trends and technologies in data engineering and analytics.</li><li>To excel in the position, the candidate shall have a strong attention to detail, be able to understand technical complexities, and have the willingness to learn and adapt to the situation. </li><li>The candidate will work both independently and as part of a large team to accomplish client objectives. </li></ul><p></p>Requirements<hr />Security Clearance:<ul><li>Must have a current Secret level security clearance; U.S. Citizenship required. </li></ul>Minimum Qualifications:<ul><li>5+ years of experience as a developer, analyst, or engineer with Bachelors in related field; 3 years relevant experience with Masters in related field; in related field; or High School Diploma or equivalent and 9 years relevant experience.</li><li>Experience with programming languages such as Python and Java.</li><li>Proficiency with acquisition and understanding of network data and the associated metadata.</li><li>Fluency with data extraction, translation, and loading including data prep and labeling to enable data analytics.</li><li>Experience with Kibana and Elasticsearch.</li><li>Familiarity with various log formats such as JSON, XML, and others.</li><li>Experience with data flow, management, and storage solutions (i.e. Kafka, NiFi, and AWS S3 and SQS solutions).</li><li>Ability to decompose technical problems and troubleshoot system and dataflow issues.</li><li>Strong experience with ETL, data modeling, and schema design.</li><li>Must be able to work a hybrid schedule with the local Enlighten team members. </li><li>DoD 8140 / 8570 compliance certification required. </li></ul>Preferred Qualifications:<ul><li>Experience with NOSQL databases such as Accumulo desired</li><li>Prior Experience supporting cyber and/or network security operations within a large enterprise, as either an analyst, engineer, architect, or developer.</li></ul><p></p><p><em><strong>This position is open for direct hires only. We will not consider candidates from third party <span class="long-word">staffing/recruiting</span> firms.</strong></em></p><div>Benefits<hr /><ul><li>Annual Salary: $130,000 - $270,000 (Depends on the Years of Experience)</li><li>Up to 20% 401k contribution (No Matching Required and Vested from Day 1)</li><li>Above Market Hourly Rates</li><li>$3,200 HSA Contribution</li><li>5 Weeks Paid Time Off</li><li>Company Paid Employee <span class="long-word">Medical/Dental/Vision</span> Insurance/Life Insurance/Short-Term & Long-Term Disability/AD&D</li></ul><p></p></div></div></div>

<h3>Job Description</h3><div>Job Description<div><div><strong>Build to something to be proud of.</strong><hr /><p>Captivation has built a reputation on providing customers exactly what is needed in a timely manner. Our team of engineers take pride in what they develop and constantly innovate to provide the best solution. Captivation is looking for software developers who can get stuff done while making a difference in support of the mission to protect our country.</p><p></p></div>Description<hr /><p>Captivation Software has an immediate need for a mid and senior level software Engineer who will be supporting multiple software technologies. </p><p></p>Responsibilities<hr /><ul><li>Focus on 802.x wireless vulnerability analysis, survey and data collection, and develop our suite of tools to support a wide variety of platforms (laptops, mobile devices, embedded platforms) and operating systems (Linux, Android, RTOS).</li><li>Perform research, reverse engineering, design, development, deployment and sustainment of 802.1x software and associated RF and computing infrastructure</li><li>Design and develop a software suite in C++ to analyze Wi-Fi data and monitor Wi-Fi activity</li><li>Configure software to build and install on various Linux platforms</li><li>Research emerging wireless technologies and vulnerabilities</li><li>Create system documentation, including design, test and user manuals</li></ul><p></p>Requirements<hr />Security Clearance:<ul><li>Must currently hold a Top Secret/SCI U.S. Government security clearance with a favorable Polygraph, therefore all candidates must be a U.S. citizen</li></ul>Minimum Qualifications:<ul><li>Shall have a minimum of fourteen (14) years experience as a Software Engineer</li><li>Bachelor's degree in Math, Science, Engineering, Statistics, Engineering Management, or related discipline from an accredited college or university is required.</li></ul>Required Skills:<ul><li>Perform development in C, C++, and/or Rust</li><li>Perform Linux Kernel Development</li><li>Perform C-based firmware patching</li><li>Perform embedded development for wireless <span class="long-word">technologies/protocols.</span></li></ul><p></p><p><em><strong>This position is open for direct hires only. We will not consider candidates from third party <span class="long-word">staffing/recruiting</span> firms.</strong></em></p><div>Benefits<hr /><ul><li>Annual Salary: $130,000 - $270,000 (Depends on the Years of Experience)</li><li>Up to 20% 401k contribution (No Matching Required and Vested from Day 1)</li><li>Above Market Hourly Rates</li><li>$3,200 HSA Contribution</li><li>5 Weeks Paid Time Off</li><li>Company Paid Employee <span class="long-word">Medical/Dental/Vision</span> Insurance/Life Insurance/Short-Term & Long-Term Disability/AD&D</li></ul><p></p></div></div></div>

<h3>Job Description</h3><div>Job Description<div><div><strong>Build to something to be proud of.</strong><hr /><p>Captivation has built a reputation on providing customers exactly what is needed in a timely manner. Our team of engineers take pride in what they develop and constantly innovate to provide the best solution. Captivation is looking for software developers who can get stuff done while making a difference in support of the mission to protect our country.</p><p></p></div>Description<hr /><p>Captivation Software is looking for a mid level software engineer who will be acting as a DevOps Engineer and shall be part of a team responsible for developing and maintaining a comprehensive Metrics and Monitoring solution for HPC systems to ensure the reliability, performance, and scalability of HPC infrastructure</p><p></p>Requirements<hr />Security Clearance:<ul><li>Must currently hold a Top Secret/SCI U.S. Government security clearance with a favorable Polygraph, therefore all candidates must be a U.S. citizen</li></ul>Minimum Qualifications:<ul><li>Master's degree in Computer Science or related discipline from an accredited college or university, plus three (3) years of experience as a SWE, in programs and contracts of similar scope, type, and complexity.</li><li>Bachelor's degree in Computer Science or related discipline from an accredited college or university, plus five (5) years of experience as a SWE, in programs and contracts of similar scope, type, and complexity</li><li>Seven (7) years of experience as a SWE, in programs and contracts of similar scope, type, and complexity.</li></ul>Required Skills:<ul><li>Experience using the Linux CLI</li><li>Experience developing Bash scripts to automate manual processes</li><li>Recent software development experience using Python</li><li>Experience with software frameworks used for searching, monitoring, and analyzing big data such as Splunk and Elastic Stack</li><li>Experience with IaC (Infrastructure as Code) principles and automation tools including Ansible</li><li>Experience with CI/CD principles, methodologies, and tools such as GitLab CI</li><li>Experience with Git Source Control System</li></ul>Desired Skills:<ul><li>Experience with the Atlassian Tool Suite (JIRA, Confluence)</li><li>Experience with Log Management tools including Syslog-ng and rsyslog</li><li>Experience with Kafka Messaging Framework</li></ul><p></p><p><em><strong>This position is open for direct hires only. We will not consider candidates from third party <span class="long-word">staffing/recruiting</span> firms.</strong></em></p><div>Benefits<hr /><ul><li>Annual Salary: $130,000 - $270,000 (Depends on the Years of Experience)</li><li>Up to 20% 401k contribution (No Matching Required and Vested from Day 1)</li><li>Above Market Hourly Rates</li><li>$3,200 HSA Contribution</li><li>5 Weeks Paid Time Off</li><li>Company Paid Employee <span class="long-word">Medical/Dental/Vision</span> Insurance/Life Insurance/Short-Term & Long-Term Disability/AD&D</li></ul><p></p></div></div></div>

Captivation Software Interview Questions

Captivation Software Interview Guides

Captivation Software Interview Questions

Captivation Software Salaries by Position

Captivation Software Opening Jobs