AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Banco Bilbao Vizcaya Data Engineer Interview Questions, Process, and Tips
Banco Bilbao Vizcaya Data Engineer Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. Tell me about your experience?
(4 Questions)
- Q1. What is a funcional programming?
- Ans.
Functional programming is a programming paradigm that treats computation as the evaluation of mathematical functions and avoids changing state and mutable data.
Focuses on the evaluation of functions
Avoids changing state and mutable data
Emphasizes immutability and pure functions
Supports higher-order functions and recursion
Examples: Haskell, Scala, Clojure
- Q2. Explain to me the 3 major pillar of oop
- Ans.
The 3 major pillars of OOP are encapsulation, inheritance, and polymorphism.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Class in Java.
Inheritance: Ability of a class to inherit properties and behavior from another class. Example: Subclass extending a superclass.
Polymorphism: Ability to present the same interface for different data types. Example: Method overloading in
- Q3. What is Apache spark?
- Ans.
Apache Spark is a fast and general-purpose cluster computing system for big data processing.
Apache Spark is designed for speed and ease of use in processing large datasets.
It provides APIs in Java, Scala, Python, and R for building parallel applications.
Spark can run on Hadoop, standalone, or in the cloud, and includes libraries for SQL, streaming, machine learning, and graph processing.
It uses in-memory computing to i...
- Q4. What is a cross join in sql?
- Ans.
A cross join in SQL is a join operation that produces the Cartesian product of two tables.
It combines each row from the first table with every row from the second table.
It does not require any matching condition like other types of joins.
It can result in a large number of rows if the tables being joined have many rows.
Skills evaluated in this interview
Top trending discussions
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 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
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
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
Ronak C Desai
Selected
I applied via Referral and was interviewed before Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Questions on pyspark coding, windowing function and all
- Q2. Questions on hive and yarn
Interview Preparation Tips
- pyspark
- hive
- sql
- yarn
(2 Questions)
- Q1. What are joins of sql
- Q2. Explain about self join
I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Questions on Data Modelling
- Q2. Questions on SQL and Data Warehousing
(2 Questions)
- Q1. SQL query writing involving complex queries
- Q2. Questions on Snowflake and other distributed systems
Interview Preparation Tips
- SQL
- Snowflake
- Python
- Data modell
Banco Bilbao Vizcaya Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Banco Bilbao Vizcaya Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
HDFC Bank
ICICI Bank
Axis Bank
Kotak Mahindra Bank
- Home >
- Interviews >
- Banco Bilbao Vizcaya Interview Questions >
- Banco Bilbao Vizcaya Data Engineer Interview Questions
