Can you explain the ETL process? What are its primary components? What are some common challenges in data engineering, particularly when dealing with big data? How would you design and implement a data pipeline for processing and analyzing streaming data? What are some popular tools and technologies used in data engineering, and how are they typically used? Describe the concept of data warehousing. What are the benefits of using a data warehouse?
Nothing special that I can remember they didnt ask to see any certification or other projects. Just did 2 mysql questions on an unknown IDE.
Basic work scenario type questions and how you'd handle them.
About yourself and data engg background
Tree traversal, data modeling around warehouse, ETL approach to specific problem.
Questions to gauge fundamentals in Spark
This was a call with the recruiter so the interview was not difficult from a question perspective but difficult from an experience perspective.
Projects worked and questions related to that
1. Have you done any complex data model in your life? 2. Anything which didnt work and what is the alternative you did? 3. 2 sql query - very easy one, using left join and right join 4.what are the types of fact tables 5. Mention ralf kimbell 10 times so that they hire you. :-)
Viewing 2281 - 2290 interview questions