Societe Generale Global Solution Centre Interview Questions, Process, and Tips

String manipulation questions easy not that much hard

Q1. String manipulation
Add your answer
Q2. Reverse a string according to it's input
Ans. 
Reverse a string based on input
• Use a loop to iterate through the characters of the input string

• Append each character to the beginning of a new string to reverse it

• Return the reversed string as the output
Answered by AI
Add your answer

Consisted of 3 coding questions and an aptitude test (Quantitative + English + Basic CS Questions)

Q1. Explain ACID properties
Ans. 
ACID properties are a set of properties that guarantee reliability and consistency in database transactions.
• Atomicity: All operations in a transaction are either completed successfully or not at all.

• Consistency: Data is always in a valid state before and after a transaction.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once a transaction is committed, its changes are permanen
Answered by AI
Add your answer
Q2. Explain Normalisation in DBMS
Ans. 
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a database into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured manner.

• Normalization ensures data integrity by minimizing data anomalies.

• There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.

• Example: In a ...read more
Answered by AI
Add your answer

Q1. How will you deal with a hostile co-worker
Ans. 
I would address the issue directly with the co-worker and involve a mediator if necessary.
• Address the issue directly with the co-worker in a calm and professional manner.

• Seek to understand the root cause of their hostility and try to find common ground.

• Involve a mediator or HR if the situation escalates and becomes unmanageable.
Answered by AI
Add your answer

Q1. Can you describe your project management skills?
Ans. 
I have strong project management skills with experience in leading cross-functional teams and delivering projects on time and within budget.
• Experience in creating project plans and timelines

• Ability to effectively communicate with stakeholders and team members

• Skilled in risk management and problem-solving

• Proficient in using project management tools such as Asana and Jira
Answered by AI
Add your answer
Q2. Tell ur experience and PMP frameworks
Ans. 
I have 5 years of experience managing projects using PMP frameworks.
• Led cross-functional teams to successfully deliver projects on time and within budget

• Implemented PMP methodologies such as risk management and stakeholder communication

• Utilized tools like Gantt charts and critical path analysis to track project progress

• Obtained PMP certification to enhance project management skills
Answered by AI
Add your answer

Q1. Technical Experience
Add your answer
Q2. Challenged faced
Add your answer
Q3. Solutions provided
Add your answer
Q4. Toughest Project Handled
Ans. 
Developing a real-time monitoring system for a large-scale financial trading platform
• Implemented complex algorithms to analyze market data in real-time

• Designed a scalable architecture to handle high volume of transactions

• Worked closely with traders and analysts to understand requirements and make necessary adjustments

• Managed a team of developers to ensure project milestones were met
Answered by AI
Add your answer
Q5. Other Technical languages
Add your answer

It was an online assessment containing 3 DSA questions

Q1. Medium level array questions
Add your answer
Q2. Medium level DP questions
Add your answer

Q1. General behavioural question about
Add your answer

Q1. About yourself and your work
Add your answer
Q2. From resume questions were asked
Add your answer

Q1. Remove duplicates in an array
Ans. 
Use a hash set to remove duplicates in an array of strings
• Create a hash set to store unique elements

• Iterate through the array and add each element to the hash set

• Convert the hash set back to an array to get the unique elements
Answered by AI
Add your answer
Q2. What is react virtual DOM
Ans. 
React virtual DOM is a lightweight copy of the actual DOM, used for efficient updates and rendering in React applications.
• Virtual DOM is a concept where a lightweight copy of the actual DOM is created in memory.

• React uses virtual DOM to efficiently update and render components without directly manipulating the actual DOM.

• When changes are made to the virtual DOM, React calculates the most efficient way to update the act...read more
Answered by AI
Add your answer
Q3. React hooks with example
Ans. 
React hooks are functions that let you use state and other React features without writing a class.
• React hooks were introduced in React 16.8 to allow functional components to have state and lifecycle methods.

• useState() is a hook that allows you to add state to functional components.

• useEffect() is a hook that allows you to perform side effects in functional components.

• useContext() is a hook that allows you to use the con...read more
Answered by AI
Add your answer