Prepare for and practice interview questions from Sogeti.

Sogeti Interview Questions

Sogeti 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

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

Sogeti Salaries by Position

Position: Data Analyst with Excel Location: Seattle or Charlotte Hybrid/ Remote - DOE What do you need to start? <ul> Able to work in team support services </li> Intermediate level knowledge of Excel </li> Able to identify errors </li> Able to work under pressure and to strict deadlines, and comfortable working in a quick turnaround environment, while maintaining accuracy; </li> Ability to be a reliable, hands-on deliverer of quality results; </li> Excellent communication skills (both written and verbal) in English </li> Strong team-working skills with ability to work independently; </li> Comfortable working in cross-functional teams and working in an unstructured environment; </li> Demonstrated ability to manage multiple competing priorities simultaneously and drive projects to completion; </li> Attention to detail; </li> Organized, proactive and results oriented </li> </ul> What duties will help you grow? <ul> Creating, processing, and analyzing volume licensing contracts </li> Supporting worldwide licensing and pricing contracts to ensure compliance and accuracy </li> Reviewing agreements and Pricing sheet to help maintain quality and need established policies </li> Supporting sales software licensing specialists internationally </li> Recalculating products prices to not standard ones and other custom adjustments </li> Assuring that pricing proposal has correct visibility, depending on custom adjustments done by Team member </li> Working on standard agreement due to tool limitations or errors </li> Team and queue management, end to end ownership of the team's delivery and queue </li> Support Quality Audit on completed deals to maintain accuracy and zero defects </li> Regular meetings with team and sharing feedback </li> Identify training gaps and arrange knowledge refresher </li> Backup for Delivery Manager and other leads </li> Sharing daily report with managers and leadership </li> Performance review for assigned processors </li> Ability to deliver formal training, cross training on complex processes in a concise, organized manner to the team members, new hires as an ongoing operational activity </li> </ul> What have we prepared for you? Space where you can develop yourself: <ul> Development programs, external courses & conferences, co-funding for certificates, NEXT platform with free access to TED talks, Coursera materials, articles and virtual trainings: MS Azure, AWS, Google Cloud or ServiceNow. </li> Up to $12,000 annually towards education. </li> You will have possibility to join various technical communities. </li> Flexible working hours thanks to a variety of projects. Ask your recruiter about possible options. </li> </ul> Our atmosphere: <ul> We don't have a rigid dress code, but what we do have are awesome communities and world - changing initiatives. There's always someone happy to start a day with a cup of coffee with you - even virtually! We are a big company with unique atmosphere - we make friendships, share important moments, and... simply like each other! </li> </ul> Job Requirements <ul> Bachelor's degree. </li> </ul> Benefits our employees enjoy working at Sogeti USA: <ul> 401(k) Savings Plan: matched 150% up to 6%. Our 401k is in the top 1% of 401(k) plans offered in the US! </li> Employee Stock Option Plan </li> Annual Individual Bonus Plan </li> Medical/Prescription/Dental/Vision Coverage: low premium and deductible with free preventative care </li> Life Insurance: provided at 2x base salary plus long term and short term disability </li> 100% Company-paid Mobile Phone Plan </li> Personal Time Off (PTO): ensuring a balance of work and home life </li> Career Planning and Coaching Program </li> All of our employees receive wide-ranging training covering business acumen, technical and professional skills development. Employees also have opportunities to hone your functional skills and expertise in an area of specialization. We offer a variety of formal and informal training programs at every level to help employees acquire and build specialized skills faster. Learning takes place both on the job and through formal training conducted online, in the classroom, or in collaboration with teammates. </li> Continuing Education: $12,000 Annual Tuition Reimbursement plus access to over 20,000 online courses and certifications through Capgemini University, as well as many offerings through Coursera and Degreed. </li> Paid Parental Leave: eligibility up to 6 weeks </li> Adoption Assistance: up to $5,000 </li> Perks and Discount Programs for Health, Fitness, Auto and many more </li> Counseling, Assistance and other Support Programs </li> The sheer variety of work we do, and the experience it offers, provide an unbeatable platform from which to build a career! </li> </ul>

