NIKE Senior Data Engineer Interview Questions and Answers

Q1. Spark SQL Hadoop Python
Add your answer
Q2. Internals of Hadoop System
Ans. 
Hadoop is an open-source distributed processing framework that manages data processing and storage for big data applications.
• Hadoop consists of HDFS (Hadoop Distributed File System) for storage and MapReduce for processing.

• Hadoop uses a master-slave architecture with a single NameNode and multiple DataNodes.

• Data is stored in blocks across multiple DataNodes for fault tolerance and scalability.

• Hadoop ecosystem includes ...read more
Answered by AI
Add your answer

Q1. Intro of Databricks concepts
Add your answer
Q2. Previous projects questions and difficulties
Add your answer

Q1. Round 1: This is an initial screening round. You will be tested on the foundation of multiple technologies. SQL (Majority), Python, Visualization skillset and some basic statistics. Round 2 : Advance t...read more
Add your answer

Q1. Wxaplinnyour project
Add your answer
Q2. How would you build a pipeline to connect http source and bring data in adls
Ans. 
Build a pipeline to connect http source and bring data in adls
• Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source

• Transform the data as needed using tools like Apache Spark or Azure Databricks

• Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
Answered by AI
Add your answer
Q3. Dimension and fact tabel difference
Ans. 
Dimension tables store descriptive attributes while fact tables store quantitative data.
• Dimension tables contain attributes that describe the business entities, such as customer, product, or time.

• Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.

• Dimension tables are denormalized and have a one-to-many relationship with fact tables.

• Fact table...read more
Answered by AI
Add your answer
Q4. Write slq query to get employee having 2manager
Ans. 
Use a self join to find employees with 2 managers in SQL query.
• Use a self join on the employee table to join the table with itself.

• Count the number of distinct managers for each employee.

• Filter the results to only include employees with 2 managers.
Answered by AI
Add your answer
Q5. Get second highest salary usingSQL
Add your answer

Code question on tree dp and metrics dp

Q1. About Hive partitioning, Pyspark
Add your answer

Q1. It was hiring drive face to face interview
Add your answer
Q2. Project related indepth discussions
Add your answer
Q3. Medium level SQL and DSA
Add your answer
Q4. Sorting colors DSA problem
Ans. 
Sort an array of colors in a specific order
• Use a custom sorting function to sort the colors based on a predefined order

• Map each color to a numerical value and sort based on that value

• Consider using a hashmap to store the order of colors
Answered by AI
Add your answer
Q5. In depth spark optimization question
Add your answer

Data structures and algorithms

Q1. Low level design and system design
Add your answer

Q1. About project and deal with particular problem
Add your answer