Dun & Bradstreet Summer Intern Interview Questions and Answers

There were 3 rounds for data science consultant position at Equifax. 1st round consists of Python and SQL questions and also in this round they have tested analytical thinking as well.

In 2nd round they have asked me questions from my resume and asked me to explain the projects which I have worked on in previous company. In this round they have asked me pandas related questions and asked me write code.

Q1. In Managerial round again here I have been asked questions related my projects. and no coding round in this stage.
Add your answer

Q1. Describe yourself briefly about your experience
Add your answer
Q2. Tell about your current company
Add your answer

Q1. Key ratios and Industry related question
Add your answer
Q2. Profit ratio, leverage ratio
Add your answer

Q1. Some SQL was shared and asked to explain what it was
Add your answer
Q2. It was a SQL Server Common Table Expression
Add your answer
Q3. General questions about experience in past projects and how you dealt with difficult situations
Add your answer

Q1. What is Tuples? How do you convert a string to a tuple?
Ans. 
Tuples are immutable sequences of elements. A string can be converted to a tuple using the tuple() function.
• Tuples are similar to lists but are immutable

• Elements of a tuple are enclosed in parentheses ()

• A string can be converted to a tuple using the tuple() function

• Each character in the string becomes an element in the tuple
Answered by AI
Add your answer
Q2. What is Left Join? Show one Left join for 2 data frames on Python
Ans. 
Left join is a type of join operation in SQL that returns all the rows from the left table and matching rows from the right table.
• Left join is performed using the 'left join' keyword in SQL

• In Python, left join can be performed using the 'merge' function from the pandas library

• Syntax: pd.merge(left_dataframe, right_dataframe, how='left', on='key_column')

• Example: pd.merge(df1, df2, how='left', on='id')
Answered by AI
Add your answer

Q1. R u team player
Ans. 
Yes, I am a team player who values collaboration and communication with my colleagues.
• I believe in open communication and actively listen to my team members' ideas and feedback.

• I am willing to help out my team members when needed and work towards common goals.

• I am adaptable and can easily adjust to different team dynamics and work styles.

• I have successfully collaborated with cross-functional teams on various projects i
Answered by AI
Add your answer
Q2. What is ru expected team to be
Add your answer

Q1. Tell me about yourself and work experience
Ans. 
I am a dedicated professional with 5 years of experience in marketing and project management.
• Worked in marketing for a tech company for 3 years

• Managed multiple projects simultaneously

• Strong communication and organizational skills

• Experience with data analysis and reporting

• Led successful marketing campaigns resulting in increased sales
Answered by AI
Add your answer