Nielsen Project Manager Interview Questions and Answers

Q1. How good are you with SQL?
Ans. 
I am proficient in SQL and have experience writing complex queries for database management and reporting purposes.
• Proficient in writing SQL queries for data retrieval, manipulation, and reporting

• Experience with complex joins, subqueries, and stored procedures

• Familiarity with database management systems such as MySQL, SQL Server, and Oracle

• Ability to optimize queries for performance and efficiency
Answered by AI
Add your answer
Q2. What are the P&L metrics of credit card?
Ans. 
P&L metrics of credit card include revenue, expenses, and profit generated from credit card operations.
• Revenue: Total income generated from credit card fees, interest charges, and other sources.

• Expenses: Costs associated with credit card operations, such as marketing, customer service, and technology.

• Profit: The difference between revenue and expenses, indicating the financial performance of the credit card business.

• Ex...read more
Answered by AI
Add your answer

Q1. Tell us about yourself?
Ans. 
Experienced project manager with a background in IT and a proven track record of delivering successful projects on time and within budget.
• Over 5 years of experience managing IT projects

• Strong leadership and communication skills

• Proficient in project management tools such as Jira and Microsoft Project

• Successfully led a team to implement a new CRM system, resulting in a 20% increase in sales
Answered by AI
Add your answer
Q2. What are your 5 year plans,
Ans. 
To become a certified Project Management Professional (PMP) and lead successful projects in a reputable organization.
• Obtain PMP certification within the next 2 years

• Lead at least 3 major projects to successful completion

• Develop strong leadership and communication skills

• Expand network within the project management community

• Seek opportunities for professional growth and advancement
Answered by AI
Add your answer

Q1. Question related to project
Add your answer
Q2. Technical questions related to project
Add your answer

Q1. Background related questions
Add your answer

Q1. What is logistic regression
Ans. 
Logistic regression is a statistical model used to predict the probability of a binary outcome based on one or more predictor variables.
• Logistic regression is used when the dependent variable is binary (e.g. 0 or 1, yes or no).

• It estimates the probability that a given outcome is true using a logistic function.

• The output of logistic regression is a probability score between 0 and 1.

• It is commonly used in various fields ...read more
Answered by AI
Add your answer
Q2. How to select variable in model
Ans. 
Variables in a model can be selected based on their significance, relevance, and impact on the outcome.
• Consider the purpose of the model and the specific research question being addressed.

• Identify variables that are likely to have a significant impact on the outcome.

• Use statistical techniques like regression analysis to determine the importance of each variable.

• Consider the practicality and feasibility of collecting da...read more
Answered by AI
Add your answer

Q1. Difference between itv and otv
Ans. 
ITV stands for Intra-tenant VLAN and OTV stands for Overlay Transport Virtualization. They are both networking technologies used in data centers.
• ITV is used for communication within the same data center tenant, while OTV is used for communication between different data center tenants.

• ITV operates at Layer 2 of the OSI model, while OTV operates at Layer 3.

• ITV uses VLANs to isolate traffic within a data center, while OTV...read more
Answered by AI
Add your answer
Q2. Which type of model better
Ans. 
There is no one-size-fits-all answer to which type of model is better, as it depends on the specific project requirements and constraints.
• The choice of model (e.g. Waterfall, Agile, Scrum) should be based on factors such as project scope, timeline, team size, and client preferences.

• Waterfall model is suitable for projects with well-defined requirements and a fixed scope, while Agile methodologies are more flexible and ...read more
Answered by AI
Add your answer

There were questions on Sql and python
1. Return the tuple set where sum is 25
2. Writebto a program to return 3rd highest salaried employee

1. Questions were on window functions
2. Python string operation questions

Q1. What are the difficult projects led by you
Add your answer
Q2. How do you handle the estimations and client budget
Ans. 
I handle estimations by thoroughly analyzing project requirements and creating detailed budgets in alignment with client expectations.
• Conduct a comprehensive analysis of project requirements to determine resources needed

• Create a detailed budget outlining costs for materials, labor, and any other expenses

• Regularly communicate with the client to ensure budget alignment and address any changes or concerns

• Utilize project m...read more
Answered by AI
Add your answer

Q1. Random Forrest Process
Add your answer

Q1. Why do you want to work here?
Add your answer