Data modeling experience and expertise
Data Engineer Interview Questions
20,177 data engineer interview questions shared by candidates
FYP related questions (AI)
Q: Most Technical Question: Describe Data Engineering Project You've worked on
Tell me about your experience
How would you insert new records into a table, and update existing data if the record had changed?
What is the difference between a map and a flatMap in Scala
Q: How big of a dataset have you worked with before in your projects
What is a dual eligibility?
Bellow is a table called fact_daily_users, which contains the users who were active on a specific date with the specific action they have made (aggregate total actions per row). user_id | date | action| total_actions| day_in_row 332 |17/06| view | 1 | 1 332 |20/06| view | 6 | 1 332 |20/06| click | 2 | 1 221 |24/06| view | 4 | 1 221 |24/06| click | 2 | 1 221 |21/06| view | 1 | 2 221 |20/06| view | 1 | 1 332 |21/06| view | 4 | 2 332 |21/06| click | 3 | 2 Q1: write a query that calculates the logic of day_in_row field with SQL, no joins are allowed. "day_in_row" shows consecutive days for user - users that return day after day to the website per row. Q2: write a function (Python / Java) that gets sql query and returns the output in json object
What is Integration Runtime in azure?
Viewing 511 - 520 interview questions
See Interview Questions for Similar Jobs
Analytics EngineerModeling EngineerPerl DeveloperDatabase AdministratorEtl DeveloperData Warehouse ArchitectData ScientistMachine Learning ScientistBusiness Objects DeveloperDatawarehouse DeveloperData Warehouse ManagerData MinerData Warehouse DeveloperData AnalystBusiness Intelligence SpecialistOracle Data IntegratorData ModelerDatastage DeveloperEtl Tester