Prepare for and practice interview questions from Consultnet.

Consultnet Interview Questions

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

Consultnet Salaries by Position

Business Analyst/ PM (Remote) 8 month contract possible extension $48.00 to $52.00per hour Job Description Our client is in the Financial and Banking space is looking for a Business Analyst/PM. This individual advocates for the business clients on projects in all phases of the solution development lifecycle for each critical stage. This will include initiation, analysis, development, testing, and post-implementation follow-up. They will need a strong knowledge of software and systems architecture, methods, and terminology. This individual is responsible for the planning, executing and managing projects and programs through out the company, as well as the ability to research and analyze data. They will make sure that all the tickets are being sent to the right department Required Skills <ul> <li> 6 years as a Business Analyst </li> <li> PM tools Jira and Confluence experience </li> <li> Lucid- (Figma is a plus) </li> <li> Strong skills with Microsoft office (Excel, Word, PowerPoint, Outlook, ect) </li> <li> Agile Experience </li> <li> 2 years of experience managing projects fast paced Environment </li> <li> 2 Business/Systems Analysis </li> </ul> Education <ul> <li> Bachelor's Degree or 5 years working experience. </li> </ul> Bonus/Soft skills <ul> <li> Finance and banking background </li> <li> PMI, ACP or equivalent </li> <li> Strong work ethic and self-motivation </li> </ul> Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore. Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results. Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold. Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com . We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

Sr. Data Engineer Salt Lake City, UT 90days contract that is likely to extend through q1 and q2 of next year Contract Rate: $65.00 - $75.00 per hour Our client is in search for a Data Engineer to join their team on a long-term contract. You will be r esponsible for developing and deploying enterprise grade platforms that enable data-driven solutions. In addition you will automate and maintain scalable infrastructure. You will also ensure delivery of a highly available and scalable systems and monitor all systems and applications and ensure optimal performance as well as research and test new tools and applications. Required Skills: 5 years of Data Engineering experience 3 years of CI/CD tools experience 3 years of Python experience Expertise with ETL, Unix/Linux, scheduling and orchestration tools pache Kafk JSON DO/Git experience PI experience Bonus Skills: utomated Testing experience BDD - Behavior Driven Development Experience with Big Data Distribution systems Experience within the financial services and solutions space Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore. Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results. Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold. Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com . We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

Senior Data Engineer Remote- must work standard EST hours Long term contract/ contract to hire Our client is seeking a Senior Data Engineer to accelerate data sharing between applications, engineers, and data scientists. The successful candidate will demonstrate mature programming and design ability. The Data Engineer role supports data delivery, serving, design, monitoring, and security management for data science, graph, and machine learning engineering teams. Requirements 7 years of relevant experience Demonstrable AWS knowledge - EC2, ECS, Lambda, S3, EMR Strong programming ability in Python or Scala Experience with SQL and relational data 3 years experience in one or more big data technology : S3, HDFS, Spark, Presto, etc. SPARK preferred Experience designing and implementing ETL pipelines to support Data Science and/or Machine Learning. Nice to have Feature Store build experience and Dagster Financial industry experience

Software Engineer C# San Diego, CA Contract $63-$75 an hour Immediate hire with growing company. Will collaborate with other software developers, business analysts and software architects. Provide technical leadership to teammates through coaching and mentorship. Participate and lead technical discussions about technology and infrastructure. Define and execute projects independently, deal well with ambiguous/undefined problems. Software requirements and specification definition. Software design and development. Assay algorithm design and development. Enhance existing code through refactoring. Code Review. Unit and acceptance testing. Root cause analysis and defect resolution. Documentation, participate and/or lead in Agile planning, scrum and retrospectives. Use company design and development processes. Requirements: <ul> <li> Experience working in an integrated team environment </li> <li> Bachelor's degree </li> <li> Min 1 plus years of medical software development experience</li> <li> Strong working knowledge of C#, WPF, WCF preferred, .Net framework, MSSQL, LINQ. Able to hit the ground running </li> <li> Experience with Visual Studio, GitHub, JIRA, Code Review Tools </li> <li> Knowledge of Unit Test frameworks required. Examples: XUnit, NUnit, CodedUI, MSTest </li> <li> Knowledge of UI design and prototyping required </li> <li> Knowledge of multithreaded UI development required </li> <li> Knowledge of Design Patterns required </li> </ul> Bonus Skills: <ul> <li> Medical device experience preferred </li> <li> Knowledge of Entity Framework a plus </li> </ul> Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore. Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results. Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold. Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com . We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

Consultnet Interview Questions

Consultnet Interview Guides

Consultnet Interview Questions

Consultnet Salaries by Position

Consultnet Opening Jobs