Prepare for and practice interview questions from Techsur Solutions.

Techsur Solutions Interview Questions

Techsur Solutions Interview Guides

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?

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

Techsur Solutions Salaries by Position

Company Overview: TechSur Solutions is a digital services company whose mission is to enable digital transformation for our customers improving quality and efficiency. Based in the DC metropolitan area, TechSur specializes in advanced cloud services, modernization for both IT structures and applications, leveraging Agile development, and Data Analytics. Since we were formed in August of 2016, we have supported multiple impactful and exciting government programs. Job Responsibilities The Business Analyst will help guide our clients in improving processes, products, services, and software. As a Business analyst, you will liaise between business teams to gather business requirements, validate rules, and stakeholder expectations for the cybersecurity solution. The business analyst should have previous Identity, Credentialing, Access Management (ICAM) experience with prior experience supporting a large implementation effort. Other responsibilities of the Business Analyst include, but are not limited to, developing materials to support change management, strategic communications, and other end user support materials, conducting research; documenting key aspects of data management workflows and system releases; and preparing briefings and executive-level reports. Required Skills/Qualifications <ul><li>3-5+ years of experience consulting to the US Federal government are highly preferred </li> <li>Knowledge or experience supporting projects related to PIV Credentialing Systems, IAM Architecture, Privilege Access Management, Identity Management, and other IAM solutions Provide guidance and documentation for IAM-related security policies, procedures, and guidelines </li> <li>Experience establishing and maintaining dashboards (e.g. Excel, Tableau, etc.) and reports </li> <li>Proven experience effectively prioritizing workload to meet deadlines and work objectives </li> <li>Demonstrated ability to write clearly, succinctly, and in a manner that appears to a wide audience </li> <li>Experience with the Software Development Life Cycle (SDLC) and deployment of IAM systems </li> <li>Experience making recommendations based on analysis of available IAM tools and developing organization strategy and roadmaps </li> <li>Experience developing and briefing materials and executive summaries </li> </ul>Desired Skills/Qualifications <ul> <li>Experience with serving Department of Homeland Security (DHS) or other Federal clients onsite </li> <li>Experience developing and providing training related to credentialing systems and processes </li> </ul>

Techsur Solutions Interview Questions

Techsur Solutions Interview Guides

Techsur Solutions Interview Questions

Techsur Solutions Salaries by Position

Techsur Solutions Opening Jobs