Prepare for and practice interview questions from Sogeti.

Sogeti Interview Questions

Sogeti Interview Guides

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?

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?

Sogeti Salaries by Position

NO C2C | USC, GC work authorizations are eligible The Associate Business Analyst will work with the Product and Dev teams to support the implementation of departmental initiatives. Within the systems development life cycle, the Associate Business Analyst will take an active role in the business and technical aspects of design and problem resolution and act as a liaison between the project and stakeholders. Responsibilities<ul><li>Eliciting, documenting, reviewing, and obtaining approval of business and requirements from key stakeholders using industry standard methods</li><li>Conducting requirements gathering sessions; analyzing requirements gathered; identifying, documenting, and validating system requirements for continuous integration and deployment</li><li>Creating requirements documentation such as: Use cases, Screen prototypes, Specifications, and adhering to pre-established templates and utilizing a requirements management tool</li><li>Performing a gap analysis of COTS applications and their ability to meet implementation requirements</li><li>Developing and presenting justifications for system or business process requirements</li><li>Analyzing quantitative data to drive recommendations and decisions</li><li>Evaluating and providing feedback on vendor deliverables and/or artifacts throughout the project life cycle</li><li>Creating or improving existing templates for the business analysis functions</li><li>Providing other business analysis support as required</li></ul> Qualifications<ul><li>1-2 years' experience working on projects as a Business Analyst</li><li>Client focused business and requirements analysis experience and documentation</li><li>Experience conducting business process analysis and optimization in a technology environment</li><li>Creating requirements documentation</li><li>Strong analytical, written, and verbal communication skills</li><li>Healthcare industry experience preferred</li><li>Bilingual (Spanish & English) preferred</li></ul> **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.**

