- Extract data from an API - Please explore the data, and present insights - Propose a production setup for the ETL flow
Sr Data Engineer Interview Questions
2,556 sr data engineer interview questions shared by candidates
- did you work with Athena? - what is the difference between OLAT and OLTP? - what happens when join is executed in a data warehouse? - What is sqs and sns?
SQL questions were very reasonable, with window functions being the hardest topic
- Diferença entre Datalake e Datawarehouse e como implementá-los
No questions where asked since the interviewer never responded.
Pure python questions on data modelling, instead of using pandas or pyspark
What was interesting about the job posting?
- Discussion about main data engineering trends - Writing and review SQL code - Writing and review Python code for JSON
How to load and design unstructured data?
First and Second rounds were quiet easy and just on basic python and SQL skills. Third round was bit tough with an AWS Architect. Asked various scenario related questions like 1. How to design an incremental or a full load data pipeline 2. How to capture events from an ERP system using any AWS service and send to any RDS. 3. Joins were asked from two tables. 4. A python nested list was given and asked to compute the sum of all the list elements.
Viewing 2271 - 2280 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer