Ascentt Data Engineer Interview Questions and Answers

Q1. Diff between Coalesce and repatriation
Add your answer

Q1. Python Lambda Function
Add your answer
Q2. What are pods in Kubernetes
Ans. 
Pods are the smallest deployable units in Kubernetes, consisting of one or more containers.
• Pods are used to run and manage containers in Kubernetes

• Each pod has its own unique IP address within the Kubernetes cluster

• Pods can contain multiple containers that share resources and are scheduled together

• Pods are ephemeral and can be easily created, destroyed, or replicated

• Pods can be managed and scaled using Kubernetes contr
Answered by AI
Add your answer

Q1. Why do you apply for this position
Ans. 
I am passionate about leveraging data to drive insights and make informed decisions.
• Passionate about working with data and analytics

• Excited about the opportunity to contribute to data-driven decision making

• Interested in the challenges and opportunities in the field of data engineering
Answered by AI
Add your answer
Q2. What is your current salay
Ans. 
I am currently earning a competitive salary based on my experience and skills.
• My current salary is in line with industry standards for data engineers.

• I have received raises and bonuses based on my performance.

• I am open to discussing salary expectations for this role.
Answered by AI
Add your answer

Its mandatory test even for experience people

Q1. Related to technology
Add your answer

Q1. Very good discussion towards work culture, salary and all
Add your answer

Q1. PartitionBy vs bucketBy in spark
Add your answer

Asked me two string array question one was to reverse a string without any pre build function and second one was a medium question to print the number and the count of it into the next level of the tree

Q1. Who is your idol?
Add your answer
Q2. How do you menage your work?
Ans. 
I manage my work by prioritizing tasks, setting goals, staying organized, and communicating effectively with team members.
• Prioritize tasks based on deadlines and importance

• Set clear goals and milestones to track progress

• Stay organized with tools like project management software

• Communicate effectively with team members to ensure alignment and collaboration
Answered by AI
Add your answer

Q1. Internal external tables
Add your answer
Q2. MySQL questions
Add your answer

Coding and aptitude. Aptitude was really simple, you could rule out the options in the MCQ test. Coding round had 2 SQL and two python questions. Each topic had one simple and one hard question

They selected 75 percent of people. They just rules out those who didn't speak at all or spoke very little

Q1. SQL pattern matching, a real world case study in SQL
Add your answer
Q2. Asked about projects
Add your answer