Prepare for and practice interview questions from Pri global.

Pri global Interview Questions

Pri global Interview Guides

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

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

Pri global Salaries by Position

Senior Data EngineerArlington, VA(Onsite)Only Local to Arlington, VAContract What are your top 3 required technical skills?<ol><li>Python/Scala </li><li>Spark, Hadoop platform & tools (Hive, Impala, Nifi, Oozie, Scoop)</li><li> Databricks</li><li>SQL</li></ol>What are a couple of desired/nice to have technical skills?<ol><li>Knowledge of Splunk or other alerting and monitoring solutions.</li><li>Fluent in the use of Git, Jenkins.</li></ol>What soft skills would you like to see in a candidate?<ol><li> Passion for analytical / quantitative problem solving</li><li>Collaboration skills with experience working with people across roles and geographies</li><li>Motivation, creativity, self-direction, and desire to thrive on small project teams</li><li>Strong written and verbal English communication skills</li></ol>

Financial Data Analyst Menlo Park CA(Onsite) Contract Must-Have Skills 1 Oracle Enterprise Planning EPM - PCM Module Specifically - ABSOLUTE 100% MUST HAVE Nice-to-have Skills 1 Data analyst using SQL 2 Process documentation 3 Dashboarding, using Tableau Years of Experience: 10+ Years Degrees/Certifications Required: Bachelor’s degree in Finance, Accounting, Computer Science, or related field.

Position: Sr. Big Data Engineer (Support Role)HM: Kruna BhartiLocation: PuneTeam/Key Projects: Play4 Initiative for Data and AnalyticsDuration: 12 Months InitiallyDomain: Banking and payment preferredYOE: 5+ YearsShift: 12 – 9 PM IST (2 – 3 hours overlap with US Team) Daily Task:<ul><li>Migrating data from HDFS to Ozone</li><li>SRE Automation using Python</li></ul> Note: It is a big data Support role where they need candidates who can perform migration and clustering of data using Python automation. They are open for Developers if candidates are comfortable doing migration and support activities. Top Skills Requirements:<ul><li>Hadoop (Hive, Impala, Spark)</li><li>Python</li><li>SRE for automation of data using python</li><li>ITSM process (incident & change implementation).</li></ul> What Makes This Role InterestingThis is a very crucial position, and resource will get involved with migration efforts from HDFS to OzoneGlobal Company Culture, exposure to payment domain If you are interested, please send your availability, current and expected CTC and your latest resume to jeff@priglobal.com. Thanks Jeff Mislang Delivery Lead PRI India IT Services Pvt LtdNew Airport Rd, Viman Nagar Pune, MH - 411014Email: jeff@priglobal.com | Web: <a>www.priglobal.com</a>(Direct) 636 591 2742 / 636 484 8471 (WhatsApp) +639063953031

Financial Data AnalystMenlo Park CA(Onsite)Contract Must-Have Skills 1 Oracle Enterprise Planning EPM - PCM Module Specifically - ABSOLUTE 100% MUST HAVE Nice-to-have Skills 1 Data analyst using SQL2 Process documentation 3 Dashboarding, using Tableau Years of Experience: 10+ Years Degrees/Certifications Required: Bachelor’s degree in Finance, Accounting, Computer Science, or related field.

Risk AnalystContractRemoteOnly USC or GC <ul><li>Perform risk assessments and identify issues for suppliers</li><li>Good communication, detail oriented</li><li>Must understand structure of data and put results into certain formats. Understand how data is consumed by other systems</li><li>Will look for discrepancies (point those out and make changes on the fly)</li><li>Will reach out to suppliers and internal business owners</li><li>MS Excel experience is primary technical skill</li><li>GRC tool being used is called Archer</li><li>Will be very autonomous</li><li>Project Management background is beneficial</li><li>Internal Auditor skillset is transferrable</li></ul>

Data EngineerSt Louis, MO( Onsite)ContractOnly local to St Louis, MONeed to take online Assessment Top 3 required technical skills?<ol><li>Understand Continuous Integration (CI) and Delivery (CD) concepts, and capabilities to support automation, pipelines, virtualization, and containerization </li><li>Fluency in one or more languages like Scala, Java, Python etc.</li><li>Understanding/experience in Apache Spark, Airflow, Databricks, AWS and related technologies</li></ol> What are a couple of desired/nice to have skills?Data engineer/SDET <ol><li>Knowledge of Microservices and scaling techniques</li><li>Experience using web service APIs</li></ol>

Pri global Interview Questions

Pri global Interview Guides

Pri global Interview Questions

Pri global Salaries by Position

Pri global Opening Jobs