Sogeti Interview Questions and Answers

A question that is both tricky and simple.

Q1. Questions about biochemistry
Add your answer

Questions based on both numerical data and case studies.

Q1. Can you tell me about yourself?
Add your answer
Q2. What interests you in working for this company?
Ans. 
I am interested in working for this company because of its innovative projects and strong reputation in the industry.
• Innovative projects that challenge me to grow as a programmer

• Strong reputation in the industry for quality work

• Opportunities for career advancement and professional development
Answered by AI
Add your answer

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

Q1. What is the Java code for reversing a linked list?
Ans. 
Reversing a linked list in Java using iterative approach.
• Create three pointers: prev, current, and next.

• Iterate through the list, updating pointers to reverse the links.

• Return the new head of the reversed list.
Answered by AI
Add your answer
Q2. How do you handle the StaleElementReferenceException in your code?
Ans. 
Handle StaleElementReferenceException by re-locating the element before interacting with it.
• Use try-catch block to catch StaleElementReferenceException

• Re-locate the element using findElement method before interacting with it

• Use WebDriverWait to wait for the element to become stale
Answered by AI
Add your answer

Q1. Can you describe your project experiences?
Ans. 
I have worked on various projects involving test automation, performance testing, and quality assurance processes.
• Developed automated test scripts using Selenium WebDriver for web applications

• Conducted performance testing using JMeter to identify bottlenecks and optimize system performance

• Implemented quality assurance processes to ensure software meets requirements and standards

• Collaborated with cross-functional teams ...read more
Answered by AI
Add your answer
Q2. What is your strategy for designing an automation framework?
Ans. 
My strategy for designing an automation framework involves identifying key functionalities, selecting appropriate tools, creating reusable components, implementing robust error handling, and integrating with CI/CD pipelines.
• Identify key functionalities to be automated based on priority and impact on testing.

• Select appropriate tools and technologies based on the application under test and team expertise.

• Create reusable ...read more
Answered by AI
Add your answer

Q1. What are Agile Values? Scrum Values? Scrum Ceremonies? Story Points?
Ans. 
Agile values include individuals and interactions over processes and tools, while Scrum values include commitment, courage, focus, openness, and respect.
• Agile values prioritize individuals and interactions over processes and tools

• Scrum values include commitment, courage, focus, openness, and respect

• Scrum ceremonies include Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective

• Story points are a unit of...read more
Answered by AI
Add your answer
Q2. As project manager what docs do you prepare? How do you contribute as a PM?
Ans. 
As a project manager, I prepare various documents such as project plans, schedules, budgets, risk assessments, and progress reports. I contribute by leading the team, managing resources, and ensuring project success.
• Prepare project plans outlining scope, objectives, deliverables, and timelines

• Create schedules to allocate tasks and track progress

• Develop budgets to manage project costs effectively

• Conduct risk assessments...read more
Answered by AI
Add your answer
Q3. Capacity? Velocity? etc Agile/Scrum-based questions (bookish) this round was taken by Rajni
Add your answer

Q1. Megha took my final round and asked me questions about Agile/Scrum, Stroy Points (estimation).
Add your answer
Q2. Ques on explaining Sprint Planning, Retro, Review, using Doc/Excel (screen sharing)
Add your answer
Q3. Ques on Conflict and Resource Management, some scenario-based question.
Add your answer
Q4. How will you make a low-performing resource a high-performing one?
Ans. 
Provide clear expectations, offer support and training, provide feedback and recognition, set goals and milestones.
• Clearly communicate expectations and goals to the resource.

• Offer support and training to help the resource improve their skills and knowledge.

• Provide regular feedback and recognition for progress made.

• Set specific goals and milestones to track improvement.

• Create a development plan with the resource to addr...read more
Answered by AI
Add your answer
Q5. Megha did not hire me because she felt I had adequate knowledge and practical experience. (insecurities) Anyway, good luck with your interview.
Add your answer
Q6. What is Scrum of Scrums? What is PI planning?
Ans. 
Scrum of Scrums is a scaled agile framework where multiple Scrum teams coordinate their work. PI planning is a key event in SAFe where teams plan their work for the upcoming Program Increment.
• Scrum of Scrums involves representatives from each Scrum team meeting regularly to discuss dependencies and progress.

• PI planning is a two-day event where teams align on their objectives, dependencies, and priorities for the upcomi...read more
Answered by AI
Add your answer

Aptitude has general maths, English and Finance questions very easy and it was a online aptitude test.

Q1. Derivatives, Types of derivatives
Add your answer
Q2. What is indices
Ans. 
Indices are statistical measures used to track the performance of a specific group of assets or market.
• Indices are used to provide a snapshot of the overall market or a specific sector.

• They are often used as benchmarks for investment performance.

• Examples include the S&P 500, Dow Jones Industrial Average, and NASDAQ Composite.
Answered by AI
Add your answer
Q3. What is capital budgeting
Ans. 
Capital budgeting is the process of planning and managing a firm's long-term investments.
• Involves evaluating potential investments and deciding which ones to pursue

• Considers factors such as cash flows, risks, and returns

• Helps in determining the best allocation of resources for maximum profitability

• Examples include building a new factory, purchasing equipment, or launching a new product
Answered by AI
View 1 more answer
Q4. About financial instruments
Add your answer
Q5. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.

• I am proficient in using statistical software such as R and Python for data analysis.

• I have experience in conducting market research and creating reports to help businesses make informed decisions.
Answered by AI
Add your answer

Pretty standard GD on topics around working remotely and country's macroeconomic

Q1. Derivative Knowledge Check
Add your answer
Q2. Alternate Investment Knowledge Check
Add your answer

Q1. Scenario Based and financial instrument level
Add your answer
Q2. Deep dive into derivative and alternative investment
Ans. 
Derivative and alternative investments involve complex financial instruments and strategies beyond traditional stocks and bonds.
• Derivatives are financial contracts whose value is derived from an underlying asset, index, or rate. Examples include options, futures, and swaps.

• Alternative investments are non-traditional assets such as private equity, hedge funds, real estate, and commodities.

• Both derivative and alternative...read more
Answered by AI
Add your answer

Q1. General HR Question
Add your answer
Q2. Strength and Weakness
Add your answer

Q1. What is a project that you have worked on before?
Ans. 
Developed a web-based inventory management system for a retail company
• Utilized Java for backend development

• Implemented responsive design using HTML, CSS, and JavaScript

• Integrated barcode scanning functionality for efficient inventory tracking
Answered by AI
Add your answer
Q2. What was your role within the team?
Ans. 
I was responsible for providing technical support to end users and troubleshooting application issues within the team.
• Providing technical support to end users

• Troubleshooting application issues

• Collaborating with team members to resolve issues

• Documenting solutions and best practices
Answered by AI
Add your answer
Q3. What SQL-based queries were asked during your interview? like self join , average
Add your answer

Q1. More on Technical area
Add your answer

Q1. More on Technical area
Add your answer

Q1. Technical + Behaviour
Add your answer

Q1. Technical + Behaviour
Add your answer

Q1. Expectation and Genaral
Add your answer