Prepare for and practice interview questions from Shi International Corp..

Shi International Corp. Interview Questions

Shi International Corp. 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

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

Shi International Corp. Salaries by Position

Job Summary: <span class="NormalTextRun SCXW184386899 BCX0" data-ccp-charstyle="normaltextrun" data-ccp-charstyle-defn="{"ObjectId":"a683dd56-2693-45ad-a290-f205f570822b|91","ClassId":1073872969,"Properties":[469775450,"normaltextrun",201340122,"1",134233614,"true",469778129,"normaltextrun",335572020,"1",469778324,"Default Paragraph Font"]}">We are seeking a highly motivated Full Stack Software Engineer to join our development team to build the next generation of Cloud and Service Management capabilities for the SHI One platform. As a Software Engineer, you will play a crucial role in designing, developing, and maintaining software solutions in a diverse technology stack including .NET, React, SQL Server, Databricks, Python, and Elasticsearch. Our ideal candidate is passionate about technology, has a strong sense of pride in their work, and possesses the ability to adapt quickly to new challenges.<span class="NormalTextRun SCXW184386899 BCX0" data-ccp-charstyle="eop" data-ccp-charstyle-defn="{"ObjectId":"a683dd56-2693-45ad-a290-f205f570822b|92","ClassId":1073872969,"Properties":[469775450,"eop",201340122,"1",134233614,"true",469778129,"eop",335572020,"1",469778324,"Default Paragraph Font"]}">? <span class="NormalTextRun SCXW184386899 BCX0" data-ccp-charstyle="eop" data-ccp-charstyle-defn="{"ObjectId":"a683dd56-2693-45ad-a290-f205f570822b|92","ClassId":1073872969,"Properties":[469775450,"eop",201340122,"1",134233614,"true",469778129,"eop",335572020,"1",469778324,"Default Paragraph Font"]}">This position is required to report to the SHI Austin, TX office location as determined by SHI management. About Us: <img src="https://shi.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=225839&hashed=-991523825" alt="SHI New Logo" />Since 1989, SHI International Corp. has helped organizations change the world through technology. Weve grown every year since, and today were proud to be a $14 billion global provider of IT solutions and services. Over 17,000 organizations worldwide rely on SHIs concierge approach to help them solve whats next. But the heartbeat of SHI is our employees all 6,000 of them. If you join our team, youll enjoy:<ul style="margin-top: 0in;"><li>Our commitment to diversity, as the largest minority- and woman-owned enterprise in the U.S. </li><li>Continuous professional growth and leadership opportunities. </li><li>Health, wellness, and financial benefits to offer peace of mind to you and your family. </li><li>World-class facilities and the technology you need to thrive in our offices or yours. </li></ul> Responsibilities: Includes, but not limited to: <ul><li>Collaborate with cross-functional teams to design, implement, and maintain software solutions using various programming languages and technologies, including C#, ASP.NET, React, SQL Server, Databricks, Python, Terraform, Elasticsearch, and Power BI.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Demonstrate a keen problem-solving mindset and the ability to think critically to identify and address complex technical issues efficiently.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Exhibit a strong desire to learn and explore emerging technologies, tools, and industry trends, continuously enhancing your knowledge and skills.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Maintain a high level of attention to detail and a commitment to delivering high-quality code through code reviews, testing, and debugging.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Display self-motivation and take initiative to work independently as well as collaboratively in a remote team environment.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Thrive in a fast-paced and dynamic work environment, readily adapting to changing project requirements and technologies.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Create and maintain comprehensive technical documentation to ensure knowledge sharing and support continuous development efforts.?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li></ul> Qualifications: <ul><li>Bachelor's degree in Computer Science, Software Engineering, or a related field (or equivalent experience).?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>2+ years of software development experience <span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>1+ years experience developing modern web applications using Java, C#, or Python (backend) and Angular, React or Vue (frontend)<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li></ul> Required Skills: <ul><li>Excellent spoken and written communication as well as receptive listening skills, with the ability to present ideas in a clear, concise fashion to technical and non-technical audiences <span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Hands-on experience with developing Platforms-as-a-Service applications on either Microsoft Azure or Amazon Web Services?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Hands-on experience with developing solutions using relation databases including SQL Server or PostgreSQL?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Hands-on experience with ORM frameworks including Entity Framework Core and Hibernate?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Conversational understanding of DevOps methodologies and concepts?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li><li>Understanding of Test-driven development (TDD) and an ability to write effective unit tests?<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li></ul> Certifications Required: Preferred<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559731":720,"335559739":160,"335559740":240}"> <ul><li>AWS or Azure Certification<span style="margin: 0px; padding: 0px; font-size: 10pt; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif; color: #242424;" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}"> </li></ul> Additional Information: <ul><li>The estimated annual pay range for this position is $60,000 - $100,000 which includes a base salary and bonus. The compensation for this position is dependent on job-related knowledge, skills, experience, and market location and, therefore, will vary from individual to individual. Benefits may include, but are not limited to, medical, vision, dental, 401K, and flexible spending.</li><li>Equal Employment Opportunity M/F/Disability/Protected Veteran Status. </li></ul>

Shi International Corp. Interview Questions

Shi International Corp. Interview Guides

Shi International Corp. Interview Questions

Shi International Corp. Salaries by Position

Shi International Corp. Opening Jobs