Prepare for and practice interview questions from Proquest.

Proquest Interview Questions

Proquest 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

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

Proquest Salaries by Position

Clarivate is looking for a thoughtful, empathetic, & energetic Associate Engineering Manager, who will be leading one of our high performing product engineering teams. This person will be working as a hands-on development manager providing strategic & technical direction to the teams working on modern cloud-based technologies. You must be an excellent communicator with stakeholders, business partners, and team members, displaying creativity along with strong analysis and design skills. About You – Experience, Education, Skills, And Accomplishments <ul><li>Bachelor’s degree (or equivalent) in computer science or information technology</li><li>Overall 10+ years in Software Development domain with minimum 2 years of experience in team & people management.</li><li>At least 5+ years of strong development experience in Java, Spring, Spring boot, JDBC, JPA, REST APIs, Struts, AWS & any RDBMS building Cloud based web applications.</li><li>Should have good understanding of Agile/Scrum delivery.</li></ul> It would be great if you also had . . .<ul><li>Application development experience with front end technologies like React JS, Angular JavaScript, HTML & CSS.</li><li>Working experience on AWS, MySQL & Docker, Elasticsearch or Solr.</li></ul> What will you be doing in this role? You will be responsible for<ul><li>Leading and inspiring our elite engineering teams.</li><li>Performing code and design reviews for product features & bug fixing.</li><li>Collaborating with engineering leadership and cross-functional partners (including product, UX, content mgmt., support & sales) to establish roadmaps and strategy that help serve and grow the product.</li><li>Driving business outcomes with a strong focus on engineering excellence, execution, and craftsmanship as a customer champion.</li><li>Developing and communicating a clear, strategic vision and team goals. Steer team career development and training needs.</li><li>Drive effective & mature Agile practices with continuous improvements.</li></ul> Product you will be developing. The team develops & maintains several applications used in K12 for academic & research purposes. It includes a subscription-based search engine, a culture-oriented application, learning tools, and a suite of genealogy products. The products are available as part of the ProQuest suite of products from Clarivate. About the Team Software engineering teams at Clarivate are dynamic, research-oriented, and dedicated to the best of software craftsmanship. Our squads collaborate to build the best-in-class software solutions. Hours of Work This is a full-time opportunity with Clarivate. You will be working for 9 hours per day including lunch break.

We have an exciting opportunity available for a Lead Software Engineer. You would be responsible for applying engineering principles to the design, development, and evaluation of software and systems. You would also Implement software for specifications of high complexity for limited scale systems, or medium to high complexity for large-scale systems. If this sounds like an opportunity you are interested in, then we would love to talk to you! About You - experience, education, skills, and accomplishments <ul> <li>Bachelors degree in Computer Science or related major, OR equivalent work experience </li><li>6 years of experience designing/developing, code, and customizing software applications from product conception to end user interface </li><li>6 years of experience working with Oracle, SQL, AWS, PostgreSQL, Oracle PL SQL, AND/OR cloud data bases </li></ul>What will you be doing in this role?... <ul> <li>Write clean, efficient, and maintainable code in accordance with coding standards. </li><li>Review other code to ensure clean, efficient, and maintainable code. </li><li>Define architecture of software solution. </li><li>Implement software for specifications of high complexity for limited scale systems, or medium to high complexity for large-scale systems. </li><li>Implement design changes to improve quality, performance, cost reduction, and standardization through analysis of designs and problem-solving techniques. </li><li>Respond to direct or indirect customer inquiries regarding function and design and attends customer meetings. </li><li>Design and implement alternative methodologies or techniques to achieving desired results. </li><li>Maintain understanding of software development lifecycle and delivery methodology. </li><li>Provide guidance for new procedures as needed for the continuing development of high quality systems. </li><li>Provide technical training to other team members. </li><li>Participate in the creation, implementation and administration of departmental policies, procedures, and work instructions. </li><li>Maintain knowledge of technical advances and evaluates new hardware / software for company use. </li><li>Automate tests and unit tests all assigned applications. </li><li>Participate as a team member on various engineering projects and may lead small projects. </li><li>Write application technical documentation. </li></ul>About the team You will be working with an established Software Development & Engineering team, that are experts in data development and analysis. We provide support to library customers all over the world. It is a fast-paced development team working with internal customers/ other departments of Clarivate. Hours of Work <ul><li>Full time, permanent </li><li>Although duties are typically performed during normal business hours, off-hours work/on-call shifts may be required to meet customer and/or business needs. </li><li>Hybrid working schedule on-site 2-3 days/week. </li></ul> Clarivate is an Equal Opportunity Employer Vets/Minorities/Women/Disabled

We are looking for an Associate Product Manager to join our First to Fileproduct team in the United States. In an innovative legal industry that is ever-changing, now is the time to join Clarivate's bold entrepreneurial mission to help Intellectual Property (IP) customers reduce the time from new ideas to IP assets. This is an amazing opportunity to shape and influence the future of the First to File product which is an IP-centric document management system that improves our clients' business processes through a central legal trifold based document repository and reduces costs with automated document harvesting and workflows. We are looking for a person who has vast experience in IP, especially in the areas of patent, trademark, and IP-related processes. Additionally, it would be helpful if you have product management experience and/or related management experience with IP products. About You - experience, education, skills, and accomplishments <ul><li>3+ years of experience in gathering requirements and/or working in close collaboration with customers</li><li>2+ years of previous experience in a Product Management role and/or similar experience in Intellectual Property</li><li>Bachelor's degree or equivalent relevant work experience in Intellectual Property</li></ul> It would be great if you had . . . <ul><li>Knowledge and experience in intellectual property and IP-related processes</li><li>Experience utilizing Jira, Confluence or similar tools</li><li>Experience working in an agile environment (e.g., Scrum processes; familiarity with the aim of sprint planning, backlog refinement meetings, etc.)</li><li>Inquisitive and adaptable nature, passionate for IP, invested in the success of the product, versatile skill set, and likes to work in an agile environment.</li></ul> What will you be doing in this role? <ul><li>Close contact with customers to gather and validate requirements, perform in-depth analysis and understand our customers business needs</li><li>Invests time to understand the customer and advocates for them</li><li>Shares customer learnings, user stories, and/or case studies to the First to File team</li><li>Supporting the ownership of First to File roadmap items, from requirements to delivery</li><li>Works closely with the product leadership to support defining the First to File product strategy, roadmap and priorities</li><li>Works with the development and product management team to build and maintain the backlog</li><li>Assists in market discovery and works on research projects to help answer strategic questions through user interviews and/or data analysis</li></ul> About the Team We're looking to bring an enthusiastic Associate Product Manager who will assist in leading theFirst to File development team. The team works in an international environment that consists of Software Engineers, QA Engineers, and the Senior Product Manager, with whom you will be collaborating daily from a remote or US hybrid based office. Hours of Work <ul><li>This is a hybrid position working 2-3 days a week in one of our US Clarivate offices, preferably in EST.</li><li>Full Time, permanent position</li></ul> #LI-LP #LI-Hybrid Clarivate is an Equal Opportunity Employer Vets/Minorities/Women/Disabled

Proquest Interview Questions

Proquest Interview Guides

Proquest Interview Questions

Proquest Salaries by Position

Proquest Opening Jobs