Backend Engineer • Behavioral • medium

Describe a situation where you had to push back on a client's or product manager's request because it would compromise system security or performance.

#Conflict Resolution #Security #Integrity

Practice

Backend Engineer • Behavioral • easy

PwC values 'Global Acumen'. Tell me about a time you worked with a distributed team across different time zones to deliver a backend feature.

#Collaboration #Remote Work #Agile

Practice

Backend Engineer • Behavioral • medium

Tell me about a time you identified a bottleneck in an existing legacy system and took the initiative to refactor it.

#Initiative #Performance Optimization #Legacy Code

Practice

Backend Engineer • Behavioral • medium

How do you handle changing requirements from a client midway through a sprint?

#Agile #Adaptability #Client Management

Practice

Backend Engineer • Behavioral • medium

Describe a time you failed to meet a deadline for a critical API delivery. What happened and how did you communicate it?

#Accountability #Communication #Failure

Practice

Backend Engineer • Behavioral • easy

Tell me about a time you mentored a junior developer on backend best practices.

#Mentorship #Code Review #Team Building

Practice

Backend Engineer • Behavioral • easy

Why PwC? How does our technology consulting practice align with your career goals?

#Career Goals #Company Knowledge #Motivation

Practice

Backend Engineer • Behavioral • medium

Tell me about a time you had to explain a complex technical backend issue to a non-technical stakeholder or client.

#Communication #Stakeholder Management #Consulting

Practice

Backend Engineer • Coding • medium

Write a SQL query to find the second highest salary from an Employee table.

#SQL #Database Queries

Practice

Backend Engineer • Coding • easy

Given an array of integers, return indices of the two numbers such that they add up to a specific target.

#Arrays #Hash Map

Practice

Backend Engineer • Coding • easy

Write a function to check if a given string containing brackets is valid (properly closed and nested).

#Strings #Stack

Practice

Backend Engineer • Coding • medium

Find the lowest common ancestor of two nodes in a binary search tree.

#Trees #Binary Search Tree #Recursion

Practice

Backend Engineer • Coding • medium

Given an array of strings, group the anagrams together.

#Strings #Hash Map #Sorting

Practice

Backend Engineer • Coding • easy

Write a function to reverse a singly linked list.

#Linked List #Pointers

Practice

Backend Engineer • Coding • medium

Given a string, find the length of the longest substring without repeating characters.

#Strings #Sliding Window #Hash Map

Practice

Backend Engineer • Coding • medium

Write a SQL query to find all departments that have less than 3 employees.

#SQL #Aggregation #Joins

Practice

Backend Engineer • Coding • medium

Implement a LRU (Least Recently Used) Cache.

#Design #Hash Map #Doubly Linked List

Practice

Backend Engineer • Coding • medium

Given a list of intervals, merge all overlapping intervals.

#Arrays #Sorting

Practice

Backend Engineer • System Design • medium

Design a notification system that sends email, SMS, and push notifications to users based on audit event triggers.

#Asynchronous Processing #Microservices #Third-party APIs

Practice

Backend Engineer • System Design • hard

Design a scalable document management system for auditing purposes where users can upload, search, and retrieve large PDF files.

#Storage #Search #Microservices #Security

Practice

Backend Engineer • System Design • medium

Design a rate limiter for a public-facing API to prevent abuse from third-party consumers.

#API Gateway #Caching #Algorithms

Practice

Backend Engineer • System Design • hard

How would you design a distributed logging and monitoring system for a microservices architecture spanning multiple cloud regions?

#Observability #Logging #Distributed Systems

Practice

Backend Engineer • System Design • hard

Design an ETL pipeline that ingests daily transaction files from multiple financial clients, sanitizes the data, and loads it into a data warehouse.

#Data Engineering #ETL #Batch Processing

Practice

Backend Engineer • System Design • medium

Design a URL shortening service like Bitly. Focus on the database schema and read/write scaling.

#Hashing #Database Scaling #Caching

Practice

Backend Engineer • System Design • medium

A client's e-commerce backend is experiencing database timeouts during peak holiday sales. How would you architect a caching layer to resolve this?

#Caching #Performance #Architecture

Practice

Backend Engineer • Technical • medium

What are the ACID properties in a database, and how do they apply to distributed transactions?

#SQL #Transactions #Distributed Systems

Practice

Backend Engineer • Technical • hard

Explain how you would secure a RESTful API built for a financial services client.

#API Security #OAuth2 #JWT #HTTPS

Practice

Backend Engineer • Technical • medium

How does Spring Boot handle dependency injection, and why is it beneficial for enterprise applications?

#Java #Spring Boot #Design Patterns

Practice

Backend Engineer • Technical • medium

Explain the difference between monolithic and microservices architectures. When would you recommend a client migrate to microservices?

#Microservices #System Architecture #Scalability

Practice

Backend Engineer • Technical • medium

Describe your experience with CI/CD pipelines. How would you automate the deployment of a Dockerized backend service?

#CI/CD #Docker #Automation

Practice

Backend Engineer • Technical • hard

How do you ensure idempotent operations in a distributed backend system?

#Distributed Systems #API Design #Idempotency

Practice

Backend Engineer • Technical • medium

What is the N+1 query problem in ORMs like Hibernate or Entity Framework, and how do you resolve it?

#ORM #Performance #SQL

Practice

Backend Engineer • Technical • medium

Explain the concept of a Dead Letter Queue (DLQ) in message brokers like Kafka or RabbitMQ.

#Asynchronous Processing #Kafka #RabbitMQ #Error Handling

Practice

Backend Engineer • Technical • medium

How do you implement pagination and filtering in a REST API returning large datasets?

#REST #Performance #API Design

Practice

Backend Engineer • Technical • hard

Describe the differences between optimistic and pessimistic locking in database concurrency control.

#Concurrency #Databases #Performance

Practice

Cloud Engineer • Behavioral • medium

Tell me about a time you had to explain a complex cloud architecture to a non-technical client stakeholder.

#Stakeholder Management #Communication #Consulting

Practice

Cloud Engineer • Behavioral • hard

As a consultant, you are assigned to a project where the client's internal IT team is hostile to the cloud migration. How do you build trust?

#Change Management #Empathy #Consulting

Practice

Cloud Engineer • Behavioral • medium

Tell me about a time you disagreed with a senior architect or manager on a technical design. How did you resolve it?

#Conflict Resolution #Communication #Leadership

Practice

Cloud Engineer • Behavioral • easy

Describe a time when you had to quickly learn a new cloud technology or tool to deliver a project for a client.

#Learning #Adaptability #Consulting

Practice

Cloud Engineer • Behavioral • medium

Have you ever missed a project deadline during a cloud migration? What happened and how did you communicate it to the client/manager?

#Accountability #Communication #Time Management

Practice

Cloud Engineer • Behavioral • medium

Tell me about a time you discovered a significant security vulnerability or misconfiguration in a client's cloud environment. How did you handle it?

#Security #Incident Response #Communication

Practice

Cloud Engineer • Behavioral • medium

Describe a situation where a client pushed back on your proposed cloud security controls because they felt it slowed down development.

#Security #Client Management #Agile

Practice

Cloud Engineer • Coding • easy

Write a bash script to parse an Nginx access log and output the top 5 IP addresses with the most 404 errors.

#Bash #Linux #Log Parsing

Practice

Cloud Engineer • Coding • medium

Write a Python function that validates whether a given string is a properly formatted JSON IAM policy document with required 'Effect' and 'Action' fields.

#Python #JSON #IAM

Practice

Cloud Engineer • Coding • easy

Given an array of integers representing daily cloud compute costs, write a function to find the maximum cost increase between any two consecutive days.

#Arrays #Logic #FinOps

Practice

Cloud Engineer • Coding • medium

Write a script to query a cloud provider's REST API to list all users who haven't rotated their access keys in 90 days.

#API #Scripting #Security

Practice

Cloud Engineer • Coding • medium

Write a Python script using Boto3 (or Azure SDK) to find and delete all unattached EBS volumes or managed disks older than 30 days.

#Python #Cloud SDK #Cost Optimization

Practice

Cloud Engineer • System Design • medium

Design a centralized logging and monitoring solution for a multi-account AWS environment using cloud-native tools.

#Observability #Logging #Multi-Account Strategy

Practice

Cloud Engineer • System Design • hard

A client wants to migrate a legacy monolithic application to a microservices architecture on Kubernetes. Walk me through your migration strategy.

#Migration #Microservices #Kubernetes #Strangler Fig Pattern

Practice

Cloud Engineer • System Design • hard

Design a secure 'Landing Zone' architecture for a healthcare client that complies with HIPAA regulations.

#Landing Zone #Security #Compliance #Healthcare

Practice

Cloud Engineer • System Design • hard

Design a serverless data ingestion pipeline that processes millions of IoT sensor events per minute and stores them for analytics.

#Serverless #Data Engineering #Streaming

Practice

Cloud Engineer • System Design • hard

Design a secure, multi-region active-active cloud architecture for a financial services client with strict data residency requirements.

#High Availability #Disaster Recovery #Compliance #Networking

