Prepare for and practice interview questions from Nleague.

Nleague Interview Questions

Nleague 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

Nleague Salaries by Position

<h3>Job Description</h3><div>Job Description<div>Job Overview:The Virginia Department of Transportation (VDOT) Business Integrated Solutions Division (BISD) is seeking a Master Data Analyst with demonstrated experience in data analytics to work as a key member of the Business Analysis and Testing Support team. This analyst will support teams working in Agile (Sprint) as well as traditional Waterfall methodologies for Software Development Lifecycle (SDLC). Responsibilities include analyzing problems; documenting business processes and data lifecycle; developing data requirements, user stories and acceptance criteria; and testing. VDOT is a fast-paced organization with very high standards for work quality and efficiency. This position is expected to handle multiple projects, and remain flexible and productive, despite changing priorities and processes. Ongoing improvement and efficiency are a part of our culture, and each team member is expected to proactively contribute to process improvements. Responsibilities:<ul><li>Work with the Project team members and business stakeholders to understand business processes and pain points. </li><li>Develop expertise in the customers' datasets and data lifecycle</li><li>Profile source data; review source data and compare content and structure to dataset requirements; identify conflicts and determine recommendations for resolution</li><li>Conduct entity resolution to identify matching and merging and semantic conflicts</li><li>Elicit, record, and manage metadata</li><li>Diagram current processes and proposed modifications using process flows, context diagrams and data flow diagrams</li><li>Discover and document requirements and userstories with a focus on improving both business and technical processing</li><li>Decompose requirements into Epics and Features and create clear and concise user stories that are easy to understand and implement by technical staff</li><li>Utilize progressive elaboration; map stories to data models and architectures to be used by internal staff to facilitate master data management</li><li>Identify and group related user stories into themes, document dependencies and associated business processes</li><li>Assist Product Owner in maintaining the product backlog</li><li>Create conceptual prototypes and mock-ups</li><li>Collaborate with staff, vendors, consultants, and contractors as they are engaged on tasks to formulate, detail and test potential and implemented solutions</li><li>Perform Quality Analyst functions such as defining test objectives, test plans and test cases, and executing test cases</li><li>Coordinate and Facilitate User Acceptance Testing with Business and ensure Project Managers/Scrum Masters are informed of the progress Qualifications Required:</li></ul><ul><li>The candidate must have a minimum of 10 years of experience delivering business data analysis artifacts. </li><li>5+ years of experience as an Agile Business Analyst; strong understanding of Scrum concepts and methodology</li><li>Experience organizing and maintaining Product and Sprint backlogs</li><li>Experience translating client and product strategy requirements into dataset requirements and user stories</li><li>Proficient with defining acceptance criteria and managing acceptance process</li><li>Experience with enterprise data management</li><li>Expertise with Microsoft Office products (Word, Excel, Access, Outlook, Visio, PowerPoint, Project Server)</li><li>Experience with reporting systems operational data stores, data warehouses, data lakes, data marts</li><li>The candidate must have exceptional written and oral communications skills and have the proven ability to work well with a diverse set of peers and customers</li></ul>Preferred:<ul><li>Certified Business Analysis Professional (CBAP) and/or Certified Scrum Product Owner (CSPO) Certification</li><li>Certified Data Management Professional (CDMP)</li><li>Experience using Team Foundation Server and work item tracking</li><li>Experience with automated testing tools such as Test Complete</li></ul></div></div>

Nleague Interview Questions

Nleague Interview Guides

Nleague Interview Questions

Nleague Salaries by Position

Nleague Opening Jobs