what is sql windows functions
Data Engineer Interview Questions
18,724 data engineer interview questions shared by candidates
They asked me about data modeling.
How many ETL tools you have worked on. Explain one.
If a manager suggests an approach to a problem that you think is incorrect, what would you do?
How do you create a schema that would keep track of a customer address where the address changes?
I want to design a database similar to imdb, design it, and tell me the structure/fields so that 1. given a specific year, you can find top 5 grossing films 2. given an actor, return all his costars 3. all movies with more than 3 cast members.
Mainly on Batch and CDC architectures. SQL
All questions are simple if it's normal but with a word 'interview' your brain becomes blank ..😔 it might not be everyone but 'll put together in a day .. Am so tired today after the interview.
SQL question about aggregating a running total of the week's sales by business group.
The below questions were asked. 3 tables are there with many to many relationship (Order and Item) Order table (OrderId, OrderDate) Item Table (ItemId, Name) Order Item table (OrderId, ItemId) Find all customers who purchased items - Kindle and Alexa both (Exclude customers who purchased only 1 item) Find the items in the first purchase for a customer - Print customer id, item id Delete duplicate rows from the Order table
Viewing 481 - 490 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerPerl DeveloperAnalytics EngineerDatabase AdministratorData Warehouse DeveloperDatastage DeveloperDatawarehouse DeveloperData MinerEtl TesterEtl DeveloperData ModelerBusiness Objects DeveloperData AnalystMachine Learning ScientistData ScientistData Warehouse ArchitectBusiness Intelligence SpecialistData Warehouse ManagerOracle Data Integrator