Premium Employer

i

This company page is being actively managed by Societe Generale Global Solution Centre Team. If you also belong to the team, you can get access from here

Filter interviews by

Societe Generale Global Solution Centre Production Support Analyst Interview Questions and Answers

Updated 15 May 2023

Societe Generale Global Solution Centre Production Support Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Group Discussion 

24/7 production environment

Round 3 - Technical 

(4 Questions)

  • Q1. What is the difference between PL SQL AND SQL?
  • Ans. 

    PL/SQL is a procedural language extension to SQL used for writing complex queries and programs.

    • SQL is used for querying and manipulating data in a database

    • PL/SQL is used for writing complex queries and programs

    • PL/SQL is a procedural language that extends SQL with programming constructs like loops and conditional statements

    • PL/SQL is used to create stored procedures, functions, and triggers in Oracle databases

  • Answered by AI
  • Q2. About programming
  • Q3. Write a query using below data to find out last string from emp table?
  • Ans. 

    Query to find last string from emp table

    • Use the ORDER BY clause with DESC keyword to sort the table in descending order

    • Use the LIMIT keyword to limit the result to 1 row

    • Assuming the last string refers to the last row in the table

  • Answered by AI
  • Q4. Write s query to find maximum salary from EMP?
  • Ans. 

    Query to find maximum salary from EMP

    • Use the MAX() function to find the maximum salary

    • Specify the column name for salary in the SELECT statement

    • Specify the table name and column name for salary in the FROM clause

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(5 Questions)

  • Q1. What is internal working of hashmap
  • Ans. 

    HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.

    • HashMap internally uses an array of linked lists to store key-value pairs.

    • When a key-value pair is added, the key is hashed to determine the index in the array where the pair will be stored.

    • If multiple key-value pairs hash to the same index, they are stored in a linked list at that index.

    • To retrieve a value...

  • Answered by AI
  • Q2. What is difference between hashmap and concurrent hashmap
  • Ans. 

    HashMap is not thread-safe while ConcurrentHashMap is thread-safe.

    • HashMap is not thread-safe and can lead to ConcurrentModificationException if modified while iterating.

    • ConcurrentHashMap allows concurrent modifications without the need for external synchronization.

    • ConcurrentHashMap achieves thread-safety by dividing the map into segments, allowing multiple threads to operate on different segments concurrently.

    • Concurren...

  • Answered by AI
  • Q3. Can we override main method in java
  • Ans. 

    No, main method in Java cannot be overridden.

    • Main method is a static method of a class and cannot be overridden.

    • Subclasses can have their own main method, but it will not be considered as the entry point of the program.

    • Example: public class SubClass extends MainClass { public static void main(String[] args) { // This is not the entry point of the program }}

  • Answered by AI
  • Q4. Write the command to find the hidden files in unix
  • Ans. 

    Use the 'ls' command with the '-a' flag to find hidden files in Unix.

    • Use the command 'ls -a' to list all files, including hidden files.

    • Hidden files in Unix start with a dot (.) before the file name.

    • Example: 'ls -a' will display all files, including hidden files.

  • Answered by AI
  • Q5. Write a command to replace a string in unix
  • Ans. 

    Use the sed command to replace a string in Unix

    • Use the following syntax: sed 's/original_string/new_string/g' filename

    • The 's' flag stands for substitute, 'g' flag stands for global (replace all occurrences)

    • Example: sed 's/hello/goodbye/g' file.txt

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - For java production support please brush up Unix SQL and unix

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • 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
  • 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
  • Q3. What SQL-based queries were asked during your interview? like self join , average
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com

Round 1 - Aptitude Test 

It is a computer base test and we have numerical, verbal and logical reasoning question will be their

Round 2 - Group Discussion 

Discussion between a group of participants on a given topic

Round 3 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Why should we hire you
Round 4 - Technical 

(2 Questions)

  • Q1. What programming languages are know by me
  • Q2. Asking question on our familiar programming language

Interview Preparation Tips

Topics to prepare for Accenture Application Support Engineer interview:
  • Python
Interview preparation tips for other job seekers - offer letter
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

1 hour, wage question, not related to mention technology.

Round 2 - Technical 

(2 Questions)

  • Q1. Oops related queries
  • Q2. Discussion around last project

Interview Preparation Tips

Interview preparation tips for other job seekers - Try in some better organization
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Do you know about sed command?
  • Ans. 

    sed command is a stream editor used to perform text transformations on an input stream or file.

    • sed stands for stream editor

    • It is used to perform text transformations on an input stream or file

    • Commonly used for search and replace operations

    • Syntax: sed 's/search/replace/g' filename

    • Example: sed 's/foo/bar/g' file.txt

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected

I applied via Walk-in

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(4 Questions)

  • Q1. Self introduction
  • Q2. Work experience
  • Q3. Which department are u working
  • Q4. Timings and salary
Round 3 - One-on-one 

(3 Questions)

  • Q1. Name and experience and quality and checking etc
  • Q2. How can handle ur problem and team work
  • Q3. Times and salary
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is your current role in organization
  • Q2. What is your salary expeactation

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident with wahatever mentioned in CV.
Round 1 - Technical 

(6 Questions)

  • Q1. How will you handle team conflicts
  • Ans. 

    I will handle team conflicts by promoting open communication, facilitating discussions, and finding mutually agreeable solutions.

    • Encourage open communication among team members

    • Facilitate discussions to understand the root cause of conflicts

    • Promote active listening and empathy

    • Mediate conflicts and find mutually agreeable solutions

    • Implement team-building activities to improve collaboration

  • Answered by AI
  • Q2. If any data loss issue, how will you approach to different teams and the your team
  • Ans. 

    I would approach the issue by communicating with all relevant teams and creating a plan to recover the lost data.

    • Identify the cause of the data loss

    • Notify all relevant teams and stakeholders

    • Create a plan to recover the lost data

    • Implement the plan and monitor progress

    • Communicate updates to all stakeholders

  • Answered by AI
  • Q3. What was your responsibilities in your earlier role.
  • Ans. 

    As a Production Support Manager, my responsibilities included overseeing the support and maintenance of production systems, managing a team of support analysts, coordinating with stakeholders, and ensuring timely resolution of issues.

    • Managed a team of support analysts and provided guidance and support

    • Oversaw the support and maintenance of production systems

    • Coordinated with stakeholders to understand their requirements ...

  • Answered by AI
  • Q4. Are you flexible for working hours
  • Ans. 

    Yes, I am flexible for working hours.

    • I am willing to work evenings, weekends, and holidays if required.

    • I understand the importance of being available during critical production issues.

    • I am open to adjusting my schedule to accommodate team needs.

    • I have experience working in shifts and adapting to changing work hours.

    • I prioritize the success of the team and the smooth operation of production systems.

  • Answered by AI
  • Q5. How soon will you join or immediate
  • Ans. 

    I can join immediately.

    • I am available to start immediately.

    • I can join as soon as required.

    • I am ready to start right away.

  • Answered by AI
  • Q6. What major issues you handle and how
  • Ans. 

    As a Production Support Manager, I handle major issues by identifying root causes, coordinating with teams, and implementing effective solutions.

    • Identify root causes of major issues

    • Coordinate with teams to resolve issues

    • Implement effective solutions to prevent future occurrences

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Give honest and positive answers only. Be with the flow of questions not to divert the focus of interview.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jan 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Virtual interview 

(6 Questions)

  • Q1. What is a role of support engineer
  • Ans. 

    A support engineer is responsible for providing technical assistance and resolving issues related to software or hardware systems.

    • Providing technical support to customers or end-users

    • Troubleshooting and resolving software or hardware issues

    • Installing, configuring, and maintaining systems

    • Monitoring system performance and identifying potential problems

    • Collaborating with development teams to address bugs or enhancements

    • Do...

  • Answered by AI
  • Q2. What is ticketing tool
  • Ans. 

    A ticketing tool is a software application used to track and manage customer support requests or issues.

    • Ticketing tools help in organizing and prioritizing customer support tickets.

    • They provide a centralized platform for communication and collaboration between support teams and customers.

    • Ticketing tools often include features like ticket assignment, status tracking, and reporting.

    • Examples of popular ticketing tools inc

  • Answered by AI
  • Q3. What is monitoring tool
  • Ans. 

    A monitoring tool is a software application or system that collects and analyzes data to track the performance and health of a system or application.

    • Monitoring tools collect data from various sources such as servers, networks, databases, and applications.

    • They provide real-time visibility into the system's performance, availability, and resource utilization.

    • Monitoring tools can generate alerts or notifications when pred...

  • Answered by AI
  • Q4. What are SQL comments
  • Ans. 

    SQL comments are used to add explanatory notes or remarks within SQL code.

    • SQL comments start with a double hyphen (--), or can be enclosed between /* and */

    • Comments are ignored by the SQL engine and are not executed as part of the code

    • Comments can be used to improve code readability and provide documentation

    • Comments can be used to disable or temporarily remove parts of the code for testing or debugging purposes

  • Answered by AI
  • Q5. What doing in the SQL
  • Q6. What is DML full form
  • Ans. 

    DML stands for Data Manipulation Language.

    • DML is a subset of SQL (Structured Query Language) used to manipulate data in a database.

    • It includes commands like INSERT, UPDATE, DELETE, and SELECT.

    • DML statements are used to add, modify, or delete data in database tables.

    • For example, INSERT statement is used to add new records, UPDATE statement is used to modify existing records, DELETE statement is used to remove records, a...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for IBM Production Support Engineer interview:
  • PLSQL
  • SQL
  • Oricale
  • Selcripting
Interview preparation tips for other job seekers - I am working very hard to a company I was interested in companys

Skills evaluated in this interview

Societe Generale Global Solution Centre Interview FAQs

How many rounds are there in Societe Generale Global Solution Centre Production Support Analyst interview?
Societe Generale Global Solution Centre interview process usually has 3 rounds. The most common rounds in the Societe Generale Global Solution Centre interview process are Resume Shortlist, Group Discussion and Technical.
How to prepare for Societe Generale Global Solution Centre Production Support Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Societe Generale Global Solution Centre. The most common topics and skills that interviewers at Societe Generale Global Solution Centre expect are Contra, DQ, Fortran, Program Management and Selenium RC.
What are the top questions asked in Societe Generale Global Solution Centre Production Support Analyst interview?

Some of the top questions asked at the Societe Generale Global Solution Centre Production Support Analyst interview -

  1. Write a query using below data to find out last string from emp tab...read more
  2. What is the difference between PL SQL AND S...read more
  3. Write s query to find maximum salary from E...read more

Tell us how to improve this page.

Societe Generale Global Solution Centre Production Support Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Join Societe Generale Global Solution Centre Building together, a Better & Sustainable future.

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.2k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
DXC Technology Interview Questions
3.7
 • 809 Interviews
Nagarro Interview Questions
4.0
 • 778 Interviews
Publicis Sapient Interview Questions
3.5
 • 611 Interviews
View all
95% more than the average Production Support Analyst Salary in India
View more details

Societe Generale Global Solution Centre Production Support Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

3.0

Salary

4.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Senior Analyst
1.8k salaries
unlock blur

₹4.7 L/yr - ₹15 L/yr

Software Engineering Specialist
1.7k salaries
unlock blur

₹8.9 L/yr - ₹33 L/yr

Analyst
1.6k salaries
unlock blur

₹2.8 L/yr - ₹11 L/yr

Software Engineer
1.4k salaries
unlock blur

₹5 L/yr - ₹19.6 L/yr

Business Analyst
1.1k salaries
unlock blur

₹6 L/yr - ₹26 L/yr

Explore more salaries
Compare Societe Generale Global Solution Centre with

BNP Paribas

3.8
Compare

Crédit Agricole

3.5
Compare

HSBC Group

4.0
Compare

Barclays

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview