L #2987

Applications open Full-Time Job

Associate

PwC India

Chennai, India
Competitive Package
Fresher (0-1 Yrs)
Posted Yesterday

Apply on official portal Prep kit

Build resume Find recruiter WhatsApp

Recruiter contact

Recruiter / hiring contact

No public email in this post. Use a source-linked contact instead.

Connect LinkedIn

About the role

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Oracle

Management Level

Associate

Job Description & Summary

A career within PwC's Oracle Services Practice, will provide you with the opportunity to help organizations use enterprise technology to achieve their digital technology goals and capitalize on business opportunities. We help our clients implement and effectively use Oracle offerings to solve their business problems and fuel success in the areas of finance operations, human capital management, supply chain management, reporting and analytics, and governance, risk and compliance.

Oracle Fusion Technical Developer

Technical skills in OIC and / or PaaS components (like VBCS, PCS)

Technical skills in development of BIP reports

should have strong development skills in both EBS and Fusion technical areas. Should know maximum tools in both EBS and Fusion technical areas.

Mandatory Skill Set-Oracle tech

Preferred Skill Set-Oracle tech

Year of experience required-1

Qualifications-btech

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

Oracle Technology

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

Eligibility & process

Who can apply

Seniority: Associate. Employment type: Full-time

Skills & stack

Oracle DB Data Structures & Algorithms Python/Java OOP SQL REST APIs Git Docker

Selection process

Details are shared by the recruiter after shortlisting.

Prep kit

20 resources

Study material 4

📖 Aptitude Practice Questions & Mock Tests Curated logical, quantitative, and verbal reasoning problems for the initial online screening round. 🎯 Company-Specific Interview Preparation Corner Detailed interview experiences, exam formats, and previous test questions for PwC India and tech roles. 📝 Technical Placement Question Bank High-yield coding cheat sheets, core CS fundamentals (OOP, DBMS, OS, Networks), and rapid revision guides. 💻 Algorithm, DSA & Live Code Debugger Practice Hands-on problem sets to improve coding speed and step-by-step memory debugging.

Company-specific guides 4

📖 APTITUDE & LOGIC Aptitude Practice Questions & Online Mock Tests Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test. 🎯 COMPANY GUIDE PwC India Interview Preparation Corner Comprehensive guide covering typical interview formats, common questions, and preparation tips for PwC India and off-campus tech roles. 📝 MOCK TESTS & PAPERS Comprehensive Interview Prep Resources & Syllabus Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds. 💻 CODING PRACTICE Algorithm and Data Structure Problem Set Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Likely coding questions 4

💻 Two Sum & Two Pointers Array Optimization Easy / Medium Asked in 85% tech rounds ⚡ Live debugger 💻 Reverse Linked List & Detect Cycle (Floyd's Algorithm) Medium Frequently asked in core rounds ⚡ Live debugger 💻 SQL Nth Highest Salary with DENSE_RANK() & Subqueries Medium Top standard database question ⚡ Live debugger 💻 Valid Parentheses & Stack Implementation Easy / Medium Standard online assessment problem ⚡ Live debugger

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 (Oracle DB, Data Structures & Algorithms, Python/Java, OOP, SQL, REST APIs, Git, Docker) & 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.

⚡ Practice in the code editor

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.

⚡ Practice in the code editor

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.

⚡ Practice in the code editor

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.

⚡ Practice in the code editor

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.

⚡ Practice in the code editor

Behavioural & HR questions 3

Why do you want to join PwC India as a Associate?
Highlight PwC India's market reputation, recent tech innovations, and how your skills in Oracle DB 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.

About the role

Degrees/Field of Study required

Degrees/Field of Study preferred

Eligibility & process

Who can apply

Skills & stack

Selection process

Prep kit

More fresh requirements in Software Engineering

Senior Lead Python AI/ML Engineer

Web Developer

Manager

Senior Software Engineer – AgentOps

Instagram Story Creator

Associate

Open on Desktop Browser