Wunderman Thompson Change Manager 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. Why we are hiring you
Add your answer
Q2. What's your qualification
Add your answer
Q3. Tell me about your daily ruteen
Add your answer

Quant, Technical and Logical Reasoning

Q1. What is owasp top 10?
Ans. 
OWASP Top 10 is a list of the most critical web application security risks.
• It is updated every 3-4 years by the Open Web Application Security Project (OWASP)

• The list includes vulnerabilities such as injection, broken authentication and session management, cross-site scripting (XSS), and more

• It is used as a guide for developers and security professionals to prioritize their security efforts

• The latest version is OWASP To
Answered by AI
Add your answer
Q2. Audit Fundamentals? Risk, threat, impact etc.
Add your answer

Scenario based case study, to identify risk based observations

Q1. Knowing RBI Circulars on cybersecurity
Add your answer

Q1. Why you want to join ReBIT?
Add your answer

Process and Situation based questions

Q1. Burndown chart analysis
Add your answer

Project management, spring and java related total 20 questions to be completed in 30 minutes.
I was not aware of such interview process and environment during test examination was not peaceful.

Q1. What is spring IOC?
Ans. 
Spring IOC (Inversion of Control) is a design pattern where the control of object creation and lifecycle is shifted from the application code to the Spring framework.
• In Spring IOC, objects are created and managed by the Spring container.

• It helps in achieving loose coupling between classes by removing the dependency on object creation.

• Dependency Injection is a key concept in Spring IOC, where the dependencies of a class...read more
Answered by AI
Add your answer
Q2. Factory Design Pattern?
Add your answer
Q3. Current Role, Responsibility and tech stack?
Add your answer