Jet2 Travel Technologies Senior Data Engineer Interview Questions and Answers

Q1. How does spark run in the background?
Ans. 
Spark runs in the background using a cluster manager to allocate resources and schedule tasks.
• Spark uses a cluster manager (such as YARN, Mesos, or Kubernetes) to allocate resources and schedule tasks.

• Tasks are executed by worker nodes in the cluster, which communicate with the driver program.

• The driver program coordinates the execution of tasks and manages the overall workflow.

• Spark's DAG scheduler breaks the job into...read more
Answered by AI
Add your answer

Q1. Write a python program to find the most occurred number in sequence
Ans. 
Python program to find the most occurred number in a sequence
• Iterate through the sequence and count the occurrences of each number using a dictionary

• Find the number with the highest count in the dictionary

• Handle edge cases like empty sequence or multiple numbers with the same highest count
Answered by AI
Add your answer

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

Q1. Bias variance trade off
Add your answer
Q2. What is AB testing
Ans. 
AB testing is a method used to compare two versions of a webpage or app to determine which one performs better.
• AB testing involves creating two versions (A and B) of a webpage or app with one differing element

• Users are randomly assigned to either version A or B to measure performance metrics

• The version that performs better in terms of the desired outcome is selected for implementation

• Example: Testing two different call...read more
Answered by AI
Add your answer
Q3. Basic traditional ML question about ML metrics, bagging boosting etc.
Add your answer

It was a classification problem

Q1. Questions about assignment
Add your answer
Q2. Questions from resume.
Add your answer
Q3. Questions based on probability, statistics and loss functions
Add your answer

Q1. Basic to medium questions related to DotNet Core MVC, SQL Server, etc
Add your answer

Q1. Completely unprofessional behavior of the interviewer. - No Introduction Direct start asking questions. - Asking too many misleading questions (First ask what you worked on, then ask did you heard about th...read more
Add your answer

Sql assessment round

Q1. Python gcp biquery airflow dataflow sql
Add your answer

Q1. Recent projects experience, bigquery, sql
Add your answer

Q1. Salary discussion
Add your answer

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Add your answer

Q1. HR question and family background
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer