Prepare for and practice interview questions from Msrcosmos Llc.

Msrcosmos Llc Interview Questions

Msrcosmos Llc Interview Guides

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

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?

Msrcosmos Llc Salaries by Position

Job Description:<ul><li>8+ years of experience in designing and implementing data solutions with at least 4+ years of experience in Azure data engineering.</li><li>Extensive experience with Databricks, including a deep understanding of its architecture, data modeling, and real-time analytics.</li><li>Minimum 6+ years of experience in Spark, Spark Streaming, PySpark and Python.</li><li>Must have strong experience in SQL, Spark SQL, data modeling & RDBMS concepts</li><li>Strong knowledge of Data Fabric services, particularly Data engineering, Data warehouse, Data factory, and Real- time intelligence</li><li>Must have problem solving skills</li><li>Familiarity with security best practices in cloud environments, including Azure Cloud, Azure Active Directory, Encryption, and Data privacy compliance.</li></ul> Role Type: Contract Work Timings: 3 PM - 12 PM (IST)

Job Title: Data EngineerExperience : 7+Location: Bangalore, IndiaContract Duration: 6 Months (Contract to Hire)Conversion: Full-time Employment (FTE) after 6 monthsJob Description:We are seeking a skilled Data Engineer with strong experience in PySpark within an Azure or Microsoft Fabric environment. Candidates with a background in healthcare will be preferred.Key Responsibilities:<ul><li>Design, develop, and maintain scalable data pipelines.</li><li>Implement data processing solutions using PySpark on Azure or Microsoft Fabric.</li><li>Collaborate with cross-functional teams to understand data requirements and deliver effective solutions.</li><li>Optimize performance of large-scale data platforms.</li><li>Ensure data integrity, security, and quality.</li></ul>Required Skills:<ul><li>Proficiency in PySpark.</li><li>Experience with Azure or Microsoft Fabric environments.</li><li>Strong problem-solving skills and attention to detail.</li><li>Healthcare domain experience (preferred).</li></ul>Contract Type: 6-month contract-to-hire, with the potential to convert to a full-time employee (FTE) after the contract duration. Contact:Phone: 8885177678Email: vishalyadav@axuistek.com

Msrcosmos Llc Interview Questions

Msrcosmos Llc Interview Guides

Msrcosmos Llc Interview Questions

Msrcosmos Llc Salaries by Position

Msrcosmos Llc Opening Jobs