KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
L #2973
Applications open Full-Time Job

Associate - MSOFT - GDC

PwC India

  • Kolkata, India
  • Competitive Package
  • Fresher (0-1 Yrs)
  • Posted Yesterday
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Operations

Management Level

Associate

Job Description & Summary

A career within Microsoft Consulting services, will provide the opportunity to help our clients evaluate their supporting technologies needed to engage effectively with their customers, supply chain and employees. We contribute to PwC’s value proposition of strategy led and technology enabled by aligning our Advisory industry focus with Microsoft’s key technologies such as Dynamics AX, Dynamics365, Office365, Azure and Business Intelligence Analytics.

To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be a purpose-led and values-driven leader at every level. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.

As an Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

  • Invite and give in the moment feedback in a constructive manner.
  • Share and collaborate effectively with others.
  • Identify and make suggestions for improvements when problems and/or opportunities arise.
  • Handle, manipulate and analyse data and information responsibly.
  • Follow risk management and compliance procedures.
  • Keep up-to-date with developments in area of specialism.
  • Communicate confidently in a clear, concise and articulate manner - verbally and in the materials I produce.
  • Build and maintain an internal and external network.
  • Seek opportunities to learn about how PwC works as a global network of firms.
  • Uphold the firm's code of ethics and business conduct.

.Net/NVC+Oracle/Sql ServerUnderstanding Visual Studio, SQL Server, Azure DevOps (Project Management/DevOps); Using development methodologies such as SCRUM or Agile; Understanding software development patterns: MVC, MVVM - Web development patterns; Understanding Service Oriented and OO programming principles leveraging design patterns such as singleton, repository, factory, facade, etc.; Using application debugging/testing approaches and integration principles; Understanding performance of application, maintenance and support.

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required

Degrees/Field of Study preferred

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

Yes

Government Clearance Required?

Yes

Job Posting End Date

Eligibility & process

Who can apply

Seniority: Associate. Employment type: Full-time

Skills & stack

SQL Oracle DB SQL Server Azure

Selection process

Details are shared by the recruiter after shortlisting.

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (SQL, Oracle DB, SQL Server, Azure) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion PwC India Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join PwC India as a Associate - MSOFT - GDC?
Highlight PwC India's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
PwC India Competitive Package
Recruiter Resume Apply
Chat Chat with Kashii