Prepare for and practice interview questions from Paramount Pictures.

Paramount Pictures Interview Questions

Paramount Pictures Interview Guides

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

Paramount Pictures Salaries by Position

<p>We are looking for a Senior Product Manager that will be responsible for working on delivering features and managing roadmaps for Paramount’s Media Management products within the Enterprise and Media Solutions team! The role will work with various internal and external partners, including managers, vendors and operational leads to understand the overall business strategy and product requirements as well as prioritize and communicate those requirements to all development teams (internal and/or external).</p><p>This role will operate to ensure successful translation of requirements into high-quality software solutions and operational workflows, taking full responsibility for the development, user experience, timelines, and ongoing improvements.</p><p>The Senior Product Manager will be required to prioritize tradeoffs, elucidate & validate requirements, and write user stories throughout the development lifecycle.</p><h3>Primary Responsibilities:</h3><ol><li>Collaborate with key business partners, engineering and operational teams and support teams to define, develop, shape and refine requirements to align with the overall business strategy and goals.</li><li>Define, prioritize, and clarify user stories by collaborating with others to understand use cases, features, business, and technical domain goals.</li><li>Build and maintain feature backlogs.</li><li>Build and maintain short, medium, and long-term product roadmaps and generate internal agreement with key partners.</li><li>Maintain the functional quality of the work being delivered by setting and evaluating requirements and acceptance criteria.</li><li>Periodically (quarterly) review the product/applications with internal customers to ensure all features meet expectations.</li><li>Work with engineering teams to continuously improve product ownership and development cycles via Agile methodology.</li><li>Collaborate with internal developers, designers, media operations and external partners to conceive, implement and manage product features.</li><li>Develop documentation, use cases, workflows, wire-frames, design requirements, product requirements, and other materials as needed to support design and development.</li><li>Monitor metrics and report on progress to internal customers.</li><li>Perform product demos as needed and evangelize across other teams as needed.</li><li>Stay in sync with overall company product strategy.</li><li>Own and maintain product documentation including feature lists, roadmaps, costs, knowledge-based articles, internal training materials, etc.</li><li>Study competitive offerings in the market and anticipate changes in available technologies and applications.</li><li>Annually audit existing applications/workflows to ensure continual optimization.</li><li>Managing, documenting, and communicating proof of concepts around emerging technology as it applies to Digital Asset Management features.</li></ol><h3>Basic Qualifications:</h3><ol><li>6+ years of working across departments to evangelize and continuously align teams with an overall technology strategy.</li><li>Experience of working in an Agile project management framework and associated tools.</li><li>Experience writing user stories, grooming product backlogs and coordinating/prioritizing conflicting requirements in a fast-paced environment.</li><li>Expert level understanding of Digital Asset Management solutions.</li></ol><h3>Additional Responsibilities:</h3><ol><li>Knowledge of operating systems, networking and corporate information systems infrastructure is desirable.</li><li>Experience interacting/collaborating with enterprise IT support teams (compute, network, storage, database) to resolve issues.</li><li>Experience working in a customer-service oriented environment, processing user requests and collaborating with engineering teams to provide new solutions.</li><li>Excellent collaboration, written and verbal communication skills.</li><li>Ability to communicate ideas in both technical and user-friendly language.</li><li>Experience in the media & entertainment industry relating to one or more of the following areas – metadata management, digital video, audio and image, asset management systems/platforms, and multimedia formats.</li><li>Experience working in a cloud environment like AWS, GCP, OCI or Azure.</li><li>Ability to successfully work under tight project deadlines.</li><li>Ability to multi-task, prioritize and resolve urgent issues.</li><li>Experience operating effectively as part of a project team and in managing own project work.</li><li>Experience working in a distributed global technology environment is a plus.</li><li>Self-motivated, great teammate who prioritizes results.</li><li>Ability to rapidly adapt to changes in technology solutions and business requirements.</li><li>Experience working with Web Based technologies and feature testing including UAT cycles.</li><li>Interpret usage data and develop reports and presentations.</li><li>Understanding of OpenText Media Management (OTMM) or other asset management systems.</li><li>Experience with XML, JSON, Web Services, REST APIs, and Messaging.</li><li>Engineering or development backgrounds highly desirable.</li><li>Bachelor’s degree or equivalent experience is preferred.</li></ol><h3>Supervision Given and Received:</h3><p>The position reports to the Exec Director, Enterprise Content Management. The role is required to operate effectively as part of a project team and in managing own work.</p><h3>Communication:</h3><p>This position communicates with all levels of personnel throughout the company. This position will interact with internal and outside engineers, software vendors, software developers, suppliers, other service technicians and non-technical business collaborators.</p>
#J-18808-Ljbffr

Paramount Pictures Interview Questions

Paramount Pictures Interview Guides

Paramount Pictures Interview Questions

Paramount Pictures Salaries by Position

Paramount Pictures Opening Jobs