AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Wipro
Compare
Filter interviews by
Clear (1)
Wipro ETL Tester Interview Questions and Answers
Wipro ETL Tester Interview Experiences
3 interviews found
Anonymous
I was interviewed in Feb 2025.
(6 Questions)
- Q1. Tell me about your experience
- Q2. What is ETL and its architecture
- Q3. What is difference between delete and drop
- Q4. What are different joins and explain the query for join
- Q5. What is dwh and Data Mart
- Q6. What is Primary key and foreign key.guve me example of same in your current project
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
(4 Questions)
- Q1. What is the Difference Between Drop and Truncate Command ?
- Ans.
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 ...
- Q2. What are the Validations you Perform in your Project ?
- Ans.
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
- Q3. What is Star Schema and Snow flake schema ?
- Ans.
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...
- Q4. What is Fact and Dimension Tables
- Ans.
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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Feb 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Data warehouse,data mart,
- Q2. SQL is the key to clear the interview
Interview Preparation Tips
What people are saying about Wipro
Interview questions from similar companies
I was interviewed before Sep 2016.
Interview Questionnaire
1 Question
- Q1. It was an online technical test. Questions were related to ME outlook, mobile device management , Networking and many more
Interview Preparation Tips
Experience: It was a written English grammar test to analyse how grammatically sound you are.
Tips: Just revise your basic English grammar like prepositions verbs nd essay/paragraph writing
Round: COMMUNICATION SKILLS Round
Experience: In this round they ask you to speak something on the given topic or sometimes group discussion . Basically they test your vocabulary, your thought process, pronunciation, accent and above all confidence.
Tips: Be confident in whatever you speak. Remember if you get nervous you will need with your words .
Round: Technical Interview
Experience: This was an online test and it had 50 questions all objective types.
Tips: Be technically sound. You cannot Google them as these search engines are blocked
College Name: Babu Banarasi Das National Institute Of Technology And Management (BBDNITM)
I was interviewed in Jul 2017.
Interview Questionnaire
1 Question
- Q1. Experience summary and the roles
Interview Preparation Tips
Experience: I was allowed to write a test for 2hrs in that each headings seems to be different and also there is a section heading marks
Duration: 2 hours
Total Questions: 70
Round: Technical Interview
Experience: After finishing i was advised to attend 2nd round in that they ask about the detailed experience of my previous company and finally technical terms question also flows
Skills: Logical And Structured Thinking, Communication And Confidence, Attitude, Psychometric Test, Project Management
Suraj Jain
Interview Questionnaire
3 Questions
- Q1. Why IT if your from other branch
- Ans.
To leverage my skills and passion for technology in a field that offers diverse opportunities for growth and innovation.
Passion for technology and its advancements
Strong analytical and problem-solving skills
Desire to work in a field that offers diverse opportunities for growth and innovation
Transferable skills from other branch that can be applied in IT
Interest in staying updated with the latest trends and developments
- Q2. Tell me about yourself
- Q3. Questions on leadership
Interview Preparation Tips
Experience: Basic programming and aptitude
Tips: Programmes like to check the errors or finding output
Duration: 60 minutes
Total Questions: 40
Round: Technical Interview
Experience: Questions related to your field i was electronics so relating that
Round: HR Interview
Experience: HR is very friendly and asks only about your hobbies and life
Skills: basic c and c++
College Name: SATHYABAMA UNIVERSITY
Interview Preparation Tips
Experience: After my first interview, I was straight away moved to the Final round. They came for the analyst roles and were not actually looking for people with hardcore machine learning. I spoke a lot about a project of mine in which I had extensively used machine learning. The interviewers told that the analysts don't use such stuff and later put me in waiting list though my answers to all his questions in statistics were right.
Tips: It's very important to understand the company's profile and then speak accordingly.
College Name: IIT Kanpur
I was interviewed before May 2016.
Interview Questionnaire
1 Question
- Q1. Why should we hire you
- Ans.
I have the skills, experience, and passion to excel in this role.
I have a strong background in data analysis and have successfully completed numerous projects in the past.
I am detail-oriented and have a proven track record of delivering high-quality work under tight deadlines.
I am a team player and have excellent communication skills, which allows me to collaborate effectively with colleagues and stakeholders.
I was interviewed before Oct 2016.
Interview Questionnaire
1 Question
- Q1. 1. Self introduce. 2. Can do night shift 3. Can go Jaipur if needed 4. Why appoint you 5. What you give to company 6. Some financial question (bookish)
Interview Preparation Tips
Experience: After hr round, then aptitude test which was simple to crack, then operations manager interview, then they keep me waiting till 9 pm to declare That I am selected.
Tips: Go for 11 & 12 class financial management or finance book
Go through about share, debenture, mutual fund, banking system etc.
Round: Test
Experience: Aptitude is easy to crack and at last you have to write essay.
Duration: 1 hour
Total Questions: 60
I was interviewed in Mar 2017.
Interview Questionnaire
2 Questions
- Q1. How many samosas does your college canteen sell?
- Q2. How many chairs are there in your college?
Interview Preparation Tips
Experience: They asked me the question. I worked my way to the answer. The interviewers were helping me in the process. Cannot disclose the answer due to NDA.
Tips: Think simple. Start with basics and ask questions to the interviewer. More information is revealed only if you ask them right questions,
Skills: Knowledge Of MS Office, Proficiency In English
Wipro Interview FAQs
Recently Viewed
INTERVIEWS
Condor Footwear
No Interviews
REVIEWS
Birla White
No Reviews
DESIGNATION
DESIGNATION
INTERVIEWS
Publicis
No Interviews
SALARIES
EY Global Delivery Services ( EY GDS)
REVIEWS
Invenics
No Reviews
REVIEWS
Flipkart
No Reviews
REVIEWS
EY Global Delivery Services ( EY GDS)
No Reviews
REVIEWS
Performics.Convonix
No Reviews
Tell us how to improve this page.
Wipro Interviews By Designations
- Wipro Project Engineer Interview Questions
- Wipro Software Engineer Interview Questions
- Wipro Software Developer Interview Questions
- Wipro Associate Interview Questions
- Wipro Senior Software Engineer Interview Questions
- Wipro Technical Lead Interview Questions
- Wipro Senior Associate Interview Questions
- Wipro Process Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Tester Interview Questions
- Manual Tester Interview Questions
- QA Tester Interview Questions
- Automation Tester Interview Questions
- ETL Test Engineer Interview Questions
- Senior Software Tester Interview Questions
- Selenium Automation Tester Interview Questions
- Game Tester Interview Questions
- Show more
Wipro ETL Tester Interview Process
based on 3 interviews
1 Interview rounds
- Technical Round
ETL Tester Interview Questions from Similar Companies
Fast track your campus placements
Wipro ETL Tester Reviews and Ratings
based on 11 reviews
Rating in categories
|
Project Engineer
32.7k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
23.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
21.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Project Engineer
20.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
18.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Tesla
Amazon
- Home >
- Interviews >
- Wipro Interview Questions >
- Wipro ETL Tester Interview Questions
