describe yourself. Asked to write SQL queries. Asked BQ optimization
Senior Data Engineer Interview Questions
2,400 senior data engineer interview questions shared by candidates
type-0-1-2 dimensional modelling questions and regular expressions.
Functional question and was with the founder.
Round 1 1. How much time have you spent on data engineering versus backend development? 2. What motivated your transition from a domestic tech company to a global fintech firm? How does this relate to your career plan? 3. Why did you leave your previous company? What was the scale of the recent layoff? 4. What are your key areas of interest and strengths, as you mentioned? 5. What was the size and structure of your team? Was it organized by business line? 6. Can you walk me through your experience with data warehouse modeling? How did it align with business processes? ⸻ Round 2 1. Regarding your past projects, how were the key performance metrics determined? 2. Can you explain the Spark-based jobs you worked on? Were they similar to the ones used in large-scale internet companies? 3. What’s your view on the pros and cons of cloud-native platforms like Google Cloud versus traditional data platforms like MaxCompute? 5. How do you ensure that your data warehouse models truly reflect the needs of the business? ⸻ Soft Skills 1. How do you typically approach a new requirement or development task? 2. How do you handle situations where business stakeholders challenge your technical decisions?
Formal introduction and about my current project
Python file reading and data parsing Advanced SQL questions Describe an architectural issue that you solved and explain the end to end design
The interview questions are very basic... but need to prepared very well.
How to find duplicate rows from table 2 which has 2M + 10(duplicate rows) How to find 10 duplicates from 1M records without primary key. questions on Strings and collections in java. Kafka questions involving offset related questions.
SQL query question
Video call with tech team was more about background and career goals than technical knowledge; that was left for the take-home challenge
Viewing 1661 - 1670 interview questions