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
3.9

based on 2.3k Reviews

Filter interviews by

Societe Generale Global Solution Centre Data Engineer Interview Questions and Answers

Updated 19 Nov 2024

Societe Generale Global Solution Centre Data Engineer Interview Experiences

3 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 19 Nov 2024

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 May 2024. There was 1 interview round.

Round 1 - Coding Test 

1. Questions on spark basica
2. Sql coding questions
3. Java or scala basics

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 29 May 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

Interview asked good question 2 python question , 3 sql question, many pyspark question and lot about project

Interview Preparation Tips

Topics to prepare for Societe Generale Global Solution Centre Data Engineer interview:
  • Python
  • SQL
  • pyspark
  • Project

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in Sigmoid
Q5. K-th Element of Two Sorted Arrays You are provided with two sorte ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 20 Sep 2023

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Sep 2022. There were 4 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 - Coding Test 

They give the set of questions to solve

Round 3 - Technical 

(4 Questions)

  • Q1. Specific to your technology
  • Q2. Data ware house concepts
  • Q3. Coding in sql joins
  • Ans. 

    SQL joins are used to combine rows from two or more tables based on a related column between them.

    • Use INNER JOIN to return rows when there is at least one match in both tables

    • Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

    • Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

    • Use FULL JOIN to return rows when there is a match in one

  • Answered by AI
  • Q4. Functions/ Procedures /data ware house schema
Round 4 - Technical 

(1 Question)

  • Q1. Intense level of coding and project details

Interview Preparation Tips

Interview preparation tips for other job seekers - be prepared fully this is the best company and you should not miss that chance

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 Dec 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Scenario based questions on Azure data factory and pipelines
  • Q2. Optimisation technic to improve the performance of databricks
  • Q3. What is Autoloader
  • Q4. What is unity catalog
  • Q5. How you do the alerting mechanism in adf for failed pipelines
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
No response
Round 1 - Technical 

(4 Questions)

  • Q1. What is the architecture of Apache Spark?
  • Ans. 

    Apache Spark architecture includes a cluster manager, worker nodes, and driver program.

    • Apache Spark architecture consists of a cluster manager, which allocates resources and schedules tasks.

    • Worker nodes execute tasks and store data in memory or disk.

    • Driver program coordinates tasks and communicates with the cluster manager.

    • Spark applications run as independent sets of processes on a cluster, coordinated by the SparkCon...

  • Answered by AI
  • Q2. What is the difference between the reduceBy and groupBy transformations in Apache Spark?
  • Ans. 

    reduceBy is used to aggregate data based on key, while groupBy is used to group data based on key.

    • reduceBy is a transformation that combines the values of each key using an associative function and a neutral 'zero value'.

    • groupBy is a transformation that groups the data based on a key and returns a grouped data set.

    • reduceBy is more efficient for aggregating data as it reduces the data before shuffling, while groupBy shu...

  • Answered by AI
  • Q3. What is the difference between RDD (Resilient Distributed Datasets) and DataFrame in Apache Spark?
  • Ans. 

    RDD is a low-level abstraction representing a distributed collection of objects, while DataFrame is a higher-level abstraction representing a distributed collection of data organized into named columns.

    • RDD is more suitable for unstructured data and low-level transformations, while DataFrame is more suitable for structured data and high-level abstractions.

    • DataFrames provide optimizations like query optimization and code...

  • Answered by AI
  • Q4. What are the different modes of execution in Apache Spark?
  • Ans. 

    The different modes of execution in Apache Spark include local mode, standalone mode, YARN mode, and Mesos mode.

    • Local mode: Spark runs on a single machine with one executor.

    • Standalone mode: Spark runs on a cluster managed by a standalone cluster manager.

    • YARN mode: Spark runs on a Hadoop cluster using YARN as the resource manager.

    • Mesos mode: Spark runs on a Mesos cluster with Mesos as the resource manager.

  • Answered by AI

Data Engineer Interview Questions & Answers

Genpact user image Sashikanta Parida

posted on 17 Dec 2024

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

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. What are different type of joins available in Databricks?
  • Ans. 

    Different types of joins available in Databricks include inner join, outer join, left join, right join, and cross join.

    • Inner join: Returns only the rows that have matching values in both tables.

    • Outer join: Returns all rows when there is a match in either table.

    • Left join: Returns all rows from the left table and the matched rows from the right table.

    • Right join: Returns all rows from the right table and the matched rows ...

  • Answered by AI
  • Q2. How do you make your data pipeline fault tolerant?
  • Ans. 

    Implementing fault tolerance in a data pipeline involves redundancy, monitoring, and error handling.

    • Use redundant components to ensure continuous data flow

    • Implement monitoring tools to detect failures and bottlenecks

    • Set up automated alerts for immediate response to issues

    • Design error handling mechanisms to gracefully handle failures

    • Use checkpoints and retries to ensure data integrity

  • Answered by AI
  • Q3. What is AutoLoader?
  • Ans. 

    AutoLoader is a feature in data engineering that automatically loads data from various sources into a data warehouse or database.

    • Automates the process of loading data from different sources

    • Reduces manual effort and human error

    • Can be scheduled to run at specific intervals

    • Examples: Apache Nifi, AWS Glue

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. How do you connect to different services in Azure?
  • Ans. 

    To connect to different services in Azure, you can use Azure SDKs, REST APIs, Azure Portal, Azure CLI, and Azure PowerShell.

    • Use Azure SDKs for programming languages like Python, Java, C#, etc.

    • Utilize REST APIs to interact with Azure services programmatically.

    • Access and manage services through the Azure Portal.

    • Leverage Azure CLI for command-line interface interactions.

    • Automate tasks using Azure PowerShell scripts.

  • Answered by AI
  • Q2. What are linked Services?
  • Ans. 

    Linked Services are connections to external data sources or destinations in Azure Data Factory.

    • Linked Services define the connection information needed to connect to external data sources or destinations.

    • They can be used in Data Factory pipelines to read from or write to external systems.

    • Examples of Linked Services include Azure Blob Storage, Azure SQL Database, and Amazon S3.

  • Answered by AI

Data Engineer Interview Questions & Answers

Wipro user image Lakshmi Narayana

posted on 27 Nov 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Explain adf questions in detail
  • Ans. 

    ADF questions refer to Azure Data Factory questions which are related to data integration and data transformation processes.

    • ADF questions are related to Azure Data Factory, a cloud-based data integration service.

    • These questions may involve data pipelines, data flows, activities, triggers, and data movement.

    • Candidates may be asked about their experience with designing, monitoring, and managing data pipelines in ADF.

    • Exam...

  • Answered by AI
  • Q2. Project related questions
Round 2 - Technical 

(2 Questions)

  • Q1. Project data related questions
  • Q2. Databricks and SQL interview questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. What are the optimization techniques used in Apache Spark?
  • Q2. 2 SQL queries , 1 PySpark code and 1 Python Code .
  • Q3. 2-3 Scenario Based questions from ADF and databricks .
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. How to Ensure Data loss in ETL pipeline
  • Q2. Why to spin up Dataproc cluster when there is serverless batch job exists.

Data Engineer Interview Questions & Answers

Cognizant user image Abhishek Paithankar

posted on 16 Nov 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude test involved with quantative aptitude, logical reasoning and reading comprehensions.

Round 2 - Technical 

(2 Questions)

  • Q1. Tell me your introduction.
  • Q2. Tell me about your skills.
  • Ans. 

    I have strong skills in data processing, ETL, data modeling, and programming languages like Python and SQL.

    • Proficient in data processing and ETL techniques

    • Strong knowledge of data modeling and database design

    • Experience with programming languages like Python and SQL

    • Familiarity with big data technologies such as Hadoop and Spark

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Are you ready relocate,?
  • Ans. 

    Yes, I am open to relocating for the right opportunity.

    • I am willing to relocate for the right job opportunity.

    • I have experience moving for previous roles.

    • I am flexible and adaptable to new locations.

    • I am excited about the possibility of exploring a new city or country.

  • Answered by AI
  • Q2. Document verification

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are fresher first prepare for aptitude, because once aptitude get cleared you will get selected from the large compitition and then focus on your technical knowledge and managerial skills about the company.

Societe Generale Global Solution Centre Interview FAQs

How many rounds are there in Societe Generale Global Solution Centre Data Engineer interview?
Societe Generale Global Solution Centre interview process usually has 2 rounds. The most common rounds in the Societe Generale Global Solution Centre interview process are Coding Test, Technical and Resume Shortlist.
How to prepare for Societe Generale Global Solution Centre Data Engineer 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 Hadoop, SCALA, Hive, Spark and Big Data.
What are the top questions asked in Societe Generale Global Solution Centre Data Engineer interview?

Some of the top questions asked at the Societe Generale Global Solution Centre Data Engineer interview -

  1. coding in sql jo...read more
  2. functions/ Procedures /data ware house sch...read more
  3. intense level of coding and project deta...read more

Tell us how to improve this page.

Societe Generale Global Solution Centre Data Engineer Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
Join Societe Generale Global Solution Centre Building together, a Better & Sustainable future.
Societe Generale Global Solution Centre Data Engineer Salary
based on 65 salaries
₹6 L/yr - ₹26 L/yr
43% more than the average Data Engineer Salary in India
View more details

Societe Generale Global Solution Centre Data Engineer Reviews and Ratings

based on 8 reviews

4.1/5

Rating in categories

3.8

Skill development

4.6

Work-life balance

3.6

Salary

4.4

Job security

3.6

Company culture

3.1

Promotions

3.9

Work satisfaction

Explore 8 Reviews and Ratings
Senior Analyst
1.8k salaries
unlock blur

₹4.5 L/yr - ₹15 L/yr

Software Engineering Specialist
1.7k salaries
unlock blur

₹9 L/yr - ₹33 L/yr

Analyst
1.5k salaries
unlock blur

₹2.8 L/yr - ₹10.5 L/yr

Software Engineer
1.4k salaries
unlock blur

₹5 L/yr - ₹19.4 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.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview