Wipro Senior Project Engineer Interview Questions, Process, and Tips

Q1. Write Java Program for Pallindrum number
Ans. 
Java program to check if a number is a palindrome
• Create a function to reverse the number

• Compare the reversed number with the original number to check if it is a palindrome

• Use modulo and division to extract digits from the number
Answered by AI
Add your answer

Q1. Are you ready to relocate
Add your answer

Q1. Explain Internal working of an hashmap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to map keys to values.
• HashMap internally uses an array to store key-value pairs called buckets.

• When a key-value pair is added, the key is hashed to determine the index in the array where the pair will be stored.

• In case of hash collisions, separate chaining or open addressing techniques are used to handle multiple values at the same index.

• HashMap u...read more
Answered by AI
Add your answer

Q1. Different types of Transformation used in SSIS
Ans. 
SSIS uses various transformations like Derived Column, Lookup, Merge, etc.
• Derived Column: Adds new columns or modifies existing ones based on expressions

• Lookup: Retrieves data from a related table based on a common key

• Merge: Combines data from multiple sources based on a common key

• Aggregate: Performs calculations like sum, average, count, etc. on grouped data

• Conditional Split: Routes data based on specified conditions
Answered by AI
Add your answer
Q2. Index in SQL and scenario based questions
Add your answer
Q3. How to delete duplicate in Sql
Ans. 
Use the DISTINCT keyword or GROUP BY clause to delete duplicates in SQL.
• Use the DISTINCT keyword in a SELECT statement to retrieve unique values.

• Use the GROUP BY clause with an aggregate function like COUNT() to remove duplicates.

• Consider using the ROW_NUMBER() function to assign a unique number to each row and then filter out duplicates.
Answered by AI
Add your answer
Q4. Skip rows in an excel in SSIS
Ans. 
Use Conditional Split transformation in SSIS to skip rows in Excel
• Use Conditional Split transformation in SSIS to evaluate a condition for each row

• Set up the condition to skip rows based on a specific criteria, such as row number or value in a column

• Redirect the rows that meet the condition to a different output path to effectively skip them
Answered by AI
Add your answer
Q5. For each loop container in SSIS
Ans. 
Loop container in SSIS is used to iterate through a set of tasks or data flow components multiple times.
• Loop containers can be used to repeat a set of tasks until a specified condition is met.

• They can be configured to loop based on a predefined number of iterations or until a specific condition is true.

• Variables can be used within the loop container to control the iteration process.

• Common use cases include processing m...read more
Answered by AI
Add your answer

Q1. Salary discussion and Job location was discussed.
Add your answer

Normal WILP interview procedure

Q1. Normal WILP Interview procedure
Add your answer

Q1. Strength and weekness
Add your answer

Basic reasoning and analytical

Basic angular task and logic

Q1. Basic Java script and angular
Add your answer

Q1. Responsibility and salary discussion just formalities
Add your answer