Koantek Data Engineer Interview Questions and Answers for Freshers

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Ans. 
ACID properties ensure data integrity in DBMS: Atomicity, Consistency, Isolation, Durability.
• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that multiple transactions can be executed concurrently without affecting each other.

• Durability ensures that once...read more
Answered by AI
Add your answer

Q1. HR question and family background
Add your answer

This was my first campus drive,& it was one of the hardest one too.We had 3 coding problems for 60 mins.It was held on HackerRank & it was not so hard but not so easy for the beginners.
1)Lambda Sort
2) and 3) ques on SQL
It was different ques for each one.

Q1. The interviewer asked all the concepts of pyspark, ETL and a code on dsa
Add your answer

Q1. Aws sevices you have worked on
Ans. 
I have worked on various AWS services including S3, EC2, Lambda, Glue, and Redshift.
• S3 - Used for storing and retrieving data

• EC2 - Used for running virtual servers

• Lambda - Used for serverless computing

• Glue - Used for ETL (Extract, Transform, Load) processes

• Redshift - Used for data warehousing and analytics
Answered by AI
Add your answer
Q2. Question on python list and dictionary
Add your answer

Q1. Questions on project and skillset
Add your answer

Q1. Lazy evaluation narrow wide tranform data brick utlity functions
Add your answer
Q2. Dag,edges vertices
Add your answer
Q3. Spark architecture
Add your answer
Q4. Memory allocation
Add your answer