Prepare for and practice interview questions from Aperia.

Aperia Interview Questions

Aperia 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>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

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

Aperia Salaries by Position

<p>Summary Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia's clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path.Job Description At Aperia, we rely on a dynamic team of developers. We're seeking a Business Analyst who is ready to work with new technologies and architectures in a forward-thinking organization that's always pushing boundaries. RESPONSIBILITIESWe are looking for a person to join our team in a critical role of the Business Analyst.You will work with our internal client defining and refining the business needs into actionable user stores and tasksWorking directly for the Delivery Lead / Product Owner, you will serve a liaison between Client team, Development team and Data Warehouse teamYou will be instrumental in data identification, data analysis, unit testing and managing user testing & sign off.We are looking for someone with attention to detail, a sense of ownership, good interpersonal skills and excellent documentation skills.Your work will increase efficiency in the development process and reduce exceptions / bugs / test failures.QUALIFICATIONSA Bachelor's degree in a computer or engineering discipline5 years of experience as a Business AnalystSolid knowledge of SDLC (Waterfall) and Agile development methodologies.Strong ability to transform / extract required details from higher level business requestsWorking knowledge of query language such as SQLHigh level of comfort in excel / access manipulating dataA solid understanding of testing and test case developmentPreferred Skills, Experience, and Education: Knowledge of JAVA, AngularKnowledge of prototyping applications such as AxureEligibility RequirementsMust be willing to submit to a background investigation and drug test as part of the selection process.This position is not eligible for sponsorship.Job TypeFull-time (hybrid)ScheduleMonday to FridayBenefitsHealth insurance & Health savings accountDental insuranceVision insurance401(k) matchingLife insurancePaid time offParental leaveDisability insuranceChildcare assistanceEducation reimbursementFitness membershipVolunteer time offThis job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only.Recruiters please don't contact this job poster. DO NOT contact us with unsolicited services or offers.</p>

Aperia Interview Questions

Aperia Interview Guides

Aperia Interview Questions

Aperia Salaries by Position

Aperia Opening Jobs