Chez Sogeti, la technologie coule dans nos veines. C’est cet intérêt pour la technologie qui nous guide au quotidien et qui est reflété dans notre slogan « Made In Tech». Grâce à notre passion commune pour la technologie , à notre culture entrepreneuriale et à l'importance que nous accordons à la formation continue, nous mettrons tout en œuvre pour vous accompagner à libérer votre plein potentiel. Vos missions : Vous aiderez le chef de projet et le Product Owner (PO) à piloter la mise en place des processus en mode agile. Vous interviendrez également :<ul><li>Au recueil et à la priorisation des besoins,</li><li>A la participation aux cérémonies agiles,</li><li>A la coordination avec les Product owner (back et front + autres applicatifs),</li><li>Aux tests et à la validation des développements,</li><li>A l’accompagnement du changement auprès des utilisateurs (démo de déploiement…).</li><li>A la préparation des outils de communication auprès du comité de pilotage et autres services,</li><li>A l’enrichissement de la documentation.</li></ul> Votre profil :<ul><li>Vous disposez d’un BAC+5 et d'une expérience de 4 ans minimum,</li><li>Vous connaissez les principes de gestion de projet selon des méthodes Agiles (particulièrement Scrum),</li><li>Vous accordez beaucoup d'attention aux détails dans votre travail,</li><li>Vous êtes autonome et vous êtes une personne organisée et polyvalente,</li><li>Vous pouvez travailler en anglais</li></ul> Trois raisons de nous rejoindre :<ul><li>Qualité de vie au travail : accord de télétravail en France et à l’international, accord sur l’égalité professionnelle, la parentalité, l’équilibre des temps et la mobilité durable.</li><li>Apprentissage en continu certifications et formations en libre accès, accompagnement sur mesure avec votre career manager, parcours d’intégration sur 9 mois.</li><li>Avantages groupe & CSE : plan actionnariat, activités à tarifs préférentiels, remboursement partiel vacances, remboursement de votre abonnement sportif ou culturel.</li></ul> Nos engagements et nos priorités :Le groupe Capgemini encourage une culture inclusive dans un cadre multiculturel et handi accueillant. En nous rejoignant, vous intégrez un collectif qui valorise la diversité, développe le potentiel de ses talents, s’engage dans des initiatives solidaires avec ses partenaires, et se mobilise pour réduire son impact environnemental sur tous ses sites et auprès de ses clients. A propos de Sogeti :Sogeti fait partie du groupe Capgemini et accompagne les organisations dans leur mise en œuvre de l'innovation , en tant que partenaire local à l'échelle mondiale . En combinant son agilité et sa rapidité Sogeti propose des solutions innovantes en testing, cloud et développement d'applications , toutes pilotées par l'IA , les données et l'automatisation. Plus d’informations sur www.sogeti.com/fr

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 a wholly-owned subsidiary 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! Key Responsibilities Include Be responsible for designing, developing and maintaining the data architecture, data models and standards for various Data Integration & Data Warehousing projects in Snowflake, combined with other cloud technologies. Model new features and subject areas/data domains and integrate them with existing structures to provide a consistent solution as well as develop and maintain documentation of the data architecture, data flows and data models. Leverage Snowflake native technologies including snowpipe, snowsql and others. Leveraging integration tools that work with Snowflake including DBT, IICS, Python and Spark Work in cross function teams that combine technical, business and data science competencies. Provide technical leadership for the data projects Take ownership of technical solutions from design and architecture perspective, ensure the right direction and propose resolution to potential data pipeline-related problems. Experiences Required - Education, Key Experiences, Knowledge and Skills: 7+ years of success in consultative/complex technical sales and deployment projects, architecture, design, implementation, and/or support of highly distributed applications required 5+ years experience working with large complex enterprise accounts architecting cloud solutions for data estate workloads ( DW/ETL/BI projects preferred) Proficiency in data modelling, very good understanding of data management concepts such as 3NF, data mesh, Dimensional modeling and their specific applications 5+ years implementing large scale data projects within the cloud environment Collaboration and Communication. Acknowledged for driving decisions collaboratively, resolving conflicts and ensuring follow through with exceptional verbal and written communication skills. Ability to orchestrate, lead, and influence remote teams, ensuring successful implementation of customer projects. Enterprise-scale technical experience with cloud and hybrid infrastructures, architecture designs, database migrations, and technology management. required Breadth of technical experience and knowledge, with depth / Subject Matter Expertise in two or more of the following Data Platform Cloud solutions required: Datawarehousing including SQL DW, Snowflake, Databricks, Redshift, Big Query Modern Data storage technologies such as Azure DataLake, Databricks and AWS S3. Technical Capability and experience to learn new technologies and understand relevant cloud trend required Knowledge of Competitors: Knowledge of cloud development platforms preferred Education You likely possess an advanced degree in a quantitative field such as computer science, applied mathematics, statistics. At Sogeti, we also support an equivalent combination of education and experience. The Ideal Candidate Will Have Experience leading 1-2 Snowflake Cloud migrations Previous expertise with SnowSQL, advanced concepts (query performance tuning, time travel etc.) and features/tools (data sharing, events, SnowPipe etc.) Experience or understand of data pipelines and transformations leveraging python and spark/pyspark Snowflake SnowPro Certification is a plus Experience architecting solutions using MS Azure PaaS services and AWS PaaS services Experience leading distributed teams onshore and offshore Additional Qualifications A minimum 4-year bachelors degree in Computer Science or similar degree 10+ years as an Enterprise Data Architect Excellent verbal and written communication skills Consulting experience is required 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>$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>

Sogeti, a subsidiary of Capgemini, is seeking a dynamic and experienced Consultant to join our team in Dallas, Texas. With a strong emphasis on our people and partnerships, we foster a "People centric" culture where innovation thrives. 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 are leading provider of technology and software testing, specializing in Application, Infrastructure, Data, Analytics and Engineering Services. We offer cutting-edge solutions around Testing, Business Intelligence & Analytics, PLM, Mobile, Cloud, and Cyber Security, combining world class methodologies and its global delivery model, Rightshore®. Sogeti’s roots and the bedrock of our success lie in the provision of local professional services - teams of experienced IT professionals working closely with local clients. 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! *Although with Capgemini/Sogeti we can often offer visa sponsorships - we do not have time with this opportunity to complete a transfer. Please feel free to apply though and note that you require the transfer as this role does come up often so there may be more opportunities in the future. What you'll do:The Senior Data Analyst/Engineer Consultant is a catalyst for driving Enterprise Data & Analytics solutions. This person is accountable to ensure the alignment of data requirements between business and technology teams by working alongside business teams to understand business process and data flows. The Senior Data Analyst documents results of data profiling to facilitate decision making with executive and senior business data owners. Additionally, this person is required to provide expertise in analytics and visualization as it relates to Western Alliance Bank’s enterprise data warehouse and business line data marts.In this position, the Senior Data Analyst is hands-on in developing and publishing analysis artifacts as well as is a mentor to other analysts on the Enterprise Data & Analytics Team. The Senior Data Analyst will contribute to or provide leadership oversight to data solutions in the following three areas:· Implementing data quality management, including the development of the data quality rules for critical data elements based on the selected data quality dimensions and designing the data quality results database, dashboard, integration with our business glossary, and the automation of the process· Implementing enterprise data warehouse solutions, including the analysis for source systems, source to target mapping, and built-in data quality· Assist with Data Governance, including the data profiling for source systems, critical data element identification, and business glossary managementThis exciting opportunity requires the best of your data analysis, problem solving and collaboration skills. The Senior Data Analyst will contribute to the development of cross-business unit data solutions that are leveraged to improve our products and insights.The ideal candidate has strong business and technical analysis experience, a growth mindset, is outcome-focused, and fosters teamwork. Essential Functions:<ul><li>Partner with the Data Product Manager, Data Architects, and Data Engineering Manager to ensure data analysis is addressed in the product development lifecycle</li><li>Develop, implement, and support the processes and best practices for data exploration, data profiling, data quality and data mapping required for the tactical implementation of the Western Alliance Bank data strategy and roadmap</li><li>Collaborate with business data owners to execute data profiling and source data analysis for critical Western Alliance Bank applications and systems</li><li>Participate in data governance activities by partnering with the Enterprise Data Stewards as required</li><li>Participate and contribute to the data issues resolution process within our Data Governance function</li><li>Develop and manage the data lineage, business rules (data quality, cleansing, transformation rules, etc.), reference data, and mapping documents across the enterprise in the Metadata Management Tool</li><li>Apply data analysis skills to the data quality/data governance process and/or to the data flows required to engineer the enterprise data warehouse</li><li>Prepare analysis findings and communicate to both business and technical stakeholders</li><li>Create data visualizations to explain data analysis recommendations</li></ul> Minimum Qualifications<ul><li>Bachelor’s Degree in Engineering, MIS, or Data & Analytics or equivalent experience</li><li>5+ years’ experience with data analysis specifically as it relates to enterprise data management including data warehousing and source to target mapping</li><li>Strong experience with RDBMS and query language such as T-SQL, PL/SQL, Spark SQL</li><li>Strong experience using analytics tools such as SPSS, SAS, Tableau, PowerBI</li><li>Strong experience using data profiling/wrangling tools (Example: IDQ (preferred), Alteryx, Paxata, Trifacta, Tamlr, etc.)</li><li>Strong experience using common file formats such as CSV, TEXT, JSON, XML, XSD, etc.</li><li>Excellent problem solving and analytic skills</li><li>Excellent communication skills, both verbal and written, and ability to work collaboratively within a team, business stakeholders and executives</li></ul> Preferred Qualifications<ul><li>Experience in Agile, SAFe, and/or Scrum</li><li>Experience working in a data governance function</li><li>Experience integrating with data quality, data catalog and data lineage tools is a plus</li><li>Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer</li><li>Banking or financial services industry experience or other highly regulated industry experience</li><li>Experience integrating and using data science or statistical solutions</li></ul> Join us at Sogeti and become a part of a culture that celebrates innovation and fosters work-life balance. We strive to be the employer of choice, offering a supportive environment for professional growth and development. Minimum Education Qualifications:Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field. CompensationCapgemini 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 $50,000 - $180,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. DisclaimerPlease 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.

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 a wholly-owned subsidiary 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 Youll Do As an IT Business Analyst at Sogeti you will have the opportunity to: <ul> <li>Perform analysis of business issues, provide recommendations for possible solutions, work with Business users and IT project teams to drive decision making and define requirements for application development, ensuring that business needs are being met</li> <li>Complete documentation for business requirements which guide application development efforts, working closely with the development team and business teams to ensure successful implementation of business requirements</li> <li>Assist with the development and maintenance of the business requirements process used to define requirements for systems projects, assist with the definition and negotiation of project scope and create appropriate scope documentation</li> <li>Analyze opportunities to improve application reliability, provide recommendations for possible solutions, and work with IT and Business partners to implement solutions that enhance application and infrastructure reliability</li> <li>Perform analysis of compliance vulnerabilities, work with IT and Business teams to eliminate vulnerabilities, support internal and external audit related activities</li> <li>Communicate project status and escalates issues as needed</li> </ul>Minimum education qualification <ul> <li>A bachelor's degree in any discipline. MBA or equivalent degree preferred.</li> </ul>The ideal candidate will have:<ul> <li>3 - 5 years of experience in business analysis of product or software development</li> <li>Experience with development methodologies is highly desired</li> <li>Proven organizational skills with the ability to develop a detailed work plan to ensure project success</li> <li>Demonstrated ability to organize and facilitate large cross functional meetings</li> <li>Perform thorough requirement interviews with project stakeholders</li> <li>Ability to document project issues, risks, assumptions and requirements</li> <li>Demonstrated problem solving skills and the ability to work collaboratively with other departments to resolve issues</li> <li>The ability to analyze and develop business scenarios and use cases</li> <li>Consistently deliver project status and time tracking regularly to management</li> <li>Conduct comprehensive requirements reviews with project stakeholders, development and QA teams</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>$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>

Business Data Analyst with ESG Experience Direct hiring - FT with benefits Seattle, WA For the analyst position we are looking for someone with strong requirements gathering and ability to understand how data flows through the system to support those. Experience with ESG with knowledge of carbon calculators is required. Experience providing user support to Analytics business organization - prefer experience with Microsoft Azure Databricks, Azure Data Lake, Azure SQL DB, Azure SQL Data Warehouse and Oracle Exadata. Core Duties: Requirements Gathering, development, production support and user training. Qualifications/ Summary of Experience: <ul> Relevant functional/business process experience - 5 years Solution design, testing, and implementation experience - 5 years Applicable application and system configuration experience - 5 years Production support, system maintenance, upgrades, and enhancement delivery experience -5 years End user support and documentation experience - 6 years IT Project experience as project resource or lead - 2 years Solution design, testing, and implementation experience- 5 years Data Analysis- 2 years </ul> Required Knowledge, Skills and Abilities: <ul> Strong analytic and problem-solving skills; good working knowledge of SQL and ability to utilize ad-hoc query tools for data investigation / profiling and troubleshooting system issues Proven ability to work with and influence all levels of leadership to capture / validate requirements and convert into enterprise-wide, highly reliable and scalable technology solutions Skilled in the utilization of system development methodologies throughout the full project lifecycle. Ability to identify/define viable technology and process solutions to meet business objectives. Knowledge/skill to objectively assess benefits, costs, and feasibility of proposed solutions. Strong oral and written communication skills and can present technical requirements to business partner communities and provide effective end-user training Ability to lead, influence, and negotiate across a diverse group of stakeholders with conflicting priorities. Experience creating and updating effective documentation to drive solution development in alignment with business requirements: System integration specifications Functional design specifications Knowledge of effective testing practices and methodologies. Ability to effectively utilize available tools and resources (internal and external) to resolve issues. Ability to drive process improvement initiatives. Ability to coach/mentor less-experienced analysts. Ability to work effectively in self-directed manner. Intermediate skills in Microsoft Office applications such as Word, Excel, Visio, and Project. </ul> Minimum education qualification: <ul> Bachelor's Degree </ul> The benefits our employees enjoy: <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!) Medical/Prescription/Dental/Vision Coverage! Low-premium and deductible. Plan with free preventive care. $12,000 in Tuition Reimbursement 100% Company-paid mobile phone plan Personal Time Off (PTO)- Ensuring a balance of work and home life </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 a wholly-owned subsidiary 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! The Business Analyst will work with the team to design and build new capabilities and/or enhancements to a product, platform, or feature/application focusing on financial planning processes and systems Lead requirements analysis and UAT Functional experience with SAP Finance or Anaplan would Must have strong written and verbal skills Must have at least 8+ years of professional experience Must be very proactive and have strong coordination skills in a client facing role Must have a complete bachelors degree Hybrid, onsite in New Brunswick, NJ 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>

Sogeti Interview Questions

Sogeti Interview Guides

Sogeti Interview Questions

Sogeti Salaries by Position

Sogeti Opening Jobs