Prepare for and practice interview questions from Vertiv.

Vertiv Interview Questions

Vertiv Interview Guides

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

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

Vertiv Salaries by Position

<p>Job Summary The Data Engineer will be responsible for managing all database pipelines, databases, datasets used by the AC Power Engineering teams. They will also be responsible for ensuring all business applications the engineering teams utilize meet functional and quality requirements. This requires complex problem solving, working with cross-functional teams, and managing a variety of tasks and activities while meeting project goals and schedules. This position will be located onsite at Vertiv's Delaware, OH location. Responsibilities: * Design, build, test, optimize and maintain database pipeline architectures. * Design, build, test, optimize and maintain datasets and databases. * Develop algorithms to transform data into useful, actionable information. * Design, build, test, optimize and maintain internal business applications. * Ensure real-time data accuracy and scalability for data being ingested and stored. * Engage with management to understand business objectives. * Engage in SIT and UAT for all relevant business applications. * Design, build, test, optimize and maintain Configured to Order (CTO) spec documentation and BOM Rules for CPQ Configurators. Requirements: * Bachelor's Degree from an accredited college or university, in Computer Science, Data Science, Engineering or a related field. * 2+ years' experience in related role * Required experience in data engineering with proficiencies in data pipelines, business application development, and ETL. * Required experience with Snowflake or other data lake solutions. * Required experience with integration with CRM, ERP, MRP and PLM systems. * Strong proficiency with SQL. * Required experience with programming languages such as Python (scripting). * Strong proficiency with PowerBI. * Preferred experience with Oracle CPQ, PLM, EBS. * Preferred experience with Smartsheet The successful candidate will embrace Vertiv's Core Principals & Behaviors to help execute our Strategic Priorities. OUR CORE PRINCIPALS: Safety. Integrity. Respect. Teamwork. Diversity & Inclusion. OUR STRATEGIC PRIORITIES * Customer Focus * Operational Excellence * High-Performance Culture * Innovation * Financial Strength OUR BEHAVIORS * Own It * Act With Urgency * Foster a Customer-First Mindset * Think Big and Execute * Lead by Example * Drive Continuous Improvement * Learn and Seek Out Development About Vertiv At Vertiv, we offer the stability of a global leader in a growing industry and the opportunity of a startup. We design, manufacture and service the mission-critical infrastructure technologies for vital applications in data centers, communication networks and commercial and industrial environments. With $6.9 billion in revenue, a strong customer base and global reach in nearly 70 countries, our move to establish a standalone business enables us to deliver greater value to our customers and create new opportunities for our people. Work Authorization No calls or agencies please. Vertiv will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, H-1, H-2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire. Equal Opportunity Employer Vertiv is an Equal Opportunity/AApply here: https://www.aplitrak.com/?adid=YmJnZW5lcmljLjI5NTY3LjEwNTA4QHZlcnRpdmNvbXAuYXBsaXRyYWsuY29t </p>

Vertiv Interview Questions

Vertiv Interview Guides

Vertiv Interview Questions

Vertiv Salaries by Position

Vertiv Opening Jobs