Upload Button Icon Add office photos

Filter interviews by

Wtw Global Delivery And Solutions new Product Development Engineer Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Explain SCD Type 2 Implementation in Informatica
  • Ans. 

    SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

    • SCD Type 2 maintains a separate row for each change in data, with a start and end date.

    • It requires a surrogate key to uniquely identify each row.

    • Informatica provides a built-in SCD Type 2 transformation to implement this technique.

    • Example: tracking changes in customer addresses over time.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Kindly focus on basic BI terminologies, common to trivial scenarios and introductory information on latest trending tools and technologies.

Skills evaluated in this interview

Interview Questionnaire 

8 Questions

  • Q1. Find a number which occurs odd number of times and all number occurs even number of times
  • Ans. 

    Find an odd occurring number among even occurring numbers.

    • Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

    • Iterate through the array and XOR each element with the result variable.

    • The final result will be the odd occurring number.

  • Answered by AI
  • Q2. Some discussion about my minor project
  • Q3. Spiral order of binary tree and mattrix, print it
  • Ans. 

    Print the spiral order of a binary tree and matrix.

    • For binary tree, use level order traversal and alternate direction for each level.

    • For matrix, use four pointers to traverse in spiral order.

    • Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

    • Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

  • Answered by AI
  • Q4. Some question about os,dbms
  • Q5. Find pair which have a given sum in a given array
  • Ans. 

    Finding pairs in an array with a given sum.

    • Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

    • Use a hash table to store the elements of the array and their indices for faster lookup.

    • If there are multiple pairs with the same sum, return any one of them.

    • If no pair is found, return null or an empty array.

  • Answered by AI
  • Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
  • Ans. 

    Find total number of k element with given avg in an array in minimum time complexity.

    • Use sliding window technique to traverse the array in O(n) time complexity.

    • Maintain a sum variable to keep track of the sum of elements in the window.

    • If the sum of elements in the window is equal to k times the given avg, increment the count.

    • Move the window by subtracting the first element and adding the next element in the array.

  • Answered by AI
  • Q7. Print all elements which in not boundary element in a given binary tree
  • Ans. 

    Printing non-boundary elements of a binary tree

    • Traverse the tree in any order (preorder, inorder, postorder)

    • Check if the current node is not a boundary node (not the first or last node in its level)

    • If it is not a boundary node, print its value

    • Recursively traverse its left and right subtrees

  • Answered by AI
  • Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

Interview Questionnaire 

1 Question

  • Q1. Frequency of each word ina sentence
  • Ans. 

    To find the frequency of each word in a sentence.

    • Split the sentence into words

    • Create a dictionary to store word frequency

    • Iterate through the words and update the dictionary

    • Return the dictionary

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Sep 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Few DSA questions, questions about my projects and my resume. Also, since I specialise in python, if I could create an API using it. HR questions, hobbies, leadership experience...

Interview Preparation Tips

Interview preparation tips for other job seekers - Understanding the culture of J.P. Morgan Chase played a big role in passing the interview. The coding questions were easy/medium level. The interviewers were very friendly.

Interview Questionnaire 

1 Question

  • Q1. It was wonderful .They have asked about normal technical questions with how we faced real time.Both SAS and Mainfrmae.

I applied via Naukri.com and was interviewed in Oct 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions were mostly based out of the core technology stack i was being hired for

Interview Preparation Tips

Interview preparation tips for other job seekers - Had to go through 2 rounds of technical interview followed by an MR. Technical rounds were quite intensive with mostly the focus on your core technical skill. I dont know much by now about the company but yes as far as i heard and have known by now it's a good place to work at with proper recognition to one's work and on an average a good pay scale as compared to most other service based firms with not much surprise though.

Interview Questionnaire 

1 Question

  • Q1. Core Java and aws
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Sep 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Array related problem
Round 3 - Technical 

(1 Question)

  • Q1. C# oops related deep question
Round 4 - Technical 

(1 Question)

  • Q1. Project Design related questions
Round 5 - Technical 

(1 Question)

  • Q1. SQL Linq mvc net core related questions
Interview experience
3
Average
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Case Study 

How would you approach performance issues in an application module

Round 3 - Technical 

(1 Question)

  • Q1. How would you process millions of records in an excel file
  • Ans. 

    Use programming language to read and process data from Excel file efficiently.

    • Use a programming language like Python, Java, or C# to read the Excel file.

    • Utilize libraries like pandas in Python or Apache POI in Java for efficient data processing.

    • Implement batch processing or parallel processing to handle millions of records efficiently.

    • Optimize code for memory management and performance to avoid crashes or slowdowns.

    • Con...

  • Answered by AI

Skills evaluated in this interview

Tell us how to improve this page.

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 589 Interviews
Citicorp Interview Questions
3.7
 • 575 Interviews
American Express Interview Questions
4.1
 • 368 Interviews
UBS Interview Questions
3.9
 • 339 Interviews
Morgan Stanley Interview Questions
3.6
 • 295 Interviews
Morningstar Interview Questions
3.9
 • 245 Interviews
FactSet Interview Questions
3.9
 • 211 Interviews
BNP Paribas Interview Questions
3.8
 • 183 Interviews
View all
Senior Advisor
50 salaries
unlock blur

₹3.3 L/yr - ₹8 L/yr

Senior Analyst
37 salaries
unlock blur

₹7 L/yr - ₹18 L/yr

Analyst
33 salaries
unlock blur

₹4.8 L/yr - ₹16.3 L/yr

Assistant Manager
14 salaries
unlock blur

₹6.8 L/yr - ₹21 L/yr

Team Lead
13 salaries
unlock blur

₹10 L/yr - ₹30 L/yr

Explore more salaries
Compare Wtw Global Delivery And Solutions with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

Citicorp

3.7
Compare

American Express

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview