AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Standard Chartered
Compare
Filter interviews by
Standard Chartered Data Engineer Interview Questions and Answers
Standard Chartered Data Engineer Interview Experiences
3 interviews found
Anonymous
Selected
I applied via Referral and was interviewed before Jun 2022. There were 3 interview rounds.
(1 Question)
- Q1. More related towards Hadoop, Spark, scenario based competency questions
(1 Question)
- Q1. Code performance, optimization, batch processing
Selected
I applied via Approached by Company and was interviewed before Oct 2022. There were 3 interview rounds.
(3 Questions)
- Q1. Basic technical questions not much complicated
- Q2. Explain spark architecture
- Ans.
Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.
Consists of a driver program that manages the execution of the Spark application
Utilizes a cluster manager to allocate resources and coordinate tasks across worker nodes
Worker nodes execute the tasks and store data in memory or disk for processing
Supports fault tolerance through resilient distrib...
- Q3. Technical skills on hive Hadoop spark and python
(1 Question)
- Q1. Mostly on salary part
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. What is the probability that you can cut a rope into exactly two halves?
- Ans.
The probability of cutting a rope into exactly two halves is zero.
Cutting a rope into exactly two halves is impossible due to the thickness of the blade or scissors used.
Even if the rope is thin enough to be cut into two halves, the cut will never be perfectly straight.
Therefore, the probability of cutting a rope into exactly two halves is zero.
- Q2. SQL Basics and advanced, python basics. CTE etc.
What people are saying about Standard Chartered
Interview questions from similar companies
Selected
I applied via Referral
Pyspark, Hive, Yarn, Python
(2 Questions)
- Q1. Questions on windowing function
- Q2. Questions on spark arch and python
Interview Preparation Tips
- pyspark
- hive
- python
- yarn
- sql
H M
I was interviewed in Dec 2024.
(1 Question)
- Q1. I was asked to write code and some scenario based question on Big Data etc
2nd with VP which is easy but he seems not okay with my ECTC
Interview Preparation Tips
1). Prepare well on Pyspark, Lakehouse Arch
2).Basic Sql & bit case studies
(2 Questions)
- Q1. Tell me about you experience as a data engineer
- Q2. In depth technical discussion about projects
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Load 60 GB of csv file and perform transformation.
- Ans.
Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.
Use Apache Spark to distribute the workload across multiple nodes for faster processing.
Utilize Spark's DataFrame API to read the CSV file and apply transformations.
Consider partitioning the data to optimize performance.
Use Spark SQL for complex transformations and aggregations.
Leverage in-memory processing capabi
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
(4 Questions)
- Q1. What motivates to you for this job ?
- Q2. What are the risks you have taken in previous role?
- Q3. How do you handle the situation when your opinion differ from your senior members in your team?
- Q4. Provide a approach to develop ETL pipeline where csv file is dropped in S3 and transform through airflow and load to snowflake.
- Ans.
Develop ETL pipeline using Airflow to process CSV files in S3 and load data into Snowflake.
Set up an S3 sensor in Airflow to detect when a new CSV file is dropped in the specified bucket.
Create a custom Python operator in Airflow to read the CSV file from S3, perform necessary transformations, and load data into Snowflake.
Use SnowflakeHook in Airflow to establish connection with Snowflake and execute SQL queries to loa...
Interview Preparation Tips
Skills evaluated in this interview
Discussion of jd, technical questions on spark
(2 Questions)
- Q1. Spark framework
- Q2. Spark dataframes
(2 Questions)
- Q1. Current ctc getting
- Ans.
I am currently earning $80,000 per year.
My current annual salary is $80,000.
I am earning $6,666.67 per month.
I receive a monthly salary of $6,666.67.
- Q2. Expected CTC that is needed
- Ans.
Expected CTC should be based on industry standards, experience, skills, and location.
Research industry standards for Data Engineers in your location
Consider your level of experience and skills
Factor in the cost of living in the area where the job is located
Negotiate based on the value you bring to the company
I applied via LinkedIn and was interviewed in Jan 2024. There were 3 interview rounds.
Spark Sql and Spark Scripting
Data Modelling for retail brand like dmart
ETL Pipeline which handles streaming data as well
Standard Chartered Interview FAQs
Tell us how to improve this page.
Standard Chartered Interviews By Designations
- Standard Chartered Senior Manager Interview Questions
- Standard Chartered Associate Manager Interview Questions
- Standard Chartered Software Developer Interview Questions
- Standard Chartered Relationship Manager Interview Questions
- Standard Chartered Senior Analyst Interview Questions
- Standard Chartered Specialist Interview Questions
- Standard Chartered Team Lead Interview Questions
- Standard Chartered Business Development Manager Interview Questions
- Show more
Standard Chartered Data Engineer Interview Process
based on 2 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Standard Chartered Data Engineer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Team Lead
2.5k
salaries
|  ₹4.1 L/yr - ₹13.3 L/yr |
|
Associate Manager
2.3k
salaries
| ₹5.2 L/yr - ₹20 L/yr |
|
Senior Officer
2.3k
salaries
| ₹1.8 L/yr - ₹7.3 L/yr |
|
Manager
2k
salaries
| ₹7 L/yr - ₹29 L/yr |
|
Senior Analyst
1.9k
salaries
| ₹2 L/yr - ₹9 L/yr |
HSBC Bank
ICICI Bank
HDFC Bank
Axis Bank
- Home >
- Interviews >
- Standard Chartered Interview Questions >
- Standard Chartered Data Engineer Interview Questions