Practice

Cloud Engineer • System Design • medium

A retail client expects a 10x traffic spike during Black Friday. How do you design their cloud infrastructure to handle this elastically?

#Scalability #Auto-scaling #Performance

Practice

Cloud Engineer • System Design • hard

Design a Disaster Recovery (DR) strategy for a mission-critical database with an RPO of 5 minutes and an RTO of 1 hour.

#Disaster Recovery #Databases #RPO/RTO

Practice

Cloud Engineer • Technical • medium

How do you manage Terraform state files in a multi-developer environment, and what happens if the state file gets corrupted?

#Terraform #State Management #Collaboration

Practice

Cloud Engineer • Technical • medium

What are Terraform modules, and what are the best practices for versioning and sharing them across enterprise teams?

#Terraform #Modularity #Best Practices

Practice

Cloud Engineer • Technical • easy

Explain the difference between Docker CMD and ENTRYPOINT instructions.

#Docker #Containers

Practice

Cloud Engineer • Technical • hard

How do you implement least privilege access in AWS IAM or Azure RBAC for a CI/CD pipeline deploying infrastructure?

#IAM #RBAC #CI/CD #Security

Practice

Cloud Engineer • Technical • hard

How do you handle database schema migrations in an automated CI/CD pipeline without causing downtime?

#Databases #CI/CD #Zero Downtime

Practice

Cloud Engineer • Technical • medium

What is your approach to handling secrets and sensitive data in a Terraform-managed infrastructure?

#Terraform #Secrets Management #DevSecOps

Practice

Cloud Engineer • Technical • medium

Explain the concept of Blue/Green deployments. How would you implement this using AWS CodePipeline or Azure DevOps?

#Deployment Strategies #CI/CD #DevOps

Practice

Cloud Engineer • Technical • easy

What are the key differences between a relational database and a NoSQL database in terms of scaling and consistency?

#SQL #NoSQL #CAP Theorem

Practice

Cloud Engineer • Technical • medium

Compare and contrast serverless compute (e.g., AWS Fargate, Azure Container Instances) with managed Kubernetes (EKS/AKS). How do you advise a client on which to choose?

#Serverless #Kubernetes #Containers

Practice

Cloud Engineer • Technical • medium

Explain how VPC Peering works and its limitations. How does AWS Transit Gateway or Azure Virtual WAN solve these limitations?

#VPC #Networking #Transit Gateway

Practice

Cloud Engineer • Technical • medium

How do you troubleshoot a 'CrashLoopBackOff' error in a Kubernetes pod?

#Kubernetes #Debugging #Containers

Practice

Cloud Engineer • Technical • medium

How do you optimize cloud costs for a client who has over-provisioned their EC2/VM instances?

#Cost Optimization #Compute #FinOps

Practice

Cloud Engineer • Technical • easy

Explain the difference between an Application Load Balancer and a Network Load Balancer. When would you use each in an enterprise migration?

#Load Balancing #OSI Model #AWS/Azure Networking

Practice

Cloud Engineer • Technical • hard

What is a Service Mesh, and why might a client need one when adopting Kubernetes?

#Kubernetes #Service Mesh #Microservices

Practice

Cloud Engineer • Technical • medium

Explain the role of an Ingress Controller in Kubernetes. How does it differ from a LoadBalancer service?

#Kubernetes #Networking #Ingress

Practice

Cloud Engineer • Technical • hard

How do you enforce compliance and governance rules across multiple cloud accounts (e.g., using AWS Organizations/SCP or Azure Policy)?

#Governance #Compliance #Multi-Account Strategy

Practice

Data Engineer • Behavioral • medium

Describe a situation where a client changed the requirements for a data pipeline midway through the sprint. How did you handle it?

#Agile #Adaptability #Consulting

Practice

Data Engineer • Behavioral • easy

Why do you want to work as a Data Engineer at a consulting firm like PwC specifically, compared to working at a product-based company?

#Motivation #Consulting #PwC Professional

Practice

Data Engineer • Behavioral • medium

Describe a time you had to work with a difficult team member or client who was resistant to adopting a new data engineering tool or process.

#Conflict Resolution #Change Management #Communication

Practice

Data Engineer • Behavioral • medium

Tell me about a time you had to explain a complex technical data issue to a non-technical client stakeholder.

#Communication #Client Management #PwC Professional

Practice

Data Engineer • Behavioral • medium

Tell me about a time you identified a data quality issue that others missed. What was the impact and how did you resolve it?

#Attention to Detail #Data Quality #Problem Solving

Practice

Data Engineer • Coding • medium

Given a list of dictionaries representing nested JSON data from a client API, write a Python script to flatten the dictionaries into a single level.

#Python #Recursion #Data Parsing #JSON

Practice

Data Engineer • Coding • medium

Write a Python script using Pandas to merge two large datasets (e.g., clients and transactions), handle missing values by imputing the mean, and output aggregated metrics by region.

#Python #Pandas #Data Cleansing #Aggregation

Practice

Data Engineer • Coding • medium

Write a SQL query to find the top 3 highest paid employees in each department. If there is a tie, they should have the same rank.

#Window Functions #DENSE_RANK #Joins

Practice

Data Engineer • Coding • hard

Write a Python generator function to process a massive 50GB log file line by line without loading the entire file into memory, extracting specific error codes.

#Python #Generators #Memory Management #File I/O

Practice

Data Engineer • Coding • medium

Write a SQL query to calculate the 7-day rolling average of daily sales for a retail company.

#Window Functions #Moving Average #Date Functions

Practice

Data Engineer • Coding • hard

Given a table of client project assignments with start and end dates, write a SQL query to identify any overlapping date ranges for the same consultant.

#Self Joins #Date Functions #Complex Logic

Practice

Data Engineer • Coding • easy

Write a Python function to check if a given string is a valid palindrome, ignoring case and all non-alphanumeric characters.

#Python #String Manipulation #Two Pointers

Practice

Data Engineer • Coding • medium

Write PySpark code to read a CSV file from Azure Data Lake, filter out records where the 'amount' column is null, and write the output back as Parquet, partitioned by 'transaction_date'.

#PySpark #Data I/O #Partitioning

Practice

Data Engineer • Coding • medium

Write a Python script to interact with a REST API, handle pagination to retrieve all records, and load the extracted data into a local SQLite database.

#Python #REST APIs #Pagination #SQLite

Practice

Data Engineer • Coding • medium

Write a SQL query to find the second highest salary in an employee table without using the LIMIT, TOP, or FETCH keywords.

#Subqueries #Aggregation #Max Function

Practice

Data Engineer • System Design • hard

Design a real-time streaming pipeline using Kafka and Spark Structured Streaming to process IoT sensor data and detect anomalies.

#Streaming #Kafka #Spark Structured Streaming #Architecture

Practice

Data Engineer • System Design • medium

How would you design a data quality framework to validate incoming data before it lands in the gold layer of a Medallion architecture?

#Data Quality #Medallion Architecture #Data Governance

Practice

Data Engineer • System Design • hard

Design an ETL pipeline for a retail client that ingests 50GB of daily transaction data, cleanses it, and makes it available for BI reporting within 1 hour of store closing.

#Architecture #Batch Processing #Cloud Storage #Data Warehousing

Practice

Data Engineer • System Design • hard

Design a data lakehouse architecture using Databricks for a financial services firm that needs both nightly batch reporting and near-real-time fraud detection.

#Lakehouse #Databricks #Lambda Architecture #Streaming

Practice

Data Engineer • Technical • hard

Explain Spark's Catalyst Optimizer. How does it improve query execution plans?

#PySpark #Catalyst Optimizer #Under the Hood

Practice

Data Engineer • Technical • easy

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() with a practical data engineering example.

#Window Functions #Analytical Functions

Practice

Data Engineer • Technical • hard

How would you approach optimizing a slow-running SQL query in a distributed data warehouse like Snowflake or Azure Synapse?

#Performance Tuning #Execution Plans #Indexing #Partitioning

Practice

Data Engineer • Technical • medium

Explain the difference between transformations and actions in PySpark. Why is this distinction important for performance?

#PySpark #Lazy Evaluation #DAG

Practice

Data Engineer • Technical • hard

You are joining a massive transaction table with a smaller client table in PySpark, and the job is failing due to OutOfMemory errors. How do you handle this data skewness?

#PySpark #Optimization #Broadcast Joins #Salting

Practice

Data Engineer • Technical • medium

What is the difference between repartition() and coalesce() in Spark? When would you use each in a data pipeline?

#PySpark #Data Shuffling #Partitioning

Practice

Data Engineer • Technical • medium

Describe how you would set up an Azure Data Factory (ADF) pipeline to copy data from an on-premise SQL Server to Azure Data Lake Storage (ADLS).

#Azure Data Factory #Integration Runtime #ADLS

Practice

Data Engineer • Technical • hard

How do you implement incremental loading (Change Data Capture) in a cloud ETL tool like Azure Data Factory or AWS Glue?

#ETL #CDC #Watermarking

Practice

Data Engineer • Technical • medium

Explain Slowly Changing Dimensions (SCD). How would you implement an SCD Type 2 in a modern cloud data warehouse?

#Data Warehousing #SCD #Dimensional Modeling

Practice

Data Engineer • Technical • easy

What is the difference between a Star Schema and a Snowflake Schema? Which do you prefer for a cloud data warehouse and why?

#Data Warehousing #Schema Design #Normalization

Practice

Data Engineer • Technical • medium

What are the different types of triggers available in Azure Data Factory, and when would you use a Tumbling Window trigger over a Schedule trigger?

#Azure Data Factory #Scheduling #Orchestration

Practice

Data Engineer • Technical • medium

Explain the concept of the Medallion Architecture (Bronze, Silver, Gold). What specific transformations happen at each stage?

#Medallion Architecture #Data Lakehouse #Data Modeling

Practice

Data Engineer • Technical • hard

How do you handle schema evolution in Delta Lake or Apache Iceberg when upstream source systems unexpectedly add or remove columns?

#Delta Lake #Schema Evolution #Data Governance

Practice

Data Engineer • Technical • medium

What is the difference between a clustered and non-clustered index? How does indexing affect ETL performance?

#Indexing #Performance Tuning #Database Internals

Practice

Data Engineer • Technical • medium

Explain the difference between Azure Synapse Analytics and Azure Databricks. When would you recommend one over the other to a client?

#Azure #Databricks #Synapse #Consulting

Practice

Data Engineer • Technical • medium

How do you manage CI/CD for data pipelines? Describe the deployment process for ADF or Databricks notebooks across Dev, QA, and Prod environments.

#CI/CD #Git #Azure DevOps #Deployment

Practice

Data Scientist • Behavioral • easy

Describe a time when you had to learn a completely new technology or framework to deliver a project on a tight deadline.

#Continuous Learning #Agile #Time Management

Practice

Data Scientist • Behavioral • medium

Explain how a Random Forest model works to a non-technical Audit Partner who is skeptical about using AI for risk assessment.

#Stakeholder Management #Model Explainability #Consulting Skills

Practice

Data Scientist • Behavioral • hard

You are building a credit risk model. The client insists on using a complex deep learning model, but regulations require strict explainability. How do you proceed?

#Model Explainability #Client Management #Regulatory Compliance

Practice

Data Scientist • Behavioral • easy

Why PwC? With your technical background, why are you interested in consulting rather than working for a tech company or a startup?

#Career Goals #Consulting #Motivation

Practice

Data Scientist • Behavioral • hard

Describe a situation where a model you built failed or underperformed in production. What was the root cause and how did you fix it?

#Failure #Debugging #Continuous Improvement

Practice

Data Scientist • Behavioral • medium

You are managing a data science project where the client keeps adding new feature requests (scope creep). How do you manage this while keeping the client happy?

#Scope Management #Client Communication #Agile

Practice

Data Scientist • Behavioral • medium

Tell me about a time you discovered a significant data quality issue in a client's dataset right before a major deliverable. How did you handle it?

#Data Quality #Time Management #Client Communication

Practice

Data Scientist • Behavioral • medium

Tell me about a time you disagreed with a senior team member or Manager regarding the technical approach to a data science problem.

#Conflict Resolution #Leadership #Communication

Practice

Data Scientist • Coding • medium

Write a SQL query to find the top 3 highest-value transactions for each client in our audit database, including ties.

#Window Functions #DENSE_RANK #Data Aggregation

Practice

Data Scientist • Coding • medium

Write a Python function using Pandas to identify and merge duplicate client records based on fuzzy matching of company names and exact matching of tax IDs.

#Pandas #Fuzzy Matching #Data Cleaning

Practice

Data Scientist • Coding • medium

Given a table of employee timesheets, write a SQL query to calculate the rolling 7-day average of billable hours per consultant.

#Window Functions #Time Series #Moving Averages

Practice

Data Scientist • Coding • medium

Write a Python script to parse a directory of JSON files containing nested audit logs, extract specific error codes, and output a flattened CSV.

#Python #JSON Parsing #File I/O #Data Flattening

Practice

Data Scientist • Coding • medium

Write a SQL query to find the month-over-month percentage growth in revenue for each product category.

#LAG Function #CTEs #Percentage Calculation

Practice

Data Scientist • Coding • easy

Write a Python function that takes a list of strings representing financial document titles and returns the longest common prefix among them.

#Strings #Arrays #Optimization

Practice

Data Scientist • Coding • hard

Write a SQL query to identify 'island' periods of continuous active subscription for users, given a table of start and end dates that may overlap.

#Gaps and Islands #Advanced SQL #Self Joins

Practice

Data Scientist • Coding • medium

Write a Python script using PySpark to read a 10TB CSV file from an S3 bucket, filter out invalid records, and aggregate total sales by region.

#PySpark #Distributed Computing #Data Aggregation

Practice

Data Scientist • Coding • hard

Write a SQL query to find the median salary of employees in each department without using the built-in MEDIAN() function.

#Percentiles #Window Functions #Math

Practice

Data Scientist • Coding • easy

Implement a binary search algorithm in Python to find a specific transaction ID in a sorted list of 10 million records.

#Binary Search #Time Complexity #Python

Practice

Data Scientist • System Design • hard

Design an anomaly detection system for a client's IT network to identify potential cybersecurity breaches in real-time.

#Anomaly Detection #Streaming Data #Kafka #Unsupervised Learning

Practice

Data Scientist • System Design • hard

Design a scalable architecture on Azure to process daily batches of 50GB of retail transaction data, run a forecasting model, and update a PowerBI dashboard.

#Azure #Data Factory #Databricks #Batch Processing

Practice

Data Scientist • System Design • hard

Design an end-to-end document extraction system using Generative AI and RAG to pull key clauses from thousands of PDF vendor contracts.

#NLP #RAG #LLMs #Vector Databases #OCR

Practice

Data Scientist • System Design • medium

A client wants to use a Large Language Model (LLM) to automatically draft responses to customer complaints. What are the primary risks, and how do you mitigate them?

#LLMs #Generative AI #Risk Management #Hallucinations

Practice

Data Scientist • System Design • medium

Design a churn prediction pipeline for a telecommunications client. How do you ensure the model's predictions are actionable for their marketing team?

#Classification #Pipeline Design #Actionable Insights #SHAP

Practice

Data Scientist • System Design • medium

Design a recommendation engine for a wealth management firm to suggest investment products to high-net-worth individuals.

#Recommendation Systems #Collaborative Filtering #Cold Start Problem

Practice

Data Scientist • System Design • hard

Design a system to match millions of incoming bank transactions to open invoices in an ERP system to automate account reconciliation.

#Record Linkage #Optimization #ERP #Heuristics

Practice

Data Scientist • Technical • medium

A client provides you with a dataset where 40% of the values in a critical column are missing. Walk me through your strategy for handling this.

#Missing Data #Imputation #EDA

Practice

Data Scientist • Technical • medium

What is the difference between L1 and L2 regularization, and in what specific consulting scenario would you choose one over the other?

#Regularization #Lasso #Ridge #Feature Selection

Practice

Data Scientist • Technical • medium

Explain the concept of Data Drift and Concept Drift. How would you monitor for these in a deployed pricing optimization model?

#Model Monitoring #Data Drift #Concept Drift #MLOps

Practice

Data Scientist • Technical • medium

How do you evaluate the performance of an unsupervised clustering model, such as K-Means, when you don't have ground truth labels?

#Clustering #Unsupervised Learning #Evaluation Metrics

Practice

Data Scientist • Technical • medium

What is the curse of dimensionality, and how does it affect distance-based algorithms like KNN? How do you mitigate it?

#Dimensionality Reduction #KNN #PCA #Feature Engineering

Practice

Data Scientist • Technical • hard

Explain the architecture and mathematical intuition behind Transformers. Why have they largely replaced RNNs/LSTMs in NLP tasks?

#Transformers #Attention Mechanism #NLP #Deep Learning

Practice

Data Scientist • Technical • hard

Given a dataset of financial transactions with a 0.1% fraud rate, how would you build and evaluate a machine learning model to detect fraudulent activities for a banking client?

#Imbalanced Data #Fraud Detection #Evaluation Metrics #SMOTE

Practice

Data Scientist • Technical • easy

How would you explain the concept of a p-value to a client who wants to know if their new marketing campaign was successful?

#Hypothesis Testing #A/B Testing #Communication

Practice

Data Scientist • Technical • medium

What are the assumptions of linear regression? How would you test for them, and what would you do if the homoscedasticity assumption is violated?

#Linear Regression #Statistical Assumptions #Heteroscedasticity

Practice

Data Scientist • Technical • hard

How does Gradient Boosting differ from AdaBoost? Explain the mathematical intuition behind how XGBoost optimizes its objective function.

#Ensemble Methods #XGBoost #Optimization #Mathematics

Practice

DevOps Engineer • Behavioral • medium

Describe a time when you had to optimize cloud infrastructure costs for a project. What steps did you take?

#Cost Optimization #FinOps #AWS/Azure

Practice

DevOps Engineer • Behavioral • easy