Sogeti is looking for a talented Sr Data Analyst with Alteryx-AI Analytics expertise to join our Chicagoland team built on the success of our people and partnerships. Come be a part of our “People centric” culture! Sogeti is a wholly-owned subsidiary of Capgemini and the Technology and Engineering Services Division of Capgemini. We have more than 25,000 professionals in 15 countries and has a strong local presence in over 100 locations scattered throughout the US, Europe and India. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be THE employer of choice! POSITION HIGHLIGHTSYou would be hired as a permanent Sogeti Consultant. An expert in field who will provide guidance and experience a variety of exciting projects, work within different workplaces with diverse teams and various industries. All Sogeti Prospective Candidates Must:Possess a Bachelors and/or Masters Degree from an accredited institution.Must have valid work authorization that does not currently and/or will not require future require sponsorship of a visa for employment authorization in the US by Sogeti-Capgemini. JOB SUMMARYWe are seeking a skilled Sr Data Analyst with Alteryx-AI Analytics expertise. You will support and enhance reporting capabilities through advanced analytics tools. In addition, you will design reports and visualizations, collaborate with teams for data integration, to automate workflows, as well as to identify opportunities for process improvements. RESPONSIBILITIES:<ul><li>Document data interfaces.</li><li>Analyze and interpret data.</li><li>Data sourcing activities.</li><li>Develop business and technical requirement documents.</li><li>Document complex data mappings.</li><li>Design and execute data quality checks.</li><li>Design and execute data validation across multiple data sources using Alteryx.</li><li>Assist with data modeling.</li><li>Assist with project management and tracking; regular meetings with PMs and developers, create test plans, project plans, implementation plans and track project through SDLC life cycle.</li><li>Work with Developers to ensure specifications are understood and followed.</li><li>Support quality assurance and user acceptance testing.</li><li>Provide post-production support for both maintenance and enhancement solutions.</li></ul> QUALIFICATIONS:<ul><li>Minimum of 8 years of experience in a business analytics role serving as a Lead or Manager.</li><li>Alteryx experience is required.</li><li>Experience with Salesforce Sales and/or Salesforce Marketing Cloud.</li><li>Strong SQL skills to query SQL databases.</li><li>Data Warehouse or Business Intelligence experience.</li><li>Extensive experience with data sourcing, profiling, cleansing and pruning.</li><li>Experience documenting complex data mappings.</li><li>Experience with data migrations between applications.</li><li>Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy.</li><li>Experience in data integration and data quality projects.</li><li>Expertise in SDLC full project life cycle.</li><li>Project management experience</li><li>Client facing abilities to communicate technically complex IT concepts to business clients, stakeholders and teams.</li><li>Ability to multi-task easily and juggle priorities in a fast-paced environment.</li></ul> Benefits our employees enjoy working at Sogeti USA: 401(k) Savings Plan: matched 150% up to 6%. Our 401k is in the top 1% of 401(k) plans offered in the US!Employee Stock Option PlanAnnual Individual Bonus PlanMedical/Prescription/Dental/Vision InsuranceLife Insurance100% Company-paid Mobile Phone PlanPersonal Time Off (PTO)Career Planning and Coaching ProgramContinuing Education: $12,000 Annual Tuition Reimbursement plus access to over 20,000 online courses and certifications through Capgemini University, as well as Coursera and Degreed.Paid Parental LeaveAdoption AssistanceCounseling, Employee Assistance and other Support Programs for Physical, Financial, Family & Social, Emotional & Spiritual Wellbeing Equal Employment Opportunity All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state or local law.Please be aware that Sogeti-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. In order for you to be reviewed and receive feedback on your application, all prospective candidates must possess all requirements (exact or comparable). If you do not receive feedback, you are welcome to reach out to me at any point for more specifics. Paige Evans, Senior Corporate IT Recruiter | IllinoisSogetiE: paige.evans@sogeti.com

Part 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. At Sogeti USA, we are committed to building a long and enduring relationship with our employees and to creating an environment that rewards and empowers. Our mission is to constantly exceed our employees' expectations in the same way that we strive to exceed our clients' expectations. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be an employer of choice! The Data Analyst will play a critical role in building an interactive user interface by bridging data insights with user needs. The data analyst will be responsible for systematically processing and performing statistical analyses on data sets to enhance customer experience.The Data Analyst will transform data into structured information, which will then be analyzed to glean insights that drive strategic decision making The Data Analyst will be responsible for:<ul><li>Working closely with data engineers, developers, and the user community to ensure that user needs are fully integrated into the interactive experience.</li><li>Identifying and define relevant metrics.</li><li>Aggregating data across sources and conduct analyses to derive meaningful trends and insights that users need.</li><li>Developing interactive charts, tables, and graphs using libraries like Plotly, Dash, or Streamlit to create an engaging, Python-based interface.</li></ul>The following qualifications are required:<ul><li>More than 5 years of professional experience in data analysis, data visualization and/or data science.</li><li>Deep understanding of the to use of libraries such as Plotly, Dash, or Streamlit to create an interactive dashboard, providing real-time insights and responsive data visualizations.</li><li>Ability to create and integrate interactive elements like dropdowns, sliders, and filters, enabling users to customize their view of compliance metrics.</li><li>Skills to conduct usability testing of visualizations and components, refining designs to ensure they convey insights effectively and can handle real-time data changes without compromising performance.</li><li>Exceptional verbal and written communication skills</li></ul> Education:<ul><li>Bachelor's or Master's degree in Computer Science, Software Engineering, or a related field.</li></ul> Life at SogetiWe support all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:<ul><li>Flexible work</li><li>Healthcare including dental, vision, mental health, and well-being programs</li><li>Financial well-being programs such as 401(k) (matched 150% up to 6%) and Employee Share Ownership Plan</li><li>100% Company-paid mobile phone plan</li><li>3 weeks Personal Time Off (PTO) and 7 Paid Holidays</li><li>Paid parental leave</li><li>Family building benefits like adoption assistance, surrogacy, and cryopreservation</li><li>Social well-being benefits like subsidized back-up child/elder care and tutoring</li><li>Mentoring, coaching and learning programs</li><li>Continuing Education: $12,000 Annual Tuition Reimbursement plus access to over 20,000 online courses and certifications through Capgemini University, as well as Coursera and Degreed.</li><li>Programs for Counseling, Support, Health and Fitness perks, Auto discounts and much, much more!</li><li>Employee Resource Groups</li><li>Disaster Relief</li></ul> 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.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. 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 accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact. Click the following link for more information on your rights as an Applicant <a>http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law</a> Applicants 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. If this position is in Colorado, Nevada, New York, California, or Washington: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 [recruiter to insert salary range]. 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.

Responsibilities & Requirements:The SFMC Business Analyst is a business consultant focused on the use and integration of Salesforce Marketing Cloud for patient and healthcare professional marketing.<ul><li>Work with the client to understand and gather requirements</li><li>Present functional specifications to stakeholders for review/acceptance and compliance with requirements</li><li>Lead backlog refinement and organize meeting by defining, grooming, and prioritizing user stories</li><li>Work closely with developers and testers to ensure requirements and functional designs are translated accurately into working technical designs</li><li>7+ years of professional experience, 2+ in SFMC</li><li>Must have excellent communication skills as this is a customer facing role</li><li>Experience with Interaction Studio and Data Cloud would be nice to have </li><li>Understanding of Agile/Scrum principles and experience using tools like Jira and Confluence is required</li></ul>

Sogeti is a leading provider of professional technology services, specializing in Application Management, Infrastructure Management and High-Tech Engineering. Sogeti offers cutting-edge solutions around Testing, Business Intelligence, Mobility, Cloud and Security, combining world class methodologies and the global delivery model, Rightshore®. Sogeti brings together more than 20,000 professionals in 15 countries and is present in over 100 locations in Europe, the US and India. Sogeti is part of Cap Gemini S.A., listed on the Paris Stock Exchange. At Sogeti USA, we are committed to building a long and enduring relationship with our employees and to creating an environment that rewards and empowers. Our mission is to constantly exceed our employees' expectations in the same way that we strive to exceed our clients' expectations. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be an employer of choice! What You'll Do 4+ years of experience in a Data Engineer role, with a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. Very good knowledge in: <ul><li> PySpark (7+ out of 10) </li><li> SparkSQL (7+ out of 10) </li><li> SQL (7+ out of 10) </li><li> Databricks on Azure (7+ out of 10) </li><li> Azure/ADLS (7+ out of 10) </li><li> Python (7+ out of 10) </li><li> Strong working knowledge of ADF and ADB (6+ out of 10) </li><li> Data Modeling (5+ out of 10) </li><li>Microsoft Fabric certification and/or working knowledge of MSFT Fabric, very strongly desired.</li><li>Knowledge of reporting platforms like Power BI, Tableau is a strong plus</li><li>Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.</li><li>Great numerical and analytical skills; Data Analysis - Analyze and organize raw data </li><li>Experience supporting and working with cross-functional teams in a dynamic environment.</li><li>Data engineering certifications/Azure/Databricks is a plus</li><li>Combine raw information from different sources; Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.</li><li>Create and maintain optimal data pipeline architecture</li><li>Explore ways to enhance data quality and reliability</li><li>Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues</li><li>Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.</li><li>Write pseudo code; Build processes supporting data transformation, data structures, metadata, dependency, and workload management</li><li>Any pre-sales/proposal support experience is a plus</li><li>Experience working with offshore teams</li><li>Very good communication/speaking skills</li></ul> Minimum education qualification <ul> <li>Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field.</li> </ul> The benefits our employees enjoy: <ul> <li>401(k) Savings Plan- Matched 150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in the US!)</li> <li>Medical/Prescription/Dental/Vision Coverage!</li> <li>Low-premium and deductible. Plan with free preventive care.</li> <li>$12,000 in Tuition Reimbursement</li> <li>100% Company-paid mobile phone plan</li> <li>Personal Time Off (PTO)- Ensuring a balance of work and home life</li> </ul>

We are seeking a Manufacturing Systems Business Analyst with an understanding of MES (Manufacturing Execution Systems) processes, shop floor connectivity, and OSI PI systems.<ul><li>Collaborate with stakeholders to gather and analyze business requirements for manufacturing systems.</li><li>Build comprehensive process maps to visualize and optimize manufacturing workflows.</li><li>Develop and maintain documentation, including business requirements, process flows, and use cases/user stories.</li><li>A minimum of 5+ years of experience in a manufacturing environment, with a focus on business analysis.</li><li>Strong understanding of MES processes and shop floor connectivity.</li><li>Proficient in manufacturing software and systems (e.g., ERP, MES, PLM).</li><li>Excellent problem-solving, analytical, and decision-making skills.</li><li>Strong communication skills, with the ability to effectively collaborate with technical and non-technical stakeholders.</li><li>Ability to build and present process maps and solutions to senior management.</li><li>Experience with Lean Manufacturing, Six Sigma, or other continuous improvement methodologies is a plus.</li><li>Must be able to travel to Juarez 3-6 times per year</li></ul>

Position Responsibilities<ul><li>Data Engineer is responsible for developing Life Sciences content curation and delivery system for the purpose of building life sciences databases that empower client proprietary life sciences search technologies. This role encompasses developing and deploying scientific software solutions in the life sciences information space to support transformational initiatives, delivering both short and long-term results to the business. </li><li>Develops data transformation and integration pipelines and infrastructure foundations of life sciences content in support of scientific databases and data curation. Combines strong software development and data engineering skills with a working knowledge of basic biology/chemistry/physics to develop sophisticated informatics solutions that drive efficiencies in content curation and workflow process. Applies data transformation and other data-engineering software development capabilities to contribute to the building of new scientific information management systems supporting scientific database building activities.</li></ul> Competencies/TechnologiesProficiency in PythonProficiency in other programming languages such as JavaScript/TypeScript/JavaProficiency in Linux/Unix environmentsExperience building applications for public cloud environments (AWS preferred)Experience with databases technologies (NoSQL, relational, property graph, RDF/triple store)Experience with data engineering tools and techniques is highly desiredExperience with AWS DevOps tools (git, Cloud Development Kit, CDK Pipeline) is highly desiredExperience building applications using AWS Serverless technologies such as Lambda, SQS, Fargate, S3 is highly desiredExperience working with XML and XPath is highly desiredExperience with MarkLogic/Xquery is a plusExperience with Apache Airflow is a plusExperience building containerized applications (Docker, Kubernetes) is a plusStrong communication, organizational savvy, interpersonal skillsSelf-motivated with the ability to work with minimal supervisionInnovates and continuously improves; focuses on areas of highest potential Minimum education qualificationEducation/ExperienceBachelor's DegreeMinimum of 4 years of software development experience Please be aware that Capgemini Sogeti 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 The benefits our employees enjoy:401(k) Savings Plan- Matched 150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in the US!)Medical/Prescription/Dental/Vision Coverage!Low-premium and deductible. Plan with free preventive care.$12,000 in Tuition Reimbursement100% Company-paid mobile phone planPersonal Time Off (PTO)- Ensuring a balance of work and home life

Sogeti Interview Questions

Sogeti Interview Guides

Sogeti Interview Questions

Sogeti Salaries by Position

Sogeti Opening Jobs