Prepare for and practice interview questions from Zf Group.

Zf Group Interview Questions

Zf Group Interview Guides

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.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

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?

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

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

Zf Group Salaries by Position

Job Description:We are currently seeking dynamic individuals to join our team and contribute to the success for our organization. Job Description Experience - 6 to 10 yrs Requirement<ul><li>6+ years as Data Architect/ Engineer with proficiency working in environments supporting solutions design.</li><li>Design and Implementation experience with Bigdata platforms (On premise and Cloud), Data Visualization and Data Virtualization.</li><li>Designing and Implementation experience for both ETL and ELT based solutions.</li><li>Working experience on NOSQL Database like Cosmos, Mongo DB, Cassandra etc. (Any of these DBs)</li><li>Working experience in the areas of Data Engineering (Azure Data Factory, Azure Synapse, Data Lake, Databricks, Streaming Analytics)</li><li>Sound knowledge about various Data Modelling techniques and Data Processing frameworks</li><li>Strong knowledge about integrating on-premises applications, cloud providers or other platforms with Azure.</li><li>Designing and Deploying Azure IaaS and PaaS solutions</li><li>Working experience on Azure Integration Services (Logic Apps, API Management, Service Bus & Event Grid) Azure SQL Database, SQL Server, Azure Monitor and Application Insights</li></ul> Feel free to connect with me on ragavendran.j@zf.com

Zf Group Interview Questions

Zf Group Interview Guides

Zf Group Interview Questions

Zf Group Salaries by Position

Zf Group Opening Jobs