DNB 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. 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. 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

Analytical, Language, Accounting, Excel and Case Scenario

Q1. Why consultant?
Add your answer
Q2. How will you consult a clint who wants to acquire another company?
Add your answer

Q1. Basic background related questions
Add your answer

Q1. Work experience Auction process Bidding
Add your answer

Q1. Baisc questions, communication skills with basic conputer knowledge and much about previous employment skills
Add your answer
Q2. Same basic questions were asked in 2nd round
Add your answer

Q1. Do you know about INDas?
Ans. 
INDas stands for Indian Accounting Standards, which are a set of accounting standards notified by the Ministry of Corporate Affairs in India.
• INDas are based on International Financial Reporting Standards (IFRS) to ensure transparency and consistency in financial reporting.

• They are mandatory for certain classes of companies in India, such as listed companies and certain other public companies.

• INDas aim to improve the qu...read more
Answered by AI
Add your answer

Q1. How do you start with a bottom up research?
Ans. 
Start bottom up research by identifying specific data points, analyzing them individually, and then synthesizing them into a larger conclusion.
• Identify specific data points or pieces of information relevant to the research topic

• Analyze each data point individually to understand its significance and implications

• Synthesize the individual data points into a larger conclusion or insight

• Use a structured approach to organize...read more
Answered by AI
Add your answer
Q2. By analysing is,bs and cf. Reading investor presentation and annual report
Add your answer

Q1. About reason for break if any
Add your answer

Q1. Based on your resume, will ask questions based on your past questions
Add your answer
Q2. When will u get #ref error and when u get #value error in excel
Ans. 
You get #REF error in Excel when a cell reference is not valid, and you get #VALUE error when a formula includes the wrong type of argument or operand.
• You get #REF error when a formula refers to a cell that is not valid, such as a deleted cell or a cell in a different sheet.

• You get #VALUE error when a formula includes the wrong type of argument, such as text instead of a number, or when an operand is not valid for the ...read more
Answered by AI
Add your answer

Q1. Reason for choosing this job and salary negotiation
Add your answer