Prepare for and practice interview questions from Publicis Media.

Publicis Media Interview Questions

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

Publicis Media Salaries by Position

<p>Publicis Media harnesses the power of modern media through global agency brands CJ, Performics, Publicis Collective, Publicis Health Media, Spark Foundry, Starcom and Zenith. A key business solution of Publicis Groupe ([Euronext Paris FR0000130577, CAC 40], Publicis Media’s digital-first, data-driven global practices deliver client value and increase growth in a platform-powered world. It is present in more than sixty countries with over 23,000 employees worldwide.

Job Description

As a front-end engineer in our technology team, you will develop and provide solutions that enable our agency teams to win in a marketplace. You will work with UX / Design, Product and fellow engineers to deliver transformative solutions across our platform.
As a UI engineer you will provide estimates and contributing to shared component code. You will work with reusable patterns, tests and documentation.
You will report to Senior Vice President, Data Engineering.
This is a hybrid role, requiring three days in-office each week. If you are contacted for an interview, your recruiter will discuss specifics with you, inclusive of any necessary reasonable accommodations.
Responsibilities:
Discuss implementation details of UI/UX designs
Provide estimations for time and level of effort
Contribute to a shared component library
Employ best practices around semantic markup and web accessibility
Build pages to be responsive, performant and to handle errors accordingly
Work in an Agile environment
Manage deliverables as assigned in Jira
Perform peer code reviews

Qualifications

3+ years of experience with web technologies including HTML, CSS, JavaScript
Experience developing web applications in React
Proficiency with the latest JavaScript syntax (ES6+)
CSS skillset and experience using CSS preprocessors such as SASS
Experience with NodeJS and common build tools such as Webpack, Babel and Vite
Understanding of Web Accessibility best practices
Understanding of asynchronous request handling, promises and RESTful APIs
Understanding of cross-browser compatibility issues and workarounds
Experience with cloud platforms such as AWS and Azure
Experience developing UI components utilizing Storybook

Additional Information

Our Publicis Groupe motto “Viva LaDifférence”meanswe’rebetter together, and we believe thatour differences make us stronger. It means wehonor and celebrate all identities, across all facetsof intersectionality, and it underpins all that we doas an organization.We are focusedon fostering belonging and creating equitable &inclusive experiences for all talent.
Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.
If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com.
All your information will be kept confidential according to EEO guidelines.
Compensation Range: $70,000 - $105,000 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 08/20/2024.
Req #24-6251

#J-18808-Ljbffr</p>

Publicis Media Interview Questions

Publicis Media Interview Guides

Publicis Media Interview Questions

Publicis Media Salaries by Position

Publicis Media Opening Jobs