AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PwC ETL Tester Interview Questions and Answers
PwC ETL Tester Interview Experiences
2 interviews found
Anonymous
Selected
I appeared for an interview in Jun 2025, where I was asked the following questions.
- Q1. Data partitioning
- Q2. Explain the etl process
- Ans.
ETL (Extract, Transform, Load) is a data integration process that involves extracting data from various sources, transforming it, and loading it into a target system.
Extract: Data is collected from different sources like databases, APIs, or flat files. Example: Pulling customer data from a CRM system.
Transform: Data is cleaned, enriched, and transformed into a suitable format. Example: Converting date formats or aggreg...
- Q3. Incremental load
Selected
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Scd and its type
- Ans.
SCD (Slowly Changing Dimension) manages historical data in data warehouses, tracking changes over time.
Type 1: Overwrite old data (e.g., updating a customer's address without keeping the old one).
Type 2: Create a new record for each change (e.g., adding a new row for a customer when their address changes).
Type 3: Store current and previous values in the same record (e.g., adding a 'previous address' column).
Type 4: Use...
- Q2. Highest salary, secound highest salary, find duplicate
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Mar 2021. There were 2 interview rounds.
Global warming
General with companies details
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Three round. Each had one market sizing case study.
- Q2. Layout of your approach is most important. Clearly communicating thoughts, making the interview interactive are key points for any management consulting interview. You dont need an absolute answer. What ma...
What people are saying about PwC
I applied via Campus Placement and was interviewed before May 2021. There were 3 interview rounds.
Internal case of a biscuit manufacturing company. Details about company background, sales, figures are given and based on those 3 questions were asked.
Part 2 of the same case study was asked where the company should go for IPO or expansion in local market. based on the facts, decision and justification had to be given
(1 Question)
- Q1. Tell me about yourself
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. I was asked the basic Core java questions along with the OOPS concepts as well as Springboot and REST API with some database basic questions. The next round will be a managerial round where you will be ask...
Interview Preparation Tips
1. Don’t mention the things in your resume that you are not confident about. Doesn’t matter if your resume is not full of skills, it should be crisp and on-point
2. If you don’t know answer to any of the questions then politely say you are not sure about this question . Its better than giving gibberish answers.
3. Be confident and have faith in yourself.
ALL THE BEST
PwC HR Interview Questions
I applied via Campus Placement and was interviewed before Dec 2020. There were 2 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Situational question
- Q2. Questions more on my final yr project
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Share an instance where you failed and explain how did you overcome it.
- Ans.
I faced a project deadline failure, but I learned to communicate better and prioritize tasks effectively to overcome it.
Missed Deadline: I was responsible for delivering a critical analysis report, but I underestimated the time required for data collection.
Communication: I learned the importance of keeping stakeholders informed about progress and challenges, which helped manage expectations.
Prioritization: I adopted a ...
- Q2. What are your hobbies?
- Q3. Do you have any plans of higher education?
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Resume Based
- Q2. Specific Answers
Priya Cheekala
I appeared for an interview before Sep 2020.
Interview Questionnaire
3 Questions
- Q1. Audit and Financial status definition
- Ans.
Audit and financial status refer to the examination and evaluation of a company's financial records and overall financial health.
Audit involves reviewing financial statements, transactions, and internal controls to ensure accuracy and compliance with regulations.
Financial status refers to a company's overall financial health, including its profitability, liquidity, and solvency.
Both audit and financial status are impor...
- Q2. Difference between Statutory and Internal Audit
- Q3. Questions based on my resume
Interview Preparation Tips
PwC Interview FAQs
Tell us how to improve this page.
PwC Interviews By Designations
- PwC Associate Interview Questions
- PwC Senior Associate Interview Questions
- PwC Consultant Interview Questions
- PwC Associate2 Interview Questions
- PwC Associate Consultant Interview Questions
- PwC Manager Interview Questions
- PwC Senior Consultant Interview Questions
- PwC Technology Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 2 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
PwC ETL Tester Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Associate
19.6k
salaries
|  ₹12.6 L/yr - ₹25.4 L/yr |
|
Associate
15.3k
salaries
| ₹8.1 L/yr - ₹14.6 L/yr |
|
Manager
7.4k
salaries
| ₹23.1 L/yr - ₹41.5 L/yr |
|
Senior Consultant
5k
salaries
| ₹16 L/yr - ₹26.8 L/yr |
|
Associate2
4.7k
salaries
| ₹7.5 L/yr - ₹14 L/yr |
Deloitte
Ernst & Young
Accenture
TCS
- Home >
- Interviews >
- PwC Interview Questions
