Atlan Data Engineer Interview Questions and Answers

SQL, excel, tableau , looker studio

Q1. What is your notice period.
Add your answer

Q1. Medium leetcode
Add your answer

Q1. Regarding experience
Add your answer

Q1. General behavioural question
Add your answer

Q1. Difference between Drop and Truncate ?
Ans. 
Drop deletes the table structure and data, while truncate only deletes the data.
• Drop is a DDL (Data Definition Language) command, while truncate is a DML (Data Manipulation Language) command.

• Drop removes the table from the database, while truncate only removes the rows from the table.

• Drop is slower and requires more permissions than truncate.

• Example: DROP TABLE table_name; TRUNCATE TABLE table_name;
Answered by AI
Add your answer
Q2. To write SQL queries
Add your answer

Q1. Why you are switching to non-core?
Ans. 
I am switching to non-core because I want to explore new opportunities and challenges outside of my current field.
• Seeking new challenges and opportunities

• Exploring different industries and roles

• Developing new skills and gaining diverse experience
Answered by AI
Add your answer
Q2. What are your expected salary?
Ans. 
I am looking for a competitive salary that reflects my skills and experience in the data analysis field.
• Research the average salary for Data Analysts in your area to have a realistic expectation

• Consider your level of experience, education, and any specialized skills you bring to the table

• Be prepared to negotiate based on the company's budget and benefits package
Answered by AI
Add your answer

Q1. They asked based on your resume few excel questions also
Add your answer
Q2. They explained about their company
Add your answer

Q1. About company little bit about project
Add your answer

Had assignment for ror and react basic crud

Q1. Elevator problem in java
Ans. 
Elevator problem in Java
• Create an Elevator class with methods for moving up and down

• Use a Queue to keep track of the floors that need to be visited

• Implement a scheduling algorithm to determine the order of floor visits
Answered by AI
Add your answer
Q2. Horse race puzzle solution
Add your answer

50 mcq were asked in 12 mins. Most of the candidates qualified this round.

3 coding questions of basic DSA were asked. Also few mcqs from Operating System, Networking and DBMS.

Q1. The technical round was of 40 mins. 3 standard questions from DSA were asked for which only approach was enough. Questions were from string, array and tree- Rotated string, Lowest common ancestor, etc.
Add your answer
Q2. Project related discussion regarding my role in the team.
Add your answer
Q3. A few HR questions related to family background. Why not go for higher studies like the rest of my family. Had to convince him that I saw more growth in working for an organisation.
Add your answer

Q1. My introduction then, standard HR questions like where do i see myself in coming yrs, why do i want to join the company, etc. It lasted 10 mins
Add your answer