Prepare for and practice interview questions from Haramain Systems Inc..

Haramain Systems Inc. Interview Questions

Haramain Systems Inc. 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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Haramain Systems Inc. Salaries by Position

Job Description About us: Haramain Systems Inc. is a leading innovator in the realm of technology and data solution. With our expertise extending across diverse technological platforms and sectors globally, we offer customized, comprehensive, technologically robust solutions for the dynamic business needs. Working with us means being on the cutting-edge of technology, where your talent is valued and your creativity is rewarded. The Opportunity: We are seeking an experienced Sr. Big Data Engineer for full-time W2 position, who is proficient in Big Data tools and technologies. The ideal candidate will have an exceptional proficiency in building scalable big data applications and have a knack for solving complex problems. In this role, you will be instrumental in designing, developing, and maintaining our big data systems used to aggregate and process tremendously large datasets. Job Responsibilities: <ul><li>Design, code, test, and deploy software services and data structures to support the Big Data platform.</li><li>Ensure the performance, quality, and responsiveness of big data applications.</li><li>Collaborate across teams to shape data engineering best practices and set standards.</li><li>Implement data processing and analytics logic in Big Data systems.</li><li>Work with data analysts and managers to understand data requirements and develop solutions for big data handling.</li></ul>Desired Qualifications: <ul><li>Minimum of a Bachelor's Degree in Computer Science or related field.</li><li>5+ years of professional experience in Big Data and related technologies like Hadoop, Spark, and Hive.</li><li>Expertise in SQL, Python, or other scripting languages.</li><li>Experience with Amazon Web Services (AWS) big data technologies (EMR, S3, Redshift).</li><li>Exceptional communication and team-work skills.</li></ul>Nice-to-haves: <ul><li>Advanced Degree in Computer Science or related field.</li><li>Certification in Big Data or related technologies.</li><li>Experience in the use of project management and strategic planning tools.</li><li>Familiarity with Kafka and NoSQL databases.</li><li>Prior experience in customer-facing roles or tech consulting.</li></ul>

Job Description About us: Haramain Systems Inc. is a leading innovator in the realm of technology and data solution. With our expertise extending across diverse technological platforms and sectors globally, we offer customized, comprehensive, technologically robust solutions for the dynamic business needs. Working with us means being on the cutting-edge of technology, where your talent is valued and your creativity is rewarded. The Opportunity: We are seeking an experienced Sr. Big Data Engineer for full-time W2 position, who is proficient in Big Data tools and technologies. The ideal candidate will have an exceptional proficiency in building scalable big data applications and have a knack for solving complex problems. In this role, you will be instrumental in designing, developing, and maintaining our big data systems used to aggregate and process tremendously large datasets. Job Responsibilities: <ul> <li>Design, code, test, and deploy software services and data structures to support the Big Data platform. </li><li>Ensure the performance, quality, and responsiveness of big data applications. </li><li>Collaborate across teams to shape data engineering best practices and set standards. </li><li>Implement data processing and analytics logic in Big Data systems. </li><li>Work with data analysts and managers to understand data requirements and develop solutions for big data handling. </li></ul>Desired Qualifications: <ul> <li>Minimum of a Bachelor's Degree in Computer Science or related field. </li><li>5+ years of professional experience in Big Data and related technologies like Hadoop, Spark, and Hive. </li><li>Expertise in SQL, Python, or other scripting languages. </li><li>Experience with Amazon Web Services (AWS) big data technologies (EMR, S3, Redshift). </li><li>Exceptional communication and team-work skills. </li></ul>Nice-to-haves: <ul> <li>Advanced Degree in Computer Science or related field. </li><li>Certification in Big Data or related technologies. </li><li>Experience in the use of project management and strategic planning tools. </li><li>Familiarity with Kafka and NoSQL databases. </li><li>Prior experience in customer-facing roles or tech consulting. </li> </ul>

Haramain Systems Inc. Interview Questions

Haramain Systems Inc. Interview Guides

Haramain Systems Inc. Interview Questions

Haramain Systems Inc. Salaries by Position

Haramain Systems Inc. Opening Jobs