Round 1: Data Structures & Algorithms (DSA) – Online Assessment

↳ Question: “Given a list of employee IDs, write code to remove duplicates and print sorted IDs.

↳ Suggestion: Use set for deduplication and sort (Python: sorted(list(set(ids))) ).

↳ Question: “Reverse a linked list and print its elements.”

↳ Suggestion: Practice basic linked list reversal logic; avoid using extra space.

Round 2: Advanced SQL and Data Modeling

↳ Question: “Write an SQL query to find the third highest transaction amount per branch, considering ties.”

↳ Suggestion: Use advanced window functions (e.g., ROW_NUMBER() , DENSE_RANK() ).

↳ Question: “Design a schema for storing account and transaction details, optimizing for fast lookups and flexible analytics.”

↳ Suggestion: Explain normalization vs. denormalization, indexing, and partitioning.

Round 3: Data Engineering Concepts & ETL

↳ Question: “Describe your approach for building a near real-time fraud detection pipeline in a banking context.”

↳ Suggestion: Discuss use of Kafka/Stream processing, batch and incremental ETL flows, monitoring.

↳ Question: “Explain best practices for handling schema evolution and backward compatibility in your pipelines.”

↳ Suggestion: Mention schema registry, versioning, data validation.

HR & Managerial Round:

↳ Discussion: Career aspirations, dealing with production incidents, working with cross-functional teams.