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

It was actually easy.

Q1. It was mostly SQL questions.
Add your answer

Q1. This round was more of a personal level and to check the confidence of the candidate.
Add your answer

About current project and roles and resposibilities etc

Q1. SQL COMPLEX QUERIES and PL SQL, CRON JOBS, SERVICE NOW
Add your answer
Q2. What are difference between SQL and PL SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is a procedural language extension for SQL.
• SQL is a standard language for querying and manipulating data in relational databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex programming logic.

• SQL is used for data manipulation and retrieval, while PL/SQL is used for writing stored procedures and functions.

• SQL state...read more
Answered by AI
Add your answer
Q3. Explain types of joins?
Ans. 
Types of joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join...read more
Answered by AI
Add your answer
Q4. Diffence between correlated and non correlated subquary?
Ans. 
Correlated subquery refers to a subquery that is dependent on the outer query, while non-correlated subquery can be executed independently.
• Correlated subquery is executed for each row processed by the outer query, while non-correlated subquery is executed only once.

• Correlated subquery is slower in performance compared to non-correlated subquery.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM tab
Answered by AI
Add your answer
Q5. Find departement wise total sal?
Ans. 
To find department wise total salary, sum up the salaries of employees in each department.
• Group employees by department

• Calculate total salary for each department

• Display department wise total salary
Answered by AI
Add your answer

Q1. Business knowledge
Add your answer
Q2. Domain knowledge
Add your answer

Q1. Basics topics will be discussed
Add your answer

Q1. General discussion on Accounting and finance
Add your answer

Q1. In depth knowledge check on derivative products
Add your answer
Q2. Swaps, kinds of swaps, journal postings for bond purchased on discounts.
Add your answer

1. Basic Java
2. Code Snippet
3. Microservices

It wa easy , there were 20 mcq and 2 coding question .

Q1. In the first round of interview it was all techical based question . Topics like OOPs , Data structures were covered.
Add your answer

Q1. This round was a technical+managerial round. I was given senarious ans situations and asked for solutions for them.
Add your answer

Q1. This was the last round , and was purely HR based.
Add your answer