Axtria Senior Data Engineer Interview Questions and Answers

Q1. NLP based question
Add your answer

Q1. Components of Databricks
Ans. 
Databricks is a unified data analytics platform that includes components like Databricks Workspace, Databricks Runtime, and Databricks Delta.
• Databricks Workspace: Collaborative environment for data science and engineering teams.

• Databricks Runtime: Optimized Apache Spark cluster for data processing.

• Databricks Delta: Unified data management system for data lakes.
Answered by AI
Add your answer
Q2. How to read a json file
Ans. 
To read a JSON file, use a programming language's built-in functions or libraries to parse the file and extract the data.
• Use a programming language like Python, Java, or JavaScript to read the JSON file.

• Import libraries like json in Python or json-simple in Java to parse the JSON data.

• Use functions like json.load() in Python to load the JSON file and convert it into a dictionary or object.

• Access the data in the JSON fi...read more
Answered by AI
Add your answer
Q3. Second highest salary SQL
Ans. 
To find the second highest salary in SQL, use the MAX function with a subquery or the LIMIT clause.
• Use the MAX function with a subquery to find the highest salary first, then use a WHERE clause to exclude it and find the second highest salary.

• Alternatively, use the LIMIT clause to select the second highest salary directly.

• Make sure to handle cases where there may be ties for the highest salary.
Answered by AI
Add your answer
Q4. How to configure the spark while creating the cluster
Ans. 
Spark cluster configuration involves setting up memory, cores, and other parameters for optimal performance.
• Specify the number of executors and executor memory

• Set the number of cores per executor

• Adjust the driver memory based on the application requirements

• Configure shuffle partitions for efficient data processing

• Enable dynamic allocation for better resource utilization
Answered by AI
Add your answer

Q1. Spark and airflow related questions
Add your answer
Q2. AWS services and it's related questions
Add your answer

A general round having mix of maths,aptitude,english,puzzle and quiz. level was easy

Q1. Tell about yourself
Add your answer
Q2. What step would you take in this situatiion
Ans. 
I would analyze the situation, identify the root cause, and propose a solution based on data-driven insights.
• Analyze the data to understand the problem

• Identify the root cause of the issue

• Propose a solution based on data-driven insights
Answered by AI
Add your answer

Basic sql online assessment with some queries and mcq

Q1. Explain project
Ans. 
Developed a data pipeline to ingest, process, and analyze customer behavior data for targeted marketing campaigns.
• Designed and implemented ETL processes to extract data from various sources

• Utilized Apache Spark for data processing and analysis

• Built machine learning models to predict customer behavior

• Collaborated with marketing team to optimize campaign strategies
Answered by AI
Add your answer
Q2. Pipeline optimization
Add your answer

Q1. Behavioral question
Add your answer

2 Interview rounds for technical
1st Interview
Duration - 1 hr
Topics - Python DSA question,

Q1. SQL Joins, query , performance
Add your answer
Q2. Python scripting , pandas, pyspark
Add your answer

Medium level of coding questions were asked. Didn't need a lot of optimization to pass the test cases so it wasn't very hard.

Q1. Medium level coding questions were asked. Questions on programming concepts like OOPS, scope of variables were asked. Multiple questions were asked on probability. I was asked questions based on conditiona...read more
Add your answer

3 Lc medium questions
and some MCQ

Q1. On project implementation
Add your answer
Q2. Different sql and spark questions
Add your answer