GlobalLogic Senior Data Engineer Interview Questions and Answers

Q1. Adf,etl,python,adb
Add your answer

Q1. More questions on spark and java
Add your answer
Q2. More questions on sql
Add your answer

Q1. Over all project architecture
Add your answer
Q2. Sample data and its transformations
Ans. 
Sample data and its transformations
• Sample data can be in the form of CSV, JSON, or database tables

• Transformations include cleaning, filtering, aggregating, and joining data

• Examples: converting date formats, removing duplicates, calculating averages
Answered by AI
Add your answer

Q1. Why are u leaving current job
Ans. 
Seeking new challenges and opportunities for growth in a more dynamic environment.
• Looking for new challenges and opportunities for growth

• Seeking a more dynamic work environment

• Interested in expanding skill set and knowledge

• Want to work on more innovative projects
Answered by AI
Add your answer

Q1. What is scd type 2?
Ans. 
SCD type 2 is a method used in data warehousing to track historical changes by creating a new record for each change.
• SCD type 2 stands for Slowly Changing Dimension type 2

• It involves creating a new record in the dimension table whenever there is a change in the data

• The old record is marked as inactive and the new record is marked as current

• It allows for historical tracking of changes in data over time

• Example: If a cust...read more
Answered by AI
Add your answer
Q2. Pyspark question read CSV from folder and add column in each csv file and write it to different location.
Add your answer

Q1. Explain about yourself.
Ans. 
I am a Senior Data Engineer with 5+ years of experience in designing and implementing data pipelines for large-scale projects.
• Experienced in ETL processes and data warehousing

• Proficient in programming languages like Python, SQL, and Java

• Skilled in working with big data technologies such as Hadoop, Spark, and Kafka

• Strong understanding of data modeling and database management

• Excellent problem-solving and communication sk
Answered by AI
Add your answer
Q2. Explain about your current project.
Ans. 
Developing a real-time data processing system for analyzing customer behavior on e-commerce platform.
• Utilizing Apache Kafka for real-time data streaming

• Implementing Spark for data processing and analysis

• Creating machine learning models for customer segmentation

• Integrating with Elasticsearch for data indexing and search functionality
Answered by AI
Add your answer
Q3. Big data concept
Add your answer
Q4. Spark related questions
Add your answer

One question on pysaprk

Q1. Solve the query for the dataset
Add your answer
Q2. Solve it without using spark-sql
Add your answer

Q1. Tell about experience
Ans. 
I have over 5 years of experience in data engineering, working with large datasets and implementing data pipelines.
• Developed and maintained ETL processes to extract, transform, and load data from various sources

• Optimized database performance and implemented data quality checks

• Worked with cross-functional teams to design and implement data solutions

• Utilized tools such as Apache Spark, Hadoop, and SQL for data processing

• ...read more
Answered by AI
Add your answer
Q2. What would you do when you are given a new task to do
Ans. 
I would start by understanding the requirements, breaking down the task into smaller steps, researching if needed, and then creating a plan to execute the task efficiently.
• Understand the requirements of the task

• Break down the task into smaller steps

• Research if needed to gather necessary information

• Create a plan to execute the task efficiently

• Communicate with stakeholders for clarification or updates

• Regularly track prog
Answered by AI
Add your answer