Prepare for and practice interview questions from Sogeti.

Sogeti Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Sogeti Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

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?

The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.

<ul>
<li>The attribution table logs a session visit for each row.</li>

<li>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</li>

<li>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</li>

<li>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</li>
</ul>

First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.

Calculate the first touch attribution for each <code>user_id</code> that converted. 

Example:

Input:

<code>attribution</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<code>user_sessions</code> table

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Example output:

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>

First Touch Attribution

Internal Job Information Location: Anywhere in the UK Grade – C2 /N8 About The Role The AI Product Manager plays a pivotal role in helping clients understand how AI can transform the way they work. This is a hands-on delivery role. You will join early-stage conversations with client teams to explore their goals, challenges, and everyday processes, identifying realistic AI opportunities and translating them into clear, actionable use cases and next steps. You will work closely with solution architects and delivery teams to ensure clients have a clear view of what’s possible now, what comes next, and what they need to build toward. While deep technical expertise is not required, you should have a solid understanding of AI fundamentals and how to apply AI safely and effectively in client environments. Hybrid working: The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time. If you are successfully offered this position, you will go through a series of pre-employment checks, including identity, nationality (single or dual) or immigration status, employment history going back 3 continuous years, and unspent criminal record check (known as Disclosure and Barring Service) Your role Mandatory Skills <ul><li>Support client teams through discovery (jumpstart) and strategy engagements to understand objectives and identify where AI can add value.</li><li>Analyze business processes and define practical AI use cases with measurable outcomes.</li><li>Produce clear discovery outputs, including use case summaries, readiness insights, and recommended next steps.</li><li>Collaborate with solution architects to align discovery findings with technical direction and broader offerings.</li><li>Shape delivery plans for Strategy, Packaged AI Solutions, and Build-Run-Scale engagements.</li><li>Advise clients on adoption needs, capability gaps, and next steps for AI progression.</li><li>Maintain structured, repeatable delivery materials and templates.</li><li>Track early value indicators and help clients build confidence in scaling AI solutions.</li><li>Capture lessons learned and contribute to continuous improvement of playbooks and delivery guides.</li><li>Work as part of a cross-functional team to deliver a consistent and trusted discovery experience. </li></ul>Essential Skills <ul><li>Proven experience supporting delivery of digital, data, or AI projects with client-facing responsibilities.</li><li>Strong ability to translate business needs into simple, clear use case descriptions.</li><li>Comfortable facilitating workshops, interviews, and structured discovery sessions.</li><li>Good understanding of AI fundamentals and practical considerations for safe and trusted adoption.</li><li>Familiarity with cloud platforms and common AI services.</li><li>Excellent communication skills, able to simplify complex ideas for diverse audiences.</li><li>Highly organized, detail-oriented, and skilled at maintaining clarity in documentation.</li><li>Strong collaboration skills across delivery, solution architecture, and client teams.</li><li>Proactive, problem-solving mindset with adaptability in fast-paced environments. </li></ul>What does 'Get the Future You Want' mean for you? You will be empowered to explore, innovate, and progress. You will benefit from Capgemini’s ‘learning for life’ mindset, meaning you will have countless training and development opportunities from thinktanks to hackathons, and access to 250,000 courses with numerous external certifications from AWS, Microsoft, Harvard Management or, Cybersecurity qualifications and much more. You will be encouraged to have a positive work-life balance. Our hybrid-first way of working means we embed hybrid working in all that we do and make flexible working arrangements the day-to-day reality for our people. All UK employees are eligible to request flexible working arrangements. Why You Should Consider Capgemini Growing clients’ businesses while building a more sustainable, more inclusive future is a tough ask. When you join Capgemini, you’ll join a thriving company and become part of a diverse collective of free-thinkers, entrepreneurs and industry experts. We find new ways technology can help us reimagine what’s possible. It’s why, together, we seek out opportunities that will transform the world’s leading businesses, and it’s how you’ll gain the experiences and connections you need to shape your future. By learning from each other every day, sharing knowledge, and always pushing yourself to do better, you’ll build the skills you want. You’ll use your skills to help our clients leverage technology to innovate and grow their business. So, it might not always be easy, but making the world a better place rarely is. About Capgemini Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.

Bij Sogeti geloven we dat data de sleutel is tot succes. Als Senior Data Engineer ben jij de architect van robuuste data-oplossingen die organisaties helpen om écht datagedreven te werken. Jij ontwerpt en bouwt schaalbare data pipelines, integreert complexe databronnen en zorgt dat data altijd betrouwbaar en toegankelijk is. Wat ga je doen?<ul><li>Ontwerpen en ontwikkelen van data-oplossingen in Azure en Databricks.</li><li>Werken met PySpark, Python en SQL om data te transformeren en optimaliseren.</li><li>Bouwen van ETL/ELT-processen met Azure Data Factory.</li><li>Samenwerken met data scientists en analisten om inzichten mogelijk te maken.</li><li>Meedenken over cloudarchitectuur, performance en security.</li></ul>Jouw impact: Met jouw expertise zorg je dat organisaties sneller en slimmer beslissingen nemen. Je werkt aan innovatieve projecten bij toonaangevende klanten en hebt de vrijheid om nieuwe technologieën toe te passen. Wat breng je mee?<ul><li>Ervaring met Azure Data Services, Databricks en PySpark.</li><li>Sterke kennis van Python en SQL.</li><li>Ervaring met data pipelines, CI/CD en Azure DevOps.</li><li>Affiniteit met data governance en security.</li></ul> Waarom Sogeti?<ul><li>Een vaste plek in een hecht team van data-experts.</li><li>Toegang tot kennisnetwerken, trainingen en certificeringen.</li><li>Projecten bij topbedrijven in Nederland.</li><li>Ruimte voor groei en innovatie.</li></ul>

Job Description Data engineers are responsible for building reliable and scalable data infrastructure that enables organizations to derive meaningful insights, make data-driven decisions, and unlock the value of their data assets. Job Description - Grade Specific The involves leading and managing a team of data engineers, overseeing data engineering projects, ensuring technical excellence, and fostering collaboration with stakeholders. They play a critical role in driving the success of data engineering initiatives and ensuring the delivery of reliable and high-quality data solutions to support the organization's data-driven objectives.

About the Project: The candidate will be responsible for maintaining and enhancing a large-scale enterprise application for Non-Merch Vendor Profile management. The system is built using Java (Spring, JSP/Servlets), with Maven, Docker, and integrates with various modules and services. What you’ll do: <ul><li>Maintain, debug, and enhance existing Java-based web applications. </li><li>Design and implement new features and APIs as per business requirements.</li><li> Write clean, efficient, and well-documented code. </li><li>Collaborate with business analysts, and other developers. </li><li>Perform code reviews and mentor junior developers. </li><li>Ensure application security, scalability, and performance. </li><li>Participate in deployment and release management (Maven, Docker, Tomcat). </li><li>Write and maintain unit and integration tests.</li></ul> What you’ll bring: <ul><li>7+ years of experience in Java (Spring, JSP/Servlets/Struts, JDBC). </li><li>Strong knowledge of RESTful APIs, JSON, and XML. </li><li>Experience with Maven, Git, and CI/CD pipelines. </li><li>Familiarity with Docker and containerized deployments. </li><li>Good understanding of SQL and relational databases (Oracle preferred). </li><li>Experience with front-end technologies (HTML, CSS, JavaScript, jQuery). </li><li>Experience with enterprise authentication/authorization (LDAP, SSO). </li><li>Strong problem-solving and debugging skills. </li><li>Excellent communication and documentation skills.</li></ul> Education:<ul><li>Bachelor’s or Master’s degree in Computer Science, Software Engineering, Information Systems, Business Administration, or a related field.</li></ul> Life at Sogeti - Sogeti supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:<ul><li>Flexible work options </li><li>401(k) with 150% match up to 6% </li><li>Employee Share Ownership Plan </li><li>Medical, Prescription, Dental & Vision Insurance </li><li>Life Insurance </li><li>100% Company-Paid Mobile Phone Plan </li><li>3 Weeks PTO + 7 Paid Holidays </li><li>Paid Parental Leave </li><li>Adoption, Surrogacy & Cryopreservation Assistance </li><li>Subsidized Back-up Child/Elder Care & Tutoring </li><li>Career Planning & Coaching </li><li>$5,250 Tuition Reimbursement & 20,000+ Online Courses </li><li>Employee Resource Groups </li><li>Counseling & Support for Physical, Financial, Emotional & Spiritual Well-being </li><li>Disaster Relief Programs</li></ul> About SogetiPart of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale. With a hands-on culture and close proximity to its clients, Sogeti implements solutions that will help organizations work faster, better, and smarter. By combining its agility and speed of implementation through a DevOps approach, Sogeti delivers innovative solutions in quality engineering, cloud and application development, all driven by AI, data and automation. Become Your Best | <a>www.sogeti.us</a> DisclaimerCapgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-lawApplicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is [$105,000-$130,000)This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

Sogeti Interview Questions

Sogeti Interview Guides

Sogeti Interview Questions

Sogeti Opening Jobs