Piramal Finance Interview Questions
The questions to prepare for Piramal Finance interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
Explain how to diagnose and optimize a slow PostgreSQL query on large Apidel Technologies datasets.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactSummarize per-user Repl session activity using CTEs, aggregations, and window functions to find top action type and active minutes.
Tests engineering judgment and ability to justify architectural decisions for maintainability and delivery.
Tests scalability design thinking for latency, throughput, resilience, and operational constraints.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests ability to reason about complexity tradeoffs and choose efficient algorithms.
Tests graph and topological ordering skills and ability to implement correct algorithms.
Handle client objections by diagnosing the real concern, re-anchoring on value, and advancing the deal.
Evaluates system design tradeoffs and object-level architecture for notifications.