Prepare for and practice interview questions from Paramount+.

Paramount+ Interview Questions

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

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?

Paramount+ Salaries by Position

Overview and Responsibilities: Paramount's Advanced Advertising has been leading the charge in data and data science for nearly a decade. Our ground breaking tools and systems empower advertisers by seamlessly integrating their campaigns with our award-winning programming, driving our business. As we grow, we're improving our systems to be more robust and scalable. We believe in the power of partnership, spending most of our time in always-on video rooms to facilitate face-to-face interaction and seamless collaboration. We work closely with our product, data science, operations, and sales teams to deliver top-notch software. At Paramount, we know that our best work is done together, not alone. About this role: As a Senior Software Engineer in Advanced Advertising, you'll take ownership of complex, high-impact projects that drive our mission forward. Your deep expertise in our tech stack will be key as you design, build, and maintain scalable systems and data pipelines. You'll be hands-on, shipping code to production, conducting code reviews, and helping improve the reliability and performance of our systems. In this role, you'll collaborate closely with multi-functional teams-product, data science, and stakeholders-to gather requirements and ensure we're solving the right problems with the right solutions. We value your input, and you'll have the autonomy to make key technical decisions while also having the support of more experienced engineers when needed. This is a role for someone who enjoys solving technical challenges, contributing to system design, and driving improvements in how we work. About you: You're a generalist engineer who has a passion for solving human problems. You've worked with large and complex systems that would overwhelm the average person, but you accept the challenge! You love collaborating with other engineers and working with partners to figure out what the best solution to a problem might be! Basic Qualifications: •4+ years of experience working on production codebases: this is a senior role with a lot of responsibility, and we're looking for people who can bring their unique experiences in all areas of the stack to the team. •Experience with at least 2 modern programming languages: preferably both statically typed and dynamically typed. •4 years of experience using SQL and production databases: much of what we do is in the data, and we need someone who can easily find their way around. Additional Qualifications: •Experience with Typescript and/or Python or a willingness to learn both Typescript and Python is necessary •REST and/or GraphQL APIs •Functional Programming •Containers, Docker, and Kubernetes •Workflow management tools (e.g., Argo Workflows, Airflow, AWS Step Functions) •Infrastructure as Code (IaC) - Terraform if possible •A cloud platform such as AWS, GCP, or Azure •Data Warehouses such as Snowflake, Redshift, or Big Query •Cloud-based object storage such as S3 or GCS •Learning and understanding the inner workings of the tools you use our tech stack Paramount Global (NASDAQ: PARA, PARAA) is a leading global media and entertainment company that creates premium content and experiences for audiences worldwide. Driven by iconic studios, networks and streaming services, Paramount's portfolio of consumer brands includes CBS, Showtime Networks, Paramount Pictures, Nickelodeon, MTV, Comedy Central, BET, Paramount+, Pluto TV and Simon & Schuster, among others. Paramount delivers the largest share of the U.S. television audience and boasts one of the industry's most important and extensive libraries of TV and film titles. In addition to offering innovative streaming services and digital video products, the company provides powerful capabilities in production, distribution and advertising solutions. ADDITIONAL INFORMATION Hiring Salary Range: $124,000.00 - 155,000.00. The hiring salary range for this position applies to New York, California, Colorado, Washington state, and most other geographies. Starting pay for the successful applicant depends on a variety of job-related factors, including but not limited to geographic location, market demands, experience, training, and education. The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable, as otherwise dictated by the appropriate Collective Bargaining Agreement. https://www.paramount.com/careers/benefits Paramount is an equal opportunity employer (EOE) including disability/vet. At Paramount, the spirit of inclusion feeds into everything that we do, on-screen and off. From the programming and movies we create to employee benefits/programs and social impact outreach initiatives, we believe that opportunity, access, resources and rewards should be available to and for the benefit of all. Paramount is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, creed, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, and Veteran status. If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access https://www.paramount.com/careers as a result of your disability. You can request reasonable accommodations by calling 212.846.5500 or by sending an email to paramountaccommodations@paramount.com. Only messages left for this purpose will be returned.

Overview and Responsibilities: Paramount's Advanced Advertising has been leading the charge in data and data science for nearly a decade. Our cutting-edge tools and systems empower advertisers by seamlessly integrating their campaigns with our award-winning programming, driving our business. We're also scaling! As we grow, we're enhancing our systems to be more robust and scalable. We also believe in the power of teamwork, spending most of our time in always-on video rooms to facilitate face-to-face interaction and seamless collaboration. We work closely with our product, data science, operations, and sales teams to deliver top-notch software. At Paramount, we know that our best work is done together, not alone. About this role As a Lead Software Engineer in Advanced Advertising, you'll be the driving force behind larger, more ambiguous projects, guiding them from start to completion. You'll take a leadership role in our engineering team, mentoring less experienced engineers, and help them navigate uncertainty and complex technical challenges. Your experience with our tech stack enables you to own key systems and influence their evolution. In addition to coding and design, you'll spend more time coordinating with stakeholders and ensuring that our team's technical direction aligns with broader business goals. You'll facilitate a self-organizing team environment, where collaboration and clear communication lead to better software. This role is ideal for an experienced engineer who thrives in ambiguity, makes autonomous decisions, and ensures both team and individual success. You'll not only contribute technically but also shape how the team approaches problems, guiding toward scalable and efficient solutions. About you You're a generalist engineer who has a passion for solving human problems. You've worked with large and sometimes complex systems that would overwhelm your average person, but you embrace the challenge. You love collaborating with other engineers and interfacing with stakeholders to figure out what the best solution to a problem might be. You believe that the simplest solution to a problem is usually the best one and you live by principles like YAGNI-'you ain't gonna need it'. Basic Qualifications: <ul> <li>6+ years of experience working on production codebases: this is a senior role with a lot of responsibility and we're looking for people who can bring their unique experiences in all areas of the stack to the team.</li></ul><ul> <li>Experience with at least 2 modern programming languages: preferably both statically typed and dynamically typed.</li></ul><ul> <li>6+ years of experience using SQL and production databases: much of what we do is in the data, and we need someone who can easily find their way around.</li></ul> Additional Qualifications: <ul> <li>Experience with Typescript and/or Python or a willingness to learn both Typescript and Python is necessary!</li></ul><ul> <li>REST and/or GraphQL APIs</li></ul><ul> <li>Functional Programming</li></ul><ul> <li>Containers, Docker, and Kubernetes</li></ul><ul> <li>Workflow management tools (e.g., Argo Workflows, Airflow, AWS Step Functions)</li></ul><ul> <li>Infrastructure as Code (IaC) - Terraform if possible</li></ul><ul> <li>A cloud platform such as AWS, GCP, or Azure</li></ul><ul> <li>Data Warehouses such as Snowflake, Redshift, or Big Query</li></ul><ul> <li>Cloud-based object storage such as S3 or GCS</li></ul><ul> <li>Learning and understanding the inner workings of the tools you use Our tech stack</li></ul> Paramount Global (NASDAQ: PARA, PARAA) is a leading global media and entertainment company that creates premium content and experiences for audiences worldwide. Driven by iconic studios, networks and streaming services, Paramount's portfolio of consumer brands includes CBS, Showtime Networks, Paramount Pictures, Nickelodeon, MTV, Comedy Central, BET, Paramount+, Pluto TV and Simon & Schuster, among others. Paramount delivers the largest share of the U.S. television audience and boasts one of the industry's most important and extensive libraries of TV and film titles. In addition to offering innovative streaming services and digital video products, the company provides powerful capabilities in production, distribution and advertising solutions. ADDITIONAL INFORMATION Hiring Salary Range: $139,200.00 - 174,000.00. The hiring salary range for this position applies to New York City, California, Colorado, Washington state, and most other geographies. Starting pay for the successful applicant depends on a variety of job-related factors, including but not limited to geographic location, market demands, experience, training, and education. The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable, as otherwise dictated by the appropriate Collective Bargaining Agreement. This position is eligible to earn sales incentive compensation. https://www.paramount.com/careers/benefits Paramount is an equal opportunity employer (EOE) including disability/vet. At Paramount, the spirit of inclusion feeds into everything that we do, on-screen and off. From the programming and movies we create to employee benefits/programs and social impact outreach initiatives, we believe that opportunity, access, resources and rewards should be available to and for the benefit of all. Paramount is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, creed, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, and Veteran status. If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access https://www.paramount.com/careers as a result of your disability. You can request reasonable accommodations by calling 212.846.5500 or by sending an email to paramountaccommodations@paramount.com. Only messages left for this purpose will be returned.

Paramount is a leading global media and entertainment company that creates premium content and experiences for audiences worldwide. Driven by iconic consumer brands, its portfolio includes CBS, Showtime Networks, Paramount Pictures, Nickelodeon, MTV, Comedy Central, BET, Paramount+, Pluto TV, among others. The company delivers the largest share of the U.S. television audience and boasts one of the industry's most important and extensive libraries of TV and film titles. In addition to offering innovative streaming services and digital video products, Paramount provides powerful capabilities in production, distribution and advertising solutions for partners on five continents.Overview and Responsibilities:Paramount is looking for a Salesforce Business Analyst to join the team! In this role, you will be responsible for the day-to-day configuration, support, maintenance, and improvement of our Salesforce platform! The ideal candidate will work closely with functional leaders, organizational units, and domain experts to identify, develop, and deploy new business processes.Responsibilities: Handle Salesforce platform, including user setup, profiles, roles, customization of objects, fields, record types, page layouts, and validations. Handle all administrative functions including user account maintenance, reports and dashboards, workflows, and other routine tasks. Design, develop, and test automation flows. Work directly with partners to collect business requirements and translate them into technical approaches and designs that can be implemented. Develop and maintain custom reports, dashboards, and processes to continuously monitor data quality and integrity. Build and maintain documentation, including process flows, data models, and user guides. Ensure data integrity and security within the Salesforce platform. Deliver training and support to Salesforce users. Collaborate with IT and other groups to ensure Salesforce environment supports internal needs relating to functionality and performance. Stay updated on Salesforce releases, new features, and standard processes. Reviews test plans and scripts against requirements for completeness and accuracy. Perform application testing which includes detailing test scripts, performing test scripts, detailing results, and logging/handling issues. Facilitate rollout activities that are needed for support and making projects successful - UAT, business user training, and documentation. Support an Agile software development process, working in conjunction with end users, partners, technical delivery teams and program management. Provide guidance and assistance to the applications users and support teams on all aspects of application deployment, training, and support, including installation, configuration, and first and second tier support. Identify and resolve issues, including issue tracking and escalation.Basic Qualifications: Desired but not required Bachelor's degree in Business Administration, Information Technology, or a related field preferred. 2+ years experience as a Salesforce Business Analyst or in a similar role working on the Salesforce platform. Solid grasp of Salesforce platform and its capabilities. Proficiency in Salesforce configuration, customization, and reporting. Strong Data skills and proficiency with data capabilities of Excel and/or SQL.Additional Qualifications: Good communication and interpersonal skills Ability to work independently and as part of a team Salesforce certifications (e.g., Salesforce Administrator, Salesforce Business Analyst) are a plus Experience with Salesforce Lightning Advanced knowledge of User configuration and maintenance (Profiles, Roles, Permission Sets, etc.) In-depth knowledge of Security features (sharing settings, field accessibility, etc) Advanced knowledge of Objects, Fields, Automations/Flows, etc. Knowledge of Agile processes and principals Proficiency with Microsoft Office applications Strong interest and proficiency towards continuous improvement, process efficiency and scale, and technology and automation solutions Excellent documentation skills & experience creating detailed reports. Ability to work independently with little direction to drive the understanding of requirements and work across the team for the implementation of new processes, procedures, or implementations Excellent project management skills and a positive outlook Good communication skills and the ability to work multi-functionally with various partnersParamount Global (NASDAQ: PARA, PARAA) is a leading global media and entertainment company that creates premium content and experiences for audiences worldwide. Driven by iconic studios, networks and streaming services, Paramount's portfolio of consumer brands includes CBS, Showtime Networks, Paramount Pictures, Nickelodeon, MTV, Comedy Central, BET, Paramount+, Pluto TV and Simon & Schuster, among others. Paramount delivers the largest share of the U.S. television audience and boasts one of the industry's most important and extensive libraries of TV and film titles. In addition to offering innovative streaming services and digital video products, the company provides powerful capabilities in production, distribution and advertising solutions.ADDITIONAL INFORMATIONHiring Salary Range: $80,000.00 - 95,000.00. The hiring salary range for this position applies to New York, California, Colorado, Washington state, and most other geographies. Starting pay for the successful applicant depends on a variety of job-related factors, including but not limited to geographic location, market demands, experience, training, and education. The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable, as otherwise dictated by the appropriate Collective Bargaining Agreement. This position is bonus eligible. https://www.paramount.com/careers/benefitsParamount is an equal opportunity employer (EOE) including disability/vet.At Paramount, the spirit of inclusion feeds into everything that we do, on-screen and off. From the programming and movies we create to employee benefits/programs and social impact outreach initiatives, we believe that opportunity, access, resources and rewards should be available to and for the benefit of all. Paramount is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, creed, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, and Veteran status.If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access https://www.paramount.com/careers as a result of your disability. You can request reasonable accommodations by calling 212.846.5500 or by sending an email to paramountaccommodations@paramount.com. Only messages left for this purpose will be returned.

Paramount+ Interview Questions

Paramount+ Interview Guides

Paramount+ Interview Questions

Paramount+ Salaries by Position

Paramount+ Opening Jobs