DataGrokr Interview Questions and Answers

Spark related assignment

Q1. SQL question like select and filter related topics
Add your answer
Q2. Python to sort numbers
Ans. 
Use the sorted() function in Python to sort numbers in a list.
• Use the sorted() function with the list of numbers as input.

• sorted() function returns a new sorted list without modifying the original list.

• You can use the reverse parameter in sorted() to sort in descending order.

• Example: numbers = [3, 1, 4, 1, 5, 9, 2] sorted_numbers = sorted(numbers) print(sorted_numbers)
Answered by AI
Add your answer

Q1. Explain my experience
Ans. 
I have experience working as a Data Engineer for 5 years in a tech company, where I was responsible for designing and implementing data pipelines, optimizing data storage and retrieval, and collaborating with cross-functional teams.
• Designed and implemented data pipelines to extract, transform, and load data from various sources

• Optimized data storage and retrieval processes to improve efficiency and performance

• Collabora...read more
Answered by AI
Add your answer
Q2. Learning or study process
Ans. 
Continuous learning through online courses, books, and hands-on projects.
• Regularly enroll in online courses related to data engineering to stay updated on new technologies and best practices.

• Read books and articles on data engineering to deepen understanding of concepts and techniques.

• Work on hands-on projects to apply theoretical knowledge and gain practical experience.

• Participate in data engineering communities and f...read more
Answered by AI
Add your answer

You get an assignment with a deadline of 4-5 days. It's basically the SQL queries and Flask API. So the assignment will be evaluated on code quality and time taken for execution.

Q1. In-depth SQL knowledge required.
Add your answer
Q2. Any one programming language you prefer and questions will be asked on it.
Add your answer
Q3. Print 1-50 using SQL (not from the table).
Ans. 
Use recursive CTE to print numbers 1-50 in SQL
• Use recursive Common Table Expression (CTE) to generate numbers from 1 to 50

• Start with anchor member as 1 and recursively add 1 until reaching 50

• Select the generated numbers from the CTE
Answered by AI
Add your answer
Q4. Study the assignment you did very well,questions will be on this as well.
Add your answer
Q5. Will be asked to explain about all your projects mentioned in resume, or even the skills u acquired.
Add your answer

I attended interview for data engineer intern in March 2024. First round was written test which consisted of 30 questions of 50 marks, Out of which 27 questions are MCQ type and 3 questions are coding.
The coding questions are
1. Write program to find the Fibonacci series
2. Program to check if a linked list is palindrome or not
3. Query to find the Nth highest salary

I was assigned a fairly straightforward data analysis task with a one-week deadline. For this task, we were required to learn Pyspark SQL.

Q1. In this round, they asked a lot of SQL-related questions. We are required to be quite proficient in SQL. It is preferable but not required to be familiar with cloud technologies for this round. Python at t...read more
Add your answer

Q1. It's simply a validation round. The manager asked about personal information related to my resume and assessed my skills and experience, such as why are you interested in this opportunity?
Add your answer