i
Wipro
Filter interviews by
I appeared for an interview in Feb 2025.
I have experience in identifying opportunities, building relationships, and driving growth in various sectors.
Developed strategic partnerships that increased revenue by 30% in one year.
Conducted market research to identify new business opportunities, leading to the launch of two successful products.
Collaborated with cross-functional teams to enhance service offerings, resulting in improved customer satisfaction scores.
...
ETL stands for Extract, Transform, Load, a process for data integration and management in data warehousing.
Extract: Collecting data from various sources like databases, APIs, or flat files. Example: Pulling sales data from a CRM system.
Transform: Cleaning and converting data into a suitable format. Example: Changing date formats or aggregating sales figures.
Load: Storing the transformed data into a target database or d...
Delete removes specific records from a table; drop removes the entire table structure and its data.
DELETE is a DML command used to remove specific rows from a table based on a condition.
Example: DELETE FROM Employees WHERE EmployeeID = 1; removes the employee with ID 1.
DROP is a DDL command that removes the entire table structure and all its data permanently.
Example: DROP TABLE Employees; deletes the entire Employees t...
Joins are SQL operations that combine rows from two or more tables based on related columns.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the right table and matched re...
DWH (Data Warehouse) is a centralized repository for integrated data, while Data Mart is a subset focused on specific business areas.
DWH stores large volumes of historical data from multiple sources for analysis.
Data Mart is designed for specific departments, like sales or finance.
Example of DWH: A retail company's data warehouse containing sales, inventory, and customer data.
Example of Data Mart: A sales data mart tha...
Primary keys uniquely identify records in a table, while foreign keys establish relationships between tables.
A primary key is a unique identifier for a record in a database table.
Example: In a 'Customers' table, 'CustomerID' can be a primary key.
A foreign key is a field in one table that links to the primary key of another table.
Example: In an 'Orders' table, 'CustomerID' can be a foreign key referencing 'Customers'.
Pr...
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
Drop command deletes the table structure along with data, while truncate command deletes only the data.
Drop command removes the table structure and all its data, while truncate command only removes the data but keeps the table structure intact.
Drop command is a DDL (Data Definition Language) command, while truncate command is a DML (Data Manipulation Language) command.
Drop command is slower than truncate command as it ...
In my project, I perform validations such as data completeness, data accuracy, data transformation, and data integrity checks.
Data completeness checks to ensure all required fields are populated
Data accuracy checks to verify the correctness of data
Data transformation checks to validate the transformation rules are applied correctly
Data integrity checks to maintain data consistency and reliability
Star Schema is a type of database schema where a central fact table is connected to multiple dimension tables. Snowflake Schema is a normalized form of Star Schema where dimension tables are further normalized into sub-dimension tables.
Star Schema has a central fact table connected to multiple dimension tables
Snowflake Schema is a normalized form of Star Schema with sub-dimension tables
Star Schema is denormalized for b...
Fact tables contain quantitative data while dimension tables contain descriptive attributes.
Fact tables store measurable, quantitative data such as sales revenue or quantity sold
Dimension tables store descriptive attributes related to the data in the fact table, such as product name or customer details
Fact tables are typically normalized while dimension tables are denormalized for easier querying
Example: In a sales dat...
I applied via Company Website and was interviewed in Feb 2021. There were 3 interview rounds.
What people are saying about Wipro
I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.
Java is platform independent due to its bytecode and JVM.
Java code is compiled into bytecode which is platform-independent.
JVM (Java Virtual Machine) interprets the bytecode and executes it on any platform.
JVM acts as an abstraction layer between the Java code and the underlying hardware.
This allows Java programs to run on any platform that has a JVM installed.
For example, a Java program written on a Windows machine ca...
I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Walk-in and was interviewed in Jan 2019. There were 4 interview rounds.
I have a unique combination of analytical skills, creativity, and strong attention to detail.
I have a background in both finance and graphic design, allowing me to approach problems from multiple perspectives.
I excel at finding innovative solutions to complex problems.
I am known for my ability to think outside the box and come up with creative solutions.
I have a keen eye for detail and always strive for perfection in m
I added value to my last organization by implementing data-driven strategies to improve efficiency and decision-making.
Implemented data analytics tools to optimize processes and identify cost-saving opportunities
Developed KPI dashboards to track performance and make informed business decisions
Led cross-functional teams to successfully launch new products and services
Provided training and mentorship to junior analysts t
I applied via Campus Placement and was interviewed before Apr 2020. There were 3 interview rounds.
I applied via Referral and was interviewed before Oct 2019. There was 1 interview round.
I applied via Campus Placement and was interviewed before Jul 2021. There was 1 interview round.
I appeared for an interview before May 2020.
I am a highly motivated individual with a passion for learning and a strong work ethic.
I have a Bachelor's degree in Computer Science from XYZ University.
I have completed several internships in software development, including one at ABC Company where I worked on a team to develop a mobile app.
I am proficient in several programming languages, including Java, Python, and C++.
I am a quick learner and enjoy taking on new c...
based on 3 interviews
1 Interview rounds
based on 11 reviews
Rating in categories
Project Engineer
32.7k
salaries
| ₹1.8 L/yr - ₹8.4 L/yr |
Senior Software Engineer
23.3k
salaries
| ₹5.8 L/yr - ₹23 L/yr |
Senior Associate
21.4k
salaries
| ₹0.9 L/yr - ₹5.5 L/yr |
Senior Project Engineer
20.2k
salaries
| ₹5 L/yr - ₹19.5 L/yr |
Technical Lead
18.9k
salaries
| ₹8.4 L/yr - ₹36.5 L/yr |
TCS
Infosys
Tesla
Amazon