Describe your experience with Agile methodologies. How do you integrate DevOps practices into two-week sprint cycles?

#Agile #Scrum #SDLC

Practice

DevOps Engineer • Behavioral • medium

Tell me about a time you had to deliver a critical project under a very tight deadline. How did you prioritize your tasks?

#Time Management #Prioritization #Agile

Practice

DevOps Engineer • Behavioral • medium

Tell me about a time you had to convince a traditional IT operations team or client to adopt a DevOps culture and CI/CD practices. How did you handle their resistance?

#Communication #Agile #Change Management #Consulting

Practice

DevOps Engineer • Behavioral • medium

Tell me about a time you made a mistake that caused a production outage. How did you resolve it, and what was the post-mortem process?

#Incident Management #Accountability #SRE

Practice

DevOps Engineer • Behavioral • medium

PwC often works with legacy enterprise clients. How do you explain the value of Infrastructure as Code to a CIO who is used to manual server provisioning?

#Communication #Consulting #IaC

Practice

DevOps Engineer • Coding • medium

Write a Python script to interact with the AWS EC2 API, find all instances missing a specific mandatory tagging standard, and output their IDs to a CSV.

#Python #AWS #Boto3 #Automation

Practice

DevOps Engineer • Coding • medium

Write a Bash script to find and delete all files in a directory older than 30 days, but exclude files with a '.log' extension.

#Bash #Linux

Practice

DevOps Engineer • Coding • medium

Write a Python script that connects to a PostgreSQL database, executes a query to fetch user data, and exports the result to a JSON file.

#Python #SQL #JSON

Practice

DevOps Engineer • Coding • easy

Given an array of integers, write a script to find the two numbers that add up to a specific target. (Two Sum)

#Python #Data Structures

Practice

DevOps Engineer • Coding • medium

Write a declarative Jenkinsfile that checks out code, runs unit tests, builds a Docker image, and pushes it to an Azure Container Registry.

#Jenkins #Docker #Groovy

Practice

DevOps Engineer • Coding • medium

Write a Python function to parse a large Nginx access log file and return the top 5 IP addresses with the most 404 errors.

#Python #Log Parsing #Data Structures

Practice

DevOps Engineer • Coding • easy

Write a Bash script that checks the disk usage of a Linux server and sends an alert to a Slack webhook if usage exceeds 85%.

#Bash #Linux #Monitoring

Practice

DevOps Engineer • System Design • hard

How would you implement a Blue-Green deployment strategy using AWS services (e.g., Route53, ALB, ECS/EKS)?

#AWS #Deployment Strategies #Networking

Practice

DevOps Engineer • System Design • medium

How do you monitor a microservices architecture? What metrics are most important, and what tools would you use?

#Prometheus #Grafana #Observability

Practice

DevOps Engineer • System Design • hard

Design an automated disaster recovery (DR) strategy for a mission-critical application hosted on Azure.

#Azure #Disaster Recovery #RPO/RTO

Practice

DevOps Engineer • System Design • hard

Design a highly available, fault-tolerant web application architecture on Azure. Include networking, compute, database, and load balancing components.

#Azure #High Availability #Networking

Practice

DevOps Engineer • System Design • hard

Design a centralized logging solution for a multi-region AWS deployment using the ELK stack or native AWS services.

#AWS #Logging #Elasticsearch

Practice

DevOps Engineer • System Design • hard

Walk me through how you would design a secure CI/CD pipeline using Azure DevOps for a financial services client with strict compliance requirements.

#Azure DevOps #DevSecOps #Compliance #CI/CD

Practice

DevOps Engineer • System Design • hard

A client wants to migrate their on-premise monolithic application to microservices on AWS. How do you plan and execute the infrastructure provisioning?

#AWS #Cloud Migration #Terraform #Microservices

Practice

DevOps Engineer • Technical • hard

What is a Service Mesh, and why might you introduce Istio into a Kubernetes cluster?

#Kubernetes #Istio #Networking

Practice

DevOps Engineer • Technical • easy

What is the difference between Docker COPY and ADD commands in a Dockerfile? Which is preferred and why?

#Docker #Best Practices

Practice

DevOps Engineer • Technical • medium

How do you handle configuration drift in infrastructure managed by Terraform?

#Terraform #Operations #Governance

Practice

DevOps Engineer • Technical • hard

Describe how you integrate security scanning (SAST/DAST) and vulnerability checks into a Jenkins pipeline without severely slowing down developer feedback loops.

#Jenkins #Security #CI/CD

Practice

DevOps Engineer • Technical • medium

A client's production Kubernetes pod is repeatedly entering a CrashLoopBackOff state. Walk me through your exact troubleshooting steps.

#Kubernetes #Linux #Debugging

Practice

DevOps Engineer • Technical • medium

What is the purpose of an Ansible Inventory file, and how can you make it dynamic for cloud environments?

#Ansible #Automation #Cloud

Practice

DevOps Engineer • Technical • easy

Explain the difference between an Application Load Balancer (ALB) and a Network Load Balancer (NLB) in AWS. When do you use each?

#AWS #Networking

Practice

DevOps Engineer • Technical • medium

Explain the difference between a Deployment and a StatefulSet in Kubernetes. When would you use one over the other?

#Kubernetes #Architecture #Microservices

Practice

DevOps Engineer • Technical • medium

How do you ensure that your Docker images are minimal and secure before deploying them to production?

#Docker #Security #Optimization

Practice

DevOps Engineer • Technical • medium

Explain the concept of GitOps. How does it differ from traditional CI/CD pipelines?

#GitOps #ArgoCD #Kubernetes

Practice

DevOps Engineer • Technical • medium

How do you manage and secure Terraform state files when working in a multi-developer enterprise environment?

#Terraform #Security #State Management

Practice

DevOps Engineer • Technical • hard

How do you handle database schema migrations in an automated CI/CD pipeline without causing downtime?

#Databases #Automation #Zero-Downtime

Practice

DevOps Engineer • Technical • medium

How do you securely manage secrets like database passwords or API keys in a Kubernetes environment?

#Kubernetes #Secrets Management #HashiCorp Vault

Practice

DevOps Engineer • Technical • medium

What are Terraform modules, and how do you version control and share them across different projects in an enterprise?

#Terraform #Git #Version Control

Practice

DevOps Engineer • Technical • medium

Explain how Kubernetes RBAC works. How would you restrict a developer team to only have read access to a specific namespace?

#Kubernetes #IAM #RBAC

Practice

Frontend Engineer • Behavioral • easy

Tell me about a time you had to learn a new frontend framework or library very quickly to deliver a consulting project.

#Continuous Learning #Agile #Problem Solving

Practice

Frontend Engineer • Behavioral • medium

Tell me about a time you had to push back on a client or stakeholder who requested a UI feature that was technically unfeasible within the deadline.

#Stakeholder Management #Communication #Negotiation

Practice

Frontend Engineer • Behavioral • medium

Describe a situation where you had to explain a complex technical frontend issue (e.g., state management bugs or build pipeline failures) to a non-technical partner.

#Communication #Leadership #Client Facing

Practice

Frontend Engineer • Behavioral • medium

Have you ever disagreed with a senior engineer or architect on a frontend architecture decision? How did you handle it?

#Conflict Resolution #Teamwork #Professionalism

Practice

Frontend Engineer • Behavioral • medium

How do you ensure that sensitive financial data is not exposed or cached improperly on the client side in the applications you build?

#Data Privacy #Best Practices #Compliance

Practice

Frontend Engineer • Behavioral • easy

Tell me about your experience working with global, cross-functional teams (e.g., backend in India, design in the UK, client in the US).

#Collaboration #Time Management #Diversity

Practice

Frontend Engineer • Behavioral • medium

Describe a time you had to deliver a frontend project under a very tight deadline. Did you compromise on code quality?

#Time Management #Prioritization #Quality Assurance

Practice

Frontend Engineer • Behavioral • easy

Tell me about a time you mentored a junior frontend developer. How did you approach their growth?

#Mentorship #Code Reviews #Team Building

Practice

Frontend Engineer • Behavioral • medium

How do you handle changing requirements mid-sprint, especially when a client suddenly pivots their business logic?

#Agile Methodology #Flexibility #Client Management

Practice

Frontend Engineer • Behavioral • easy

What is the frontend technical achievement you are most proud of and why?

#Passion #Innovation #Impact

Practice

Frontend Engineer • Coding • easy

Write a function to flatten a deeply nested array without using the built-in Array.flat() method.

#Algorithms #Recursion #Arrays

Practice

Frontend Engineer • Coding • medium

Explain TypeScript Generics. Write a generic function that takes an array of objects and a key, and returns an array of values for that key.

#Generics #Type Safety #Utility Types

Practice

Frontend Engineer • Coding • medium

Write a polyfill for the Array.prototype.map() function.

#Polyfills #Prototypes #Higher Order Functions

Practice

Frontend Engineer • Coding • medium

Write a debounce function from scratch. How would you use it in a React application for a search input querying a large tax database?

#Closures #Performance Optimization #DOM Events

Practice

Frontend Engineer • Coding • medium

