Round 1: Technical fit interview (30 mins)Evaluates the candidate's expertise in relation to the job description. Assesses behavioral competencies and cultural fit with the organization. Round 2: Technical interview (30 mins) & Techno-Managerial Round (45 mins)Focuses on testing technical skills, particularly those highlighted in the resume. Combines technical evaluation with managerial assessment. Round 3: Managerial interview (45 mins)Examines the candidate's level of expertise and understanding of relevant processes. Discusses the candidate's work experience, expectations, and addresses any questions.

Round 2 Interview Topics

Python Basic concepts such as generators and iterators. Sorting a list without using built-in functions.

SQL Fundamental SQL queries. Analytical operations using window functions and data deduplication.

PySpark Optimization techniques. Operations with window functions, grouping, filtering, and exploding data.

System Design Questions Provide a detailed explanation of one of your projects, including end-to-end (ETE) project design. How does the ETL process flow work? Describe how you would develop an anomaly detection algorithm and an alerting mechanism.