Tip 1 : Mention your Roles and Responsibilities in a project on your Resume
Tip 2 : If you are applying for Data engineer post, practice SQL(basic-advance) and python(basic) questions
Tip 3 : understand the project(s) you have worked on, this will help you in answering project related questions.
Tip 1 : mention projects with your roles and responsibilities within the project.
Tip 2 : Do not put false experience on the resume, because you never know what questions could be asked from there
Tip 3 : mention POCs or POVs you have done previously.
Time: 5:00 PM ; You can ask for interview schedule based on your availability.
Your Introduction,
Basic SQL questions ,
DBMS properties,
SQL coding questions,
ADF basic questions ( Integrated Runtimes, pipelines etc)
Acid Properties of DBMS
Tip 1 : Explain the ACID properties of DBMS
SQL cross joins having duplicate valuesbin join columns
Tip 1 : explain with an example
Tip 2 : prepare join questions with following scenarios as well:
Unique values
Duplicate values
Null values
Timing( 5-6 pm extended till 6:30 pm)
All questions were asked on video call and screen sharing.



For the given string “what we think we become”
“what”,” think”, and “become” occurs 1 time, and “we” occurs 2 times in the given string.
First I used count function to solve this problem, later interviewer asked to solve it without using function,
I used loop to solve it
Incremental data pull from a on premise datasource.
Tip 1 : mention about self IR
Tip 2 : steps to configure Self IR
Tip 3 : mention about data pull steps
Azure Data Factory:
create an pipeline to read data from AdLS to a SQL server database.
Tip 1 : mention each and every step you will need to do to create the pipeline
Tip 2 : mention about IRs, linked service
Tip 3 : mention all the activity and how you would maintain schema and data quality
Timing : 6PM
This round was taken by a Manager to know your expertise and interest.
Tell about yourself and explain one of the project you liked alot and reason for the same.



Timing : 2:00 PM
Interviewer had very calm personality.
It was nice talking to him.
Introduce yourself,
And there were questions like, how do you resolve team conflicts etc.
Have you ever had conflict in your team and steps you have taken to resolve those conflicts.
Tip 1 : Answer the questions with patience
Tip 2 : have positive mindset

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What is recursion?