Wipro Project Engineer Interview Questions, Process, and Tips

I'm from VLSI background so had SV UVM related coding questions.

Q1. Asked basics of verilog and then questions from SV and UVM.
Add your answer

Verbal and aps round

Q1. Technical question on python, sql, coding
Add your answer
Q2. What is python scripting
Ans. 
Python scripting is the process of writing scripts or programs using the Python programming language to automate tasks or perform specific functions.
• Python scripting allows for automation of repetitive tasks.

• It can be used for data manipulation, web scraping, system administration, and more.

• Python scripts are typically saved with a .py extension and can be run from the command line or an integrated development environm
Answered by AI
Add your answer
Q3. Differnce between method overloading and over riding
Ans. 
Method overloading is having multiple methods in the same class with the same name but different parameters, while method overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
• Method overloading involves multiple methods with the same name but different parameters.

• Method overriding involves a method in a subclass with the same name and parameters as a method in the ...read more
Answered by AI
Add your answer
Q4. What is Csv files
Ans. 
CSV files are plain text files that store tabular data in a structured format.
• CSV stands for Comma-Separated Values

• Each line in a CSV file represents a row in the table, with columns separated by commas

• CSV files can be easily opened and edited in spreadsheet software like Microsoft Excel or Google Sheets
Answered by AI
Add your answer

Scenerio based Test cases

Q1. Tell me about yourself Python Delete, truncate,remove diff Vlookup Pivot table
Add your answer

Q1. What databases do you know
Ans. 
I am familiar with databases such as MySQL, Oracle, SQL Server, and MongoDB.
• MySQL

• Oracle

• SQL Server

• MongoDB
Answered by AI
Add your answer
Q2. What are the Normalization types in SQL?
Ans. 
Normalization types in SQL are techniques used to organize data in a database to reduce redundancy and improve data integrity.
• First Normal Form (1NF) - Eliminates duplicate data by ensuring each column contains only atomic values.

• Second Normal Form (2NF) - Requires that each non-key attribute is fully functionally dependent on the primary key.

• Third Normal Form (3NF) - Ensures that all attributes are functionally depend...read more
Answered by AI
Add your answer
Q3. Project Explanation
Add your answer
Q4. What are the types of Joins in SQL
Ans. 
Types of Joins in SQL include Inner Join, Left Join, Right Join, and Full Join.
• Inner Join: Returns rows when there is a match in both tables

• Left Join: Returns all rows from the left table and the matched rows from the right table

• Right Join: Returns all rows from the right table and the matched rows from the left table

• Full Join: Returns rows when there is a match in either table
Answered by AI
Add your answer
Q5. What is Trigger in SQL
Ans. 
A trigger in SQL is a set of SQL statements that automatically 'fires' or executes when a specified event occurs in a database.
• Triggers can be used to enforce business rules, perform data validation, or maintain referential integrity.

• There are two main types of triggers in SQL: 'BEFORE' triggers and 'AFTER' triggers.

• Example: A trigger can be set up to automatically update a 'last_modified' timestamp column whenever a r
Answered by AI
Add your answer
Q6. Can you explain about View
Ans. 
A view is a virtual table created by a query that can be used like a table in a database.
• Views are used to simplify complex queries by storing them as a virtual table.

• Views do not store data themselves, but display data from the underlying tables.

• Views can be used to restrict access to certain columns or rows of a table.

• Views can be used to join multiple tables and present the data in a single table-like structure.
Answered by AI
Add your answer

Q1. What are your Hobbits
Add your answer
Q2. Why do you want to join in Wipro
Add your answer
Q3. Why should we hire you
Add your answer
Q4. Are you okay to relocate
Add your answer

Q1. Simple basic technical Questions 1. List and Tuple in python 2. datatypes in Python
Add your answer
Q2. Are you ready to relocate
Add your answer

Aptitude was held first , i cleared that round and the took me to face to face interview

Q1. In this round he asked me some questions on my college project and some of questions related to python programming language
Add your answer
Q2. What is your role in your college project and explain it And asked some questions on python programming language
Add your answer

In first round I had aptitude, reasoning and 2 coding test.

Q1. In HR round HR asked me about data structures
Add your answer
Q2. Basic concepts of Oops
Add your answer