Prepare for and practice interview questions from Publicis Groupe.

Publicis Groupe Interview Questions

Publicis Groupe Interview Guides

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

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

Publicis Groupe Salaries by Position

Company DescriptionPublicis Sapient is a digital transformation partner helping established organizations get to their future, digitally-enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value.<h3>Job Description</h3>As a Product Manager at Publicis Sapient, you act as your clients’ trusted advisor in leading the overall vision, strategy, roadmap, and prioritization for a specific digital product, or products, within an engagement. You will collaborate with clients undertaking major Digital Business Transformation (DBT) engagements to understand their business, end-customer needs, and then constantly deliver value with fast increment cycles.Your Impact:<ul><li>Partner with client(s), strategists, experience leads, and architects to frame business goals and value pools from which we can shape product propositions that provide transformative business outcomes and customer experience.</li><li>Develop product vision, strategy, market/user research, by keeping the customer at the center of everything we do while using design thinking tools.</li><li>Represent client in ideation workshops with cross-functional leaders where you identify new ideas, customer needs, pain points, and solution options.</li><li>Develop solution hypotheses iteratively, based on user research, and industry and market trend analysis.</li><li>Establish customer journey mapping to guide product development; then validate that learning with user testing.</li><li>Translate product vision into a roadmap containing well-defined, prioritized features that will realize the product vision and value.</li></ul><h3>Qualifications</h3>Your Skills & Experience:<ul><li>10+ years working experience Open Link Endur V16 & Higher.</li><li>Understanding of different Market Managers in Endur.</li><li>Good understanding of Crude & Refined products business.</li><li>Energy trading and risk management with emphasis on Oil Trading & scheduling.</li><li>In-depth knowledge of various derivatives instruments (Futures/swaps/options etc.) covering US and Europe markets.</li><li>Pipeline & cargo business.</li><li>Strong understanding of Trading, Operations settlements, accounting, and compliance functions.</li><li>Hands-on experience with Deal Modelling, C-motion, reference data, risk valuation, invoicing, settlements, and reporting within Endur.</li><li>PnL & Exposure reports & Simulations.</li><li>Endur JVS, Open Components (good to have).</li></ul>Good to Have:<ul><li>Able to understand business needs and convert to functional requirement, solution design and test.</li><li>Work with Traders/Operations/Market Risk group for new business/product setup & modelling.</li><li>Work with offshore technical team and provide required guidance.</li><li>Able to manage multiple tasks at hands and prioritize them per need.</li><li>Provide training when needed to business & prepare process guides.</li></ul>Set Yourself Apart With:<ul><li>Certified SAFe Product Owner/Product Manager designation.</li><li>Certified Agile Product Manager designation.</li></ul>Additional InformationAs part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at <a href="#">hiring@publicissapient.com</a> or you may call us at +1-617-621-0200.Pay Range: $75,000 - $146,000 The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. Actual range for this position may differ, depending on location and specific skillset required for the work itself.
#J-18808-Ljbffr

Company DescriptionPublicis Sapient is a digital transformation partner helping established organizations get to their future, digitally-enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting and customer obsession to accelerate our clients' businesses through designing the products and services their customers truly value.Job DescriptionAs a Product Manager at Publicis Sapient, you act as your clients' trusted advisor in leading the overall vision, strategy, roadmap, and prioritization for a specific digital product, or products, within an engagement. You will collaborate with clients undertaking major Digital Business Transformation (DBT) engagements to understand their business, end-customer needs, and then constantly deliver value with fast increment cycles.Your Impact:* Partner with client(s), strategists, experience leads, and architects to frame business goals and value pools from which we can shape product propositions that provide transformative business outcomes and customer experience* Develop product vision, strategy, market/user research, by keeping the customer at the center of everything we do while using design thinking tools* Represent client in ideation workshops with cross-functional leaders where you identify new ideas, customer needs, pain points, and solution options* Develop solution hypotheses iteratively, based on user research, and industry and market trend analysis* Establish customer journey mapping to guide product development; then validate that learning with user testing* Translate product vision into a roadmap containing well-defined, prioritized features that will realize the product vision and valueQualificationsYour Skills & Experience:* 10+ years working experience Open Link Endur V16 & Higher* Understanding of different Market Managers in Endur* Good understanding of Crude & Refined products business* Energy trading and risk management with emphasis on Oil Trading & scheduling* Indepth knowledge of various derivatives instruments (Futures/swaps/options etc.) covering US and Europe markets* Pipeline & cargo business* Strong understanding of Trading, Operations settlements, accounting, and compliance functions* Hands-on experience with Deal Modelling, C-motion, reference data, risk valuation, invoicing, settlements, and reporting within Endur* PnL & Exposure reports & Simulations* Endur JVS, Open Components (good to have)Good to Have:* Able to understand business needs and convert to functional requirement, solution design and test* Work with Traders/Operations/Market Risk group for new business/product setup & modelling* Work with offshore technical team and provide required guidance* Able to manage multiple tasks at hands and prioritize them per need* Provide training when needed to business & prepare process guidesSet Yourself Apart With:* Certified SAFe Product Owner/Product Manager designation* Certified Agile Product Manager designationAdditional InformationAs part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at hiring@publicissapient.com or you may call us at +1-617-621-0200.Pay Range: $75,000 - $146,000The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. Actual range for this position may differ, depending on location and specific skillset required for the work itself.

Publicis Groupe Interview Questions

Publicis Groupe Interview Guides

Publicis Groupe Interview Questions

Publicis Groupe Salaries by Position

Publicis Groupe Opening Jobs