Add office photos
Filter interviews by
PwC Technology Specialist Interview Questions and Answers
PwC Technology Specialist Interview Experiences
1 interview found
Anonymous
(1 Question)
- Q1. Basic related to your resume.
(1 Question)
- Q1. Related to location
Interview questions from similar companies
Selected
I applied via Referral and was interviewed in Sep 2024. There were 3 interview rounds.
(4 Questions)
- Q1. Past Experience and work I performed in the Data Analytic team
- Ans.
I have 3 years of experience working in the Data Analytic team where I analyzed large datasets to provide insights and recommendations.
Performed data cleaning and preprocessing tasks to ensure data accuracy
Utilized statistical analysis and machine learning techniques to extract valuable information
Created data visualizations and reports to communicate findings to stakeholders
- Q2. Power BI- DAX functions, Refresh Rates, Cardinality, Uses of several graphs, KPIs, Reporting
- Q3. SQL- Uses of several functions, intermediate logics asked, Eg- Finding 2nd highest salary, function of RankX, Window functions
- Q4. Data Cleansing and ways to analyse data
- Ans.
Data cleansing involves identifying and correcting errors in data to improve its quality. Ways to analyze data include using statistical methods, data visualization, and machine learning algorithms.
Identify and remove duplicate records
Standardize data formats and values
Fill in missing values using imputation techniques
Use data profiling to understand data quality issues
Apply data validation rules to ensure accuracy
Util...
(1 Question)
- Q1. Raw data was provided and a proper PBI report was asked to be designed.
(2 Questions)
- Q1. Expected Salary and why you find yourself fitting for the role?
- Q2. Working in a Big4 can be overwhelming at times, how would you deal with it as you have already worked for one.
- Ans.
I would deal with the overwhelming nature of working in a Big4 by prioritizing tasks, seeking support from colleagues, and practicing self-care.
Prioritize tasks based on deadlines and importance to avoid feeling overwhelmed
Seek support from colleagues or mentors to discuss challenges and brainstorm solutions
Practice self-care activities such as exercise, meditation, or hobbies to manage stress and maintain work-life ba
Skills evaluated in this interview
The topic was given and we were to discuss on it. It seemed farely easy
(3 Questions)
- Q1. Give intro about yourself
- Ans.
I am a technology analyst with a strong background in data analysis and software development.
Experienced in analyzing complex data sets to identify trends and insights
Proficient in programming languages such as Python, SQL, and Java
Skilled in creating data visualizations and reports to communicate findings
Familiar with machine learning algorithms and techniques
Worked on projects involving cloud computing and big data t
- Q2. Fibonacci series code question
- Q3. Project related questions
(3 Questions)
- Q1. Introduction about yourself
- Ans.
I am a technology analyst with a strong background in data analysis and software development.
Experienced in analyzing complex data sets to identify trends and insights
Proficient in programming languages such as Python, SQL, and Java
Skilled in creating data visualizations and reports using tools like Tableau and Power BI
Familiar with machine learning algorithms and techniques for predictive modeling
- Q2. Where do you see yourself in next 5 years
- Ans.
In the next 5 years, I see myself advancing in my career as a Technology Analyst, taking on more responsibilities and contributing to innovative projects.
Continuing to stay updated on the latest technology trends and advancements
Developing strong analytical and problem-solving skills
Leading and collaborating on cross-functional teams
Possibly pursuing further education or certifications in a specialized area
- Q3. Simple Clud related questions
Jatin Yadav
Verabal , Logical Aptitude
English (Vocabulary , Pronunciation)
(1 Question)
- Q1. Sql Questions , Puzzles , Project Discussion
(1 Question)
- Q1. Behavioral Question
Rohan Wadhwa
I applied via campus placement at Dehradun Institute of Technology, Dehradun and was interviewed in Sep 2023. There were 2 interview rounds.
Around 30 questions of verbal,language,aptitude
Topic was OTT VS Cinema
Basic aptitude and coding
(1 Question)
- Q1. What is denormalization and explanation of projects
- Ans.
Denormalization is the process of adding redundant data to a database to improve read performance.
Denormalization involves duplicating data from normalized tables into a single denormalized table.
It can improve query performance by reducing the need for joins and aggregations.
Denormalization is often used in data warehousing and reporting applications.
Examples of denormalization include creating summary tables or addin
(1 Question)
- Q1. Introduction, why ey
I applied via campus placement at Jaypee Institute of Information Technology, Noida and was interviewed in Aug 2024. There were 2 interview rounds.
It was an online assessment consisting of aptitude ques as well as 2 coding ques (easy level)
(2 Questions)
- Q1. Describe yourself and explain your projects
- Ans.
I am a technology analyst with a passion for innovation and problem-solving. I have worked on various projects involving data analysis, software development, and system optimization.
Developed a data analysis tool using Python to streamline decision-making processes
Collaborated with cross-functional teams to implement a new CRM system for improved customer relationship management
Optimized network infrastructure to enhan
- Q2. Explain all layers of the OSI model
- Ans.
The OSI model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven abstraction layers.
Physical Layer: Deals with physical connections and transmission of raw data over a physical medium (e.g. cables, wires)
Data Link Layer: Manages data transfer between devices on the same network (e.g. Ethernet switches)
Network Layer: Handles routing of data packets between dif...
Skills evaluated in this interview
Had a lot of basic level questions, nothing particularly worthwhile. Really east and no real need to prepare anything.
The coding round had a leetocode easy level question which you could code in either python or java followed by MCQs regarding SQL as well as SQL query writing.
Interview Preparation Tips
I applied via LinkedIn
(2 Questions)
- Q1. Resume Based questions
- Q2. ITGCS, IT Audit, ITGC and ITAC Testing
I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.
60 Apti and tech mcqs followed by 2 very easy string and array questions
(3 Questions)
- Q1. What is polymorphism
- Ans.
Polymorphism is the ability of a single function or method to operate on different types of data.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).
Example: Inheritance in object-oriented programming languages like Java allows for polymorphism.
- Q2. Swap two numbers in c++
- Ans.
Swap two numbers in C++ using a temporary variable
Declare two variables a and b
Create a temporary variable temp
Assign the value of a to temp
Assign the value of b to a
Assign the value of temp to b
- Q3. SQL join query syntax and example
- Ans.
SQL join query syntax and example
SQL join is used to combine rows from two or more tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Skills evaluated in this interview
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
- Technology Analyst Interview Questions
- Technology Consultant Interview Questions
- Business Technology Analyst Interview Questions
- Associate Information Technology Consultant Interview Questions
- Associate Technology Interview Questions
- Assistant Manager Information Technology Interview Questions
- Technology Architect Interview Questions
- Technology Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
PwC Technology Specialist Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Associate
14.8k
salaries
|  ₹8 L/yr - ₹30 L/yr |
|
Associate
12.8k
salaries
| ₹4.7 L/yr - ₹16 L/yr |
|
Manager
6.6k
salaries
| ₹13.8 L/yr - ₹44.8 L/yr |
|
Senior Consultant
4.4k
salaries
| ₹9 L/yr - ₹32 L/yr |
|
Associate2
4.1k
salaries
| ₹4.5 L/yr - ₹16.6 L/yr |
Deloitte
Ernst & Young
Accenture
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- PwC Interview Questions >
- PwC Technology Specialist Interview Questions
