Derived from 1 submission for ALL. Format details may vary across different teams or locations.
The interview consisted of a technical round with a focus on Python, ETL processes, and SQL. The candidate was required to solve coding problems and explain their solutions in detail. The tasks were performed on Coderpad, ensuring practical execution and demonstration of results.
An hour-long technical interview focusing on Python, ETL processes, and SQL. The candidate was asked to solve coding problems and explain concepts in detail.
Reverse Substring in String (without using slices): Reverse a substring within a given string without employing slicing operations.
Find Prime Numbers within a Range (O(n)): Devise an algorithm to identify prime numbers within a specified range with a linear time complexity of O(n).
ETL Description and Spark Script: Explain the ETL process and write a Spark script to perform ETL transformations.
Top 5 Salary After Joining 2 Tables: Query to find the top 5 salaries after merging data from two tables.
Employees and Projects Before 2024: Join four tables to retrieve information about employees and projects initiated prior to 2024, including year extraction from a DateFormat column.
All coding tasks were conducted on Coderpad, where the candidate needed to execute the scripts to showcase the results accurately.
InterviewDigest