SQL Query Writing: **Table A** Columns: col1 col2 **Table B** Columns: col3 col4 There is no common column to implement the JOIN condition and the Required Output is: col1, col2, col3, col4
Senior Data Engineer Interview Questions
2,396 senior data engineer interview questions shared by candidates
SQL Query Writing: **Table EMP** Input Columns: EMPID, DEPID, SAL, DOJ Output Columns: EMPID, DEPID, SAL, DOJ, NEXT_SAL NEXT_SAL can be derived as the salary of immediate next employee in the given records.
Which AWS services you have used (Hands-On)? Tell me one use case and one limitation of AWS Lambda function?
They asked me real-time scenario questions related to my work experience and how I handle production issues.
Given a list of domains, that are entered sorted, we want to minimize the output of urls by uniting sub-domains by only outputting their common ancestor. Also sibling domains should be listed as their common ancestor.
Big query optimization techniques (partitioning and clustering)
Interviewer mostly asked spark and python related questions as the position was mainly from ETL development
code test, tech discussion on data engineering tech stack and hm round
Window Functions, Python: implement decorator that calculates the time taken by a given function to execute
What data validation tool do you have experience with.
Viewing 661 - 670 interview questions