How do you rename a file in unix?
Data Engineer Interview Questions
20,211 data engineer interview questions shared by candidates
Main things that were asked mainly revolved around SQL, Databases, Big Data, a bit of Linux or Unix commands. Coding Round consisted of 5 questions 1 question atleast of SQL, rest average coding questions.
Acid properties of data base ?
In your previous roles, what was something you didn’t like about your job, and what aspects of your role did you enjoy?
Can you explain the process of ETL (Extract, Transform, Load) and its importance in the context of data engineering
Question related to your coding test
1. A Python script to check the total number of item ingredients and does it has a sweetener or not for a sample input which they provided
Python- 1. WAP to eliminate vowels in input string. 2. WAP to print "aaabbbbcccc". input - 'a3b4c4' SQL- 1. rank/dense_rank/row_num - state difference and explain with a real life example. 2. Input Table C1 | c2 1 | India 2 | Aus 3 | Pak 4 | SL OutPut India | Aus India | Pak India | SL Aus | Pak Aus | SL Pak | SL Big Data :- 1. Diff between Parquet/Avro/ORC/CSV 2. Hive partitioning vs bucketing 3. How data is stored in AWS S3 ? 4. Types of Spark modes (cluster/client) 5. Types of cluster managers (YARN/Mesos/ Kubernetes/Local/Standalone)
Behavior questions plus technical assessment
Was asked to build a data pipeline that starts by making a request to an api that contains time series data, parse the response and save to a file. The API provides energy trading data.
Viewing 901 - 910 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerAnalytics EngineerPerl DeveloperDatawarehouse DeveloperEtl DeveloperData ModelerDatastage DeveloperEtl TesterData AnalystOracle Data IntegratorMachine Learning ScientistData ScientistData MinerBusiness Objects DeveloperDatabase AdministratorData Warehouse DeveloperData Warehouse ManagerData Warehouse ArchitectBusiness Intelligence Specialist