Write a custom React hook `useFetch` that takes a URL, fetches data, and handles loading and error states. It must include an AbortController to cancel the request if the component unmounts.

#Custom Hooks #API Integration #Memory Management

Practice

Frontend Engineer • Coding • hard

Design a paginated data table component in React. It needs to support sorting by column, filtering, and server-side pagination.

#Component Design #State Management #API Integration

Practice

Frontend Engineer • Coding • medium

Implement a deep clone function for a nested JavaScript object. Assume the object might contain dates and nested arrays, which is common in our financial reporting payloads.

#Data Structures #Recursion #Object Manipulation

Practice

Frontend Engineer • System Design • hard

Design the frontend architecture for a micro-frontend based suite of internal PwC HR and resource management tools.

#Micro-frontends #Webpack Module Federation #Architecture

Practice

Frontend Engineer • System Design • hard

Design a real-time financial audit dashboard. How would you handle continuous streams of data updates without freezing the browser?

#WebSockets #Performance #Real-time Data

Practice

Frontend Engineer • Technical • hard

What are Core Web Vitals? How would you diagnose and improve a poor Cumulative Layout Shift (CLS) score on a client landing page?

#Core Web Vitals #SEO #Performance Optimization

Practice

Frontend Engineer • Technical • medium

What are the key Web Accessibility (WCAG) standards you consider when building a public-facing application? How do you test for them?

#a11y #WCAG #Semantic HTML

Practice

Frontend Engineer • Technical • easy

What is a closure in JavaScript? Provide a practical use case where you would use a closure in a frontend application.

#Closures #Scope #Encapsulation

Practice

Frontend Engineer • Technical • medium

Compare Promises and Async/Await. How do you handle errors in both approaches when making multiple concurrent API calls?

#Async/Await #Promises #Error Handling

Practice

Frontend Engineer • Technical • easy

Explain hoisting in JavaScript. How do `var`, `let`, and `const` differ in terms of hoisting and scope?

#Hoisting #Scope #ES6

Practice

Frontend Engineer • Technical • medium

Explain prototypal inheritance in JavaScript. How does it differ from classical inheritance found in Java or C#?

#Prototypes #Inheritance #OOP

Practice

Frontend Engineer • Technical • medium

In React, what are the differences between Higher-Order Components (HOCs), Render Props, and Custom Hooks? Which pattern is preferred today?

#Design Patterns #React Hooks #Component Architecture

Practice

Frontend Engineer • Technical • medium

How do you handle complex form validation in React for a multi-step tax filing wizard? What libraries or patterns would you use?

#Forms #Validation #UX

Practice

Frontend Engineer • Technical • medium

Explain the differences between Server-Side Rendering (SSR), Static Site Generation (SSG), and Client-Side Rendering (CSR). Which is best for a secure, authenticated client tax portal?

#Next.js #Rendering Strategies #Web Architecture

Practice

Frontend Engineer • Technical • hard

How do you optimize a React application that is rendering a large list of 10,000 audit records? Walk me through the techniques you would use.

#React Performance #Virtualization #Memoization

Practice

Frontend Engineer • Technical • medium

Compare Redux and the React Context API. For a large-scale PwC client portal with complex state, which would you choose and why?

#State Management #Redux #Context API

Practice

Frontend Engineer • Technical • medium

What is the difference between useEffect and useLayoutEffect in React? When would you use one over the other in an enterprise dashboard?

#React Hooks #Component Lifecycle #Rendering

Practice

Frontend Engineer • Technical • medium

Explain the JavaScript Event Loop. How does it handle asynchronous operations like fetching client data from an API?

#Event Loop #Asynchronous Programming #Microtasks

Practice

Frontend Engineer • Technical • easy

What is the Virtual DOM, and how does React's reconciliation algorithm (Fiber) work under the hood?

#Virtual DOM #Reconciliation #React Internals

Practice

Frontend Engineer • Technical • hard

How do you prevent Cross-Site Scripting (XSS) and Cross-Site Request Forgery (CSRF) in a modern Single Page Application handling sensitive financial data?

#Web Security #XSS #CSRF

Practice

Frontend Engineer • Technical • easy

Explain the difference between CSS Grid and Flexbox. When would you use Grid over Flexbox for a complex dashboard layout?

#CSS Grid #Flexbox #Layout

Practice

Full Stack Engineer • Behavioral • medium

Tell me about a time you had to push back on a client's technical request because you knew it wasn't the best solution.

#Communication #Consulting #Negotiation

Practice

Full Stack Engineer • Behavioral • easy

Why do you want to work as a Full Stack Engineer at PwC, and how do your values align with the PwC Professional framework?

#PwC Professional #Values #Motivation

Practice

Full Stack Engineer • Behavioral • easy

Tell me about a time you mentored a junior developer or helped a peer overcome a technical blocker.

#Mentorship #Collaboration #Empathy

Practice

Full Stack Engineer • Behavioral • medium

Describe a time you disagreed with a senior engineer or architect on a system design choice. How was it resolved?

#Conflict Resolution #Communication #Leadership

Practice

Full Stack Engineer • Behavioral • hard

Working at PwC means handling highly sensitive financial data. How do you incorporate security and data privacy into your daily development routine?

#Data Privacy #Compliance #DevSecOps

Practice

Full Stack Engineer • Behavioral • medium

Tell me about a time you found a critical bug right before a major deployment. How did you handle it?

#Debugging #Pressure #Risk Management

Practice

Full Stack Engineer • Behavioral • easy

Describe a situation where you had to learn a new technology or framework very quickly to deliver a project.

#Learning #Agile #Resilience

Practice

Full Stack Engineer • Coding • medium

Write a custom React hook (e.g., useFetch) that fetches data from an API, handles loading state, and catches errors.

#React #Custom Hooks #API

Practice

Full Stack Engineer • Coding • medium

Design a data structure that follows the constraints of a Least Recently Used (LRU) cache.

#Design #Linked List #Hash Map

Practice

Full Stack Engineer • Coding • medium

Given an array of strings strs, group the anagrams together. You can return the answer in any order.

#Strings #Hash Map

Practice

Full Stack Engineer • Coding • medium

Find the kth largest element in an unsorted array. Note that it is the kth largest element in the sorted order, not the kth distinct element.

#Heap #Sorting #Divide and Conquer

Practice

Full Stack Engineer • Coding • easy

Given the head of a singly linked list, reverse the list, and return the reversed list.

#Linked List

Practice

Full Stack Engineer • Coding • easy

Write a SQL query to find the second highest salary from an Employee table.

#Queries #Aggregation

Practice

Full Stack Engineer • Coding • easy

Given an array of integers nums and an integer target, return indices of the two numbers such that they add up to target.

#Arrays #Hash Map

Practice

Full Stack Engineer • Coding • easy

Given a string s containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid.

#Strings #Stack

Practice

Full Stack Engineer • Coding • medium

Given an array of intervals where intervals[i] = [starti, endi], merge all overlapping intervals, and return an array of the non-overlapping intervals that cover all the intervals in the input.

#Arrays #Sorting

Practice

Full Stack Engineer • System Design • hard

How would you design a microservices architecture for an enterprise expense tracking application?

#Microservices #Event-Driven #API Gateway

Practice

Full Stack Engineer • System Design • medium

Design a scalable logging and monitoring solution for a distributed microservices ecosystem.

#Logging #Observability #ELK Stack

Practice

Full Stack Engineer • System Design • medium

Explain how you would implement caching in a high-traffic enterprise application to reduce database load.

#Caching #Redis #Performance

Practice

Full Stack Engineer • System Design • medium

Design a RESTful API for a client onboarding system. What endpoints would you create and what HTTP methods would you use?

#REST #Backend #HTTP

Practice

Full Stack Engineer • System Design • medium

Design a real-time notification system to alert consultants about upcoming tax deadlines.

#WebSockets #Pub/Sub #Push Notifications

Practice

Full Stack Engineer • System Design • medium

Design a URL shortener service like Bitly.

#Hashing #Scalability #Databases

Practice

Full Stack Engineer • System Design • hard

Design a secure document management system for auditing purposes where users can upload, view, and sign PDFs.

#Microservices #Storage #Security #AWS/Azure

Practice

Full Stack Engineer • Technical • easy

Explain Dependency Injection and its benefits in a framework like .NET Core or Spring Boot.

#Design Patterns #OOP #Inversion of Control

Practice

Full Stack Engineer • Technical • medium

Explain the lifecycle hooks in Angular and provide a scenario where you would use ngOnChanges.

#Angular #Lifecycle

Practice

Full Stack Engineer • Technical • medium

How do you manage state in a large-scale enterprise React application?

#React #State Management #Redux #Context API

Practice

Full Stack Engineer • Technical • easy

Explain the difference between the Virtual DOM and the Real DOM in React.

#React #DOM

Practice

Full Stack Engineer • Technical • medium

How do you secure a REST API? Explain how JWT works in an enterprise application.

#JWT #OAuth #API Security

Practice

Full Stack Engineer • Technical • medium

Explain the difference between clustered and non-clustered indexes in SQL Server or PostgreSQL.

#Databases #Indexing #Performance

Practice

Full Stack Engineer • Technical • medium

How does Node.js handle concurrency despite being single-threaded?

#Node.js #Event Loop #Architecture

Practice

Full Stack Engineer • Technical • medium

What is CORS, why does it exist, and how do you resolve CORS errors in a full-stack application?

#CORS #HTTP #Security

Practice

Full Stack Engineer • Technical • medium

What is the difference between Promises and Observables? When would you use one over the other?

#Asynchronous #RxJS #Angular

Practice

Full Stack Engineer • Technical • hard

How do you handle database schema migrations in a CI/CD pipeline without causing downtime?

#CI/CD #Databases #Deployment

Practice

Full Stack Engineer • Technical • easy

What are the ACID properties in a database? Why are they important for financial applications?

#ACID #Transactions #Data Integrity

Practice

Full Stack Engineer • Technical • medium

A client complains that their web portal is loading very slowly. Walk me through the steps you would take to diagnose and optimize it.

#Optimization #Frontend #Network

Practice

Machine Learning Engineer • Behavioral • medium

Consulting often involves dealing with extremely messy, undocumented client data. Describe a time you faced this. How did you ensure data quality before modeling?

#Data Cleaning #Resilience #Problem Solving

Practice

Machine Learning Engineer • Behavioral • medium

PwC highly values 'Reimagining the Possible'. Can you share an example of how you innovated a process or solved a problem using AI in a way that wasn't originally asked for?

#Innovation #Proactivity #PwC Values

Practice

Machine Learning Engineer • Behavioral • medium

Tell me about a time you disagreed with a senior team member or a client about the technical approach for an ML project. How did you handle it?

#Conflict Resolution #Communication #Teamwork

Practice

Machine Learning Engineer • Behavioral • medium

Working at a consultancy like PwC often means juggling multiple client engagements. How do you prioritize your technical tasks when facing competing, tight deadlines?

#Time Management #Prioritization #Consulting

Practice

Machine Learning Engineer • Behavioral • hard

Describe a situation where a model you built performed exceptionally well in training but failed or underperformed in production. What was the root cause and how did you fix it?

#Troubleshooting #Data Leakage #Real-world ML

Practice

Machine Learning Engineer • Behavioral • medium

Tell me about a time you had to explain a complex machine learning concept to a non-technical stakeholder or client. How did you ensure they understood?

#Communication #Client-Facing #Consulting

Practice

Machine Learning Engineer • Coding • easy

Write a SQL query to find all clients who have purchased 'Consulting Service A' but have never purchased 'Audit Service B'.

#SQL #Joins #Filtering

Practice

Machine Learning Engineer • Coding • medium

Using Pandas, write a function to calculate the 7-day moving average of transaction amounts for a given client ID, handling missing dates appropriately.

#Python #Pandas #Time Series

Practice

Machine Learning Engineer • Coding • medium

Given a large list of server log error codes, write a function to find the top K most frequent error codes. Optimize for time complexity.

#Heaps #Hash Maps #Counting

Practice

Machine Learning Engineer • Coding • hard

Implement the core update step of the K-Means clustering algorithm in Python using NumPy.

#Python #NumPy #Machine Learning

Practice

Machine Learning Engineer • Coding • medium

Write a SQL query to find the second highest transaction amount for each client department. If there is no second highest, return null.

#SQL #Window Functions

Practice

Machine Learning Engineer • Coding • hard

Write a SQL query to calculate the month-over-month churn rate for our SaaS product.

#SQL #Aggregations #Time Series

Practice

Machine Learning Engineer • Coding • medium

We have a table of client records with potential duplicates due to slight spelling variations. Write a SQL query to identify potential duplicate records based on matching email domains and similar names.

#SQL #String Manipulation #Self Joins

Practice

Machine Learning Engineer • Coding • medium

Given an array of intervals where intervals[i] = [starti, endi], merge all overlapping intervals, and return an array of the non-overlapping intervals that cover all the intervals in the input. This is often used to consolidate overlapping client transaction windows.

#Arrays #Sorting #Intervals

Practice

Machine Learning Engineer • Coding • medium

Write a Python function from scratch to compute the TF-IDF scores for a corpus of text documents without using scikit-learn.

#Python #NLP #Math

Practice

Machine Learning Engineer • System Design • hard

Design an end-to-end Machine Learning pipeline for real-time credit card fraud detection.

#Real-time Processing #Fraud Detection #Architecture

Practice

Machine Learning Engineer • System Design • hard

What is Retrieval-Augmented Generation (RAG)? Walk me through how you would implement a RAG pipeline for an internal tax policy Q&A bot.

#GenAI #RAG #Vector Databases

Practice

Machine Learning Engineer • System Design • hard

Design an automated document processing pipeline that scales to process millions of scanned PDF invoices per month.

#Batch Processing #OCR #Cloud Architecture

Practice

Machine Learning Engineer • System Design • medium

Describe a CI/CD pipeline for Machine Learning (Continuous Training). What triggers a model to be retrained and redeployed?

#CI/CD #Automation #MLOps

Practice

Machine Learning Engineer • System Design • hard

Design a recommendation system for a retail banking client to suggest new financial products to existing customers.

#Recommendation Systems #Architecture #Personalization

Practice

Machine Learning Engineer • System Design • hard

How would you design a system to automatically extract key clauses (e.g., termination dates, liability limits) from thousands of unstructured legal contracts?

#NLP #Information Extraction #Architecture

Practice

Machine Learning Engineer • Technical • medium

Explain your approach to versioning data, code, and models in a collaborative ML team environment.

#Version Control #MLflow #DVC

Practice

Machine Learning Engineer • Technical • hard

A client complains that the machine learning API is too slow. How do you optimize an ML model for low-latency inference?

#Optimization #Inference #Latency

Practice

Machine Learning Engineer • Technical • medium

You are building a model to predict loan defaults for a financial client. What evaluation metrics would you prioritize and why?

#Classification #Metrics #Risk Management

Practice

Machine Learning Engineer • Technical • medium

If you are using a clustering algorithm to segment a client's customer base, but you have no ground truth labels, how do you evaluate the quality of your clusters?

#Unsupervised Learning #Clustering #Metrics

Practice

Machine Learning Engineer • Technical • medium

Explain L1 (Lasso) vs L2 (Ridge) regularization. When would you choose one over the other in a client project?

#Regularization #Linear Models #Feature Selection

Practice

Machine Learning Engineer • Technical • medium

What is the fundamental difference between Random Forest and Gradient Boosting Machines (GBM)?

#Ensemble Methods #Decision Trees

Practice

Machine Learning Engineer • Technical • medium

In fraud detection, datasets are typically highly imbalanced. What techniques would you use to handle a dataset where only 0.1% of transactions are fraudulent?

#Imbalanced Data #Classification #Fraud Detection

Practice

Machine Learning Engineer • Technical • hard

PwC deals heavily with regulatory compliance. Explain how SHAP values work and how you would use them to explain a black-box credit risk model to an auditor.

#Explainable AI (XAI) #SHAP #Compliance

Practice

Machine Learning Engineer • Technical • medium

How do you detect and handle data drift in a production machine learning model over time?

#Model Monitoring #Data Drift #MLOps

Practice

Machine Learning Engineer • Technical • hard

Explain the architecture of a Transformer model. What makes the self-attention mechanism so effective compared to RNNs?

#Deep Learning #NLP #Transformers

Practice

Machine Learning Engineer • Technical • hard

When deploying Large Language Models for enterprise applications, how do you mitigate and handle 'hallucinations'?

#GenAI #LLMs #Risk Mitigation

Practice

Machine Learning Engineer • Technical • medium

Explain the bias-variance tradeoff as if you were explaining it to a non-technical partner at the firm.

#Model Evaluation #Communication

Practice

Machine Learning Engineer • Technical • medium

Describe the process of fine-tuning a pre-trained BERT model for a domain-specific sentiment analysis task (e.g., financial news sentiment).

#Transfer Learning #BERT #Fine-tuning

Practice

Machine Learning Engineer • Technical • medium

Walk me through how you would containerize and deploy a machine learning model using Docker and Kubernetes on Azure (AKS).

#Docker #Kubernetes #Azure

Practice

Product Manager • Behavioral • medium

Tell me about a time you discovered a critical bug in production right before a major client demo. What did you do?

#Problem Solving #Under Pressure #Communication

Practice

Product Manager • Behavioral • medium

Describe a time you had to use data to influence a senior leader's decision.

#Data-Driven Decisions #Storytelling #Leadership

Practice

Product Manager • Behavioral • medium

Give an example of how you handled a situation where your development team pushed back on a product requirement.

#Conflict Resolution #Technical Empathy #Negotiation

Practice

Product Manager • Behavioral • medium

What is your approach to gathering requirements for a product when the end-users (e.g., forensic accountants) are highly specialized and extremely busy?

#Empathy #Efficiency #SME Engagement

Practice

Product Manager • Behavioral • medium

How do you ensure alignment between the engineering team and business stakeholders who lack technical expertise?

#Translation #Alignment #Empathy

Practice

Product Manager • Behavioral • easy

Tell me about a time you failed to deliver a product feature on time. What was the impact, and what did you learn?

#Accountability #Risk Management #Continuous Improvement

Practice

Product Manager • Behavioral • medium

Tell me about a time you led a cross-functional team of engineers, designers, and subject matter experts (SMEs) without formal authority.

#Cross-functional Collaboration #Influence #Team Dynamics

Practice

Product Manager • Behavioral • medium

How do you say "no" to a demanding client or internal Partner without damaging the relationship?

#Negotiation #Empathy #Stakeholder Alignment

Practice

Product Manager • Behavioral • hard

Describe a situation where a client changed their core requirements midway through a digital transformation project. How did you handle it?

#Adaptability #Scope Creep #Agile Methodology

Practice

Product Manager • Behavioral • medium

Tell me about a time you had to manage conflicting priorities from multiple high-level stakeholders, such as PwC Partners or enterprise clients.

#Prioritization #Communication #Conflict Resolution

Practice

Product Manager • Behavioral • hard

Tell me about a time you had to pivot your product strategy based on new regulatory or compliance requirements.

#Compliance #Agility #Risk Management

Practice

Product Manager • Behavioral • medium

If a key engineering resource is suddenly pulled onto another critical PwC project, how do you adjust your sprint and manage stakeholder expectations?

#Resource Management #Agile #Communication

Practice

Product Manager • Behavioral • easy

Tell me about a time you had to adapt your communication style to explain a complex technical product to a global, multicultural team.

#Diversity #Global Teams #Clarity

Practice

Product Manager • Behavioral • hard

Describe a time you had to sunset a legacy product. How did you manage the transition for existing users?

#Sunsetting #Change Management #Empathy

Practice

Product Manager • Coding • easy

Explain how you would write a script or logic to parse a CSV file of client employee data and identify duplicate records.

#Algorithms #Data Cleansing #Logic

Practice

Product Manager • Coding • easy

Write a SQL query to find the top 5 enterprise clients by total revenue generated in the last fiscal year from a `client_transactions` table.

#Data Analysis #Aggregation #Sorting

Practice

Product Manager • Coding • medium

Write a SQL query to find the average time spent on an audit task, grouped by the auditor's seniority level.

#Joins #Aggregation #Data Analysis

Practice

Product Manager • Coding • medium

Given a dataset of user login events, write a SQL query to calculate the Daily Active Users (DAU) for the past 30 days.

#Metrics #Date Functions #Distinct Counts

Practice

Product Manager • System Design • medium

Walk me through the high-level system design of an internal chatbot designed to answer HR and IT queries for PwC's 300,000+ employees.

#NLP #Microservices #Enterprise Search

Practice

Product Manager • System Design • hard

Design a document management system capable of securely handling millions of highly confidential client tax and financial documents.

#Security #Scalability #Document Storage

Practice

Product Manager • System Design • medium

How would you design a dashboard for PwC Partners to track the profitability, utilization, and risk of their consulting engagements?

#UX/UI #Data Visualization #B2B Enterprise

Practice

Product Manager • System Design • medium

Design an automated alert system that notifies consultants when a client's financial risk profile changes based on external news sources.

#Web Scraping #NLP #Pub/Sub

Practice

Product Manager • System Design • medium

How would you design a database schema for a project management tool used by PwC engagement teams?

#Entity-Relationship #Data Modeling #B2B

Practice

Product Manager • System Design • hard

Design a system to ingest, process, and visualize real-time supply chain data for a Fortune 500 client.

#Real-time Processing #Data Pipelines #Scalability

Practice

Product Manager • System Design • medium

How would you architect the user permissions and role-based access control (RBAC) for a global enterprise audit platform?

#RBAC #Enterprise Security #Compliance

Practice

Product Manager • Technical • hard

We want to build a centralized data platform to consolidate a client's global financial data. What are the key product risks?

#Data Privacy #Integration Risks #Enterprise Architecture

Practice

Product Manager • Technical • hard

How would you price a new SaaS product developed by PwC for mid-market ESG (Environmental, Social, and Governance) reporting?

#SaaS Pricing #Market Analysis #ESG

Practice

Product Manager • Technical • medium

How do you balance addressing technical debt with the need to deliver new features for a demanding client?

#Technical Debt #Roadmapping #Trade-offs

Practice

Product Manager • Technical • medium

What frameworks do you use to conduct market research and competitive analysis for a new consulting tech offering?

#Strategy #Competitive Analysis #Frameworks

Practice

Product Manager • Technical • easy

Explain how a REST API works to a non-technical consulting Partner who wants to integrate their legacy ERP with our new cloud platform.

#APIs #Cloud Integration #Analogy

Practice

Product Manager • Technical • medium

Imagine we are building a new automated auditing tool. What key metrics would you track to ensure product adoption and success?

#KPIs #Adoption #Audit Technology

Practice

Product Manager • Technical • hard

How do you decide whether to build a software solution in-house or buy an off-the-shelf SaaS product for a client's digital transformation?

#Build vs. Buy #ROI Analysis #Strategic Alignment

Practice

Product Manager • Technical • medium

How would you improve the onboarding experience for a complex B2B financial compliance software?

#Onboarding #UX #Product Led Growth

Practice

Product Manager • Technical • medium

Walk me through your process for prioritizing features in a B2B enterprise product roadmap.

#Prioritization Frameworks #B2B #Strategy

Practice

Product Manager • Technical • hard

PwC is looking to integrate Generative AI into its tax advisory services. Walk me through how you would define the MVP for this product.

#Generative AI #MVP Definition #Tax Technology

Practice

Software Engineer • Behavioral • medium

Tell me about a time you had to learn a completely new technology stack quickly to deliver a project.

#Continuous Learning #Problem Solving

Practice

Software Engineer • Behavioral • easy

Why do you want to work as a Software Engineer at PwC rather than a traditional tech company?

#Motivation #Career Goals

Practice

Software Engineer • Behavioral • medium

Tell me about a time you noticed a security vulnerability or compliance issue in a project. How did you address it?

#Security #Integrity #Leadership

Practice

Software Engineer • Behavioral • medium

How do you handle a situation where a client changes the project requirements drastically just weeks before the delivery deadline?

#Agile #Conflict Resolution #Adaptability

Practice

Software Engineer • Behavioral • medium

Tell me about a time you had to explain a complex technical architecture to a non-technical client or stakeholder.

#Client Facing #Soft Skills

Practice

Software Engineer • Behavioral • medium

Tell me about a time you disagreed with a senior engineer or a manager on a technical decision. How did you resolve it?

#Conflict Resolution #Communication

Practice

Software Engineer • Behavioral • easy

Tell me about a time you had multiple competing deadlines. How did you prioritize your work?

#Prioritization #Delivery

Practice

Software Engineer • Coding • medium

You are given an array of integers representing coin denominations and a total amount. Write a function to compute the fewest number of coins needed to make up that amount.

#Dynamic Programming

Practice

Software Engineer • Coding • medium

Given a list of overlapping tax reporting periods represented as intervals, write a function to merge all overlapping intervals.

#Arrays #Sorting

Practice

Software Engineer • Coding • medium

Given a string, find the length of the longest substring without repeating characters.

#Strings #Sliding Window

Practice

Software Engineer • Coding • medium

Write a SQL query to find the Nth highest salary from an Employee table. How would you optimize it for a table with millions of rows?

#Subqueries #Performance

Practice

Software Engineer • Coding • medium

Write a SQL query to find the top 3 departments with the highest average transaction volume over the last quarter.

#Aggregations #Joins #Window Functions

Practice

Software Engineer • Coding • easy

Given an array of transaction amounts, find two transactions that sum up to a specific flagged fraudulent amount.

#Arrays #Hash Maps

Practice

Software Engineer • Coding • easy

Write a function to validate if a string containing a mathematical formula (with parentheses, brackets, and braces) is properly balanced.

#Strings #Stacks

Practice

Software Engineer • Coding • hard

Given a list of project tasks with dependencies, determine if it is possible to finish all tasks (detect if there is a cycle).

#Graphs #Topological Sort #DFS

Practice

Software Engineer • Coding • medium

Write a program to group an array of transaction descriptions into anagrams to identify potentially duplicated or obfuscated entries.

#Strings #Hash Maps

Practice

Software Engineer • Coding • medium

Given an organizational hierarchy represented as a binary tree, find the lowest common manager (Lowest Common Ancestor) of two employees.

#Trees #Recursion

Practice

Software Engineer • System Design • easy

Design a URL shortener service (like bit.ly) to be used internally for sharing links to PwC audit reports.

#Hashing #Databases #API Design

Practice

Software Engineer • System Design • medium

Design an API rate limiter to prevent clients from overwhelming our internal tax calculation service.

#API Gateway #Caching #Algorithms

Practice

Software Engineer • System Design • hard

Design a secure, large-scale document ingestion pipeline for processing millions of client tax forms and invoices.

#Cloud Architecture #Data Pipelines #Security

Practice

Software Engineer • System Design • medium

Design a secure file transfer service for clients to upload sensitive financial documents (up to 5GB per file).

#Storage #Networking #Security

Practice

Software Engineer • System Design • medium

Design an internal employee directory and skill-matching platform for PwC consultants to find subject matter experts.

#Search #Databases #Caching

Practice

Software Engineer • System Design • medium

Design a Role-Based Access Control (RBAC) system for a global enterprise portal used by PwC employees and external clients.

#Security #Database Schema #API Design

Practice

Software Engineer • System Design • hard

Design a real-time fraud detection system that analyzes streams of financial transactions.

#Stream Processing #Machine Learning Integration #Low Latency

Practice

Software Engineer • System Design • medium

Design an Audit Logging System that can handle high throughput from various internal microservices and ensure data immutability.

#Microservices #Message Queues #Database Design

Practice

Software Engineer • Technical • hard

Explain the concept of Micro-frontends. Have you ever used them, and what are the pros and cons?

#Web Development #Architecture

Practice

Software Engineer • Technical • hard

Explain how you would handle race conditions in a highly concurrent application processing financial transactions.

#Multithreading #Locks #Transactions

Practice

Software Engineer • Technical • medium

Explain how Redis works. What are some common use cases for Redis in an enterprise web application?

#Redis #In-Memory Data Stores #Performance

Practice

Software Engineer • Technical • medium

Explain the SOLID principles and provide an example of how you applied the Dependency Inversion Principle in a recent project.

#OOP #Design Patterns #Clean Code

Practice

Software Engineer • Technical • easy

What is the difference between Git Merge and Git Rebase? When would you use one over the other?

#Git #Collaboration

Practice

Software Engineer • Technical • medium

What is the difference between clustered and non-clustered indexes in a relational database?

#SQL #Performance Tuning #Indexing

Practice

Software Engineer • Technical • medium

Describe your ideal CI/CD pipeline for deploying a containerized microservice to a cloud environment.

#CI/CD #Docker #Cloud

Practice

Software Engineer • Technical • medium

How do you secure a REST API exposed to external clients?

#REST #Authentication #Authorization

Practice

Software Engineer • Technical • medium

How do you approach writing unit tests for a legacy codebase that has tight coupling and no existing tests?

#Unit Testing #Refactoring #Mocking

Practice

Software Engineer • Technical • medium

What is an ORM (Object-Relational Mapper)? What is the 'N+1 query problem' and how do you solve it?

#ORM #Performance #SQL

Practice

PwC

The Interview Loop

Recruiter Screen (30 min)

Technical Loop (3-4 Rounds)

Interview Question Bank

Describe a situation where you had to push back on a client's or product manager's request because it would compromise system security or performance.

PwC values 'Global Acumen'. Tell me about a time you worked with a distributed team across different time zones to deliver a backend feature.

Tell me about a time you identified a bottleneck in an existing legacy system and took the initiative to refactor it.

How do you handle changing requirements from a client midway through a sprint?

Describe a time you failed to meet a deadline for a critical API delivery. What happened and how did you communicate it?

Tell me about a time you mentored a junior developer on backend best practices.

Why PwC? How does our technology consulting practice align with your career goals?

Tell me about a time you had to explain a complex technical backend issue to a non-technical stakeholder or client.

Write a SQL query to find the second highest salary from an Employee table.

Given an array of integers, return indices of the two numbers such that they add up to a specific target.

Write a function to check if a given string containing brackets is valid (properly closed and nested).

Find the lowest common ancestor of two nodes in a binary search tree.

Given an array of strings, group the anagrams together.

Write a function to reverse a singly linked list.

Given a string, find the length of the longest substring without repeating characters.

Write a SQL query to find all departments that have less than 3 employees.

Implement a LRU (Least Recently Used) Cache.

Given a list of intervals, merge all overlapping intervals.

Design a notification system that sends email, SMS, and push notifications to users based on audit event triggers.

Design a scalable document management system for auditing purposes where users can upload, search, and retrieve large PDF files.

Design a rate limiter for a public-facing API to prevent abuse from third-party consumers.

How would you design a distributed logging and monitoring system for a microservices architecture spanning multiple cloud regions?

Design an ETL pipeline that ingests daily transaction files from multiple financial clients, sanitizes the data, and loads it into a data warehouse.

Design a URL shortening service like Bitly. Focus on the database schema and read/write scaling.

A client's e-commerce backend is experiencing database timeouts during peak holiday sales. How would you architect a caching layer to resolve this?

What are the ACID properties in a database, and how do they apply to distributed transactions?

Explain how you would secure a RESTful API built for a financial services client.

How does Spring Boot handle dependency injection, and why is it beneficial for enterprise applications?

Explain the difference between monolithic and microservices architectures. When would you recommend a client migrate to microservices?

Describe your experience with CI/CD pipelines. How would you automate the deployment of a Dockerized backend service?

How do you ensure idempotent operations in a distributed backend system?

What is the N+1 query problem in ORMs like Hibernate or Entity Framework, and how do you resolve it?

Explain the concept of a Dead Letter Queue (DLQ) in message brokers like Kafka or RabbitMQ.

How do you implement pagination and filtering in a REST API returning large datasets?

Describe the differences between optimistic and pessimistic locking in database concurrency control.

Tell me about a time you had to explain a complex cloud architecture to a non-technical client stakeholder.

As a consultant, you are assigned to a project where the client's internal IT team is hostile to the cloud migration. How do you build trust?

Tell me about a time you disagreed with a senior architect or manager on a technical design. How did you resolve it?

Describe a time when you had to quickly learn a new cloud technology or tool to deliver a project for a client.

Have you ever missed a project deadline during a cloud migration? What happened and how did you communicate it to the client/manager?

Tell me about a time you discovered a significant security vulnerability or misconfiguration in a client's cloud environment. How did you handle it?

Describe a situation where a client pushed back on your proposed cloud security controls because they felt it slowed down development.

Write a bash script to parse an Nginx access log and output the top 5 IP addresses with the most 404 errors.

Write a Python function that validates whether a given string is a properly formatted JSON IAM policy document with required 'Effect' and 'Action' fields.

Given an array of integers representing daily cloud compute costs, write a function to find the maximum cost increase between any two consecutive days.

Write a script to query a cloud provider's REST API to list all users who haven't rotated their access keys in 90 days.

Write a Python script using Boto3 (or Azure SDK) to find and delete all unattached EBS volumes or managed disks older than 30 days.

Design a centralized logging and monitoring solution for a multi-account AWS environment using cloud-native tools.

A client wants to migrate a legacy monolithic application to a microservices architecture on Kubernetes. Walk me through your migration strategy.

Design a secure 'Landing Zone' architecture for a healthcare client that complies with HIPAA regulations.

Design a serverless data ingestion pipeline that processes millions of IoT sensor events per minute and stores them for analytics.

Design a secure, multi-region active-active cloud architecture for a financial services client with strict data residency requirements.

A retail client expects a 10x traffic spike during Black Friday. How do you design their cloud infrastructure to handle this elastically?

Design a Disaster Recovery (DR) strategy for a mission-critical database with an RPO of 5 minutes and an RTO of 1 hour.

How do you manage Terraform state files in a multi-developer environment, and what happens if the state file gets corrupted?

What are Terraform modules, and what are the best practices for versioning and sharing them across enterprise teams?

Explain the difference between Docker CMD and ENTRYPOINT instructions.

How do you implement least privilege access in AWS IAM or Azure RBAC for a CI/CD pipeline deploying infrastructure?

How do you handle database schema migrations in an automated CI/CD pipeline without causing downtime?

What is your approach to handling secrets and sensitive data in a Terraform-managed infrastructure?

Explain the concept of Blue/Green deployments. How would you implement this using AWS CodePipeline or Azure DevOps?

What are the key differences between a relational database and a NoSQL database in terms of scaling and consistency?

Compare and contrast serverless compute (e.g., AWS Fargate, Azure Container Instances) with managed Kubernetes (EKS/AKS). How do you advise a client on which to choose?

Explain how VPC Peering works and its limitations. How does AWS Transit Gateway or Azure Virtual WAN solve these limitations?

How do you troubleshoot a 'CrashLoopBackOff' error in a Kubernetes pod?

How do you optimize cloud costs for a client who has over-provisioned their EC2/VM instances?

Explain the difference between an Application Load Balancer and a Network Load Balancer. When would you use each in an enterprise migration?

What is a Service Mesh, and why might a client need one when adopting Kubernetes?

Explain the role of an Ingress Controller in Kubernetes. How does it differ from a LoadBalancer service?

How do you enforce compliance and governance rules across multiple cloud accounts (e.g., using AWS Organizations/SCP or Azure Policy)?

Describe a situation where a client changed the requirements for a data pipeline midway through the sprint. How did you handle it?

Why do you want to work as a Data Engineer at a consulting firm like PwC specifically, compared to working at a product-based company?

Describe a time you had to work with a difficult team member or client who was resistant to adopting a new data engineering tool or process.

Tell me about a time you had to explain a complex technical data issue to a non-technical client stakeholder.

Tell me about a time you identified a data quality issue that others missed. What was the impact and how did you resolve it?