Hour-Long Technical Interview\n\nPython Questions:\n\nReverse Substring in String (without using slices):\nI was tasked with reversing a substring within a given string without employing slicing operations. This problem resembled the scenario described in this [LeetCode problem](https://leetcode.com/problems/reverse-string-ii/description/).\n\nFind Prime Numbers within a Range (O(n)):\nThe challenge was to devise an algorithm to identify prime numbers within a specified range with a linear time complexity of O(n).\n\nETL Description and Spark Script:\nI was prompted to elucidate the Extract, Transform, Load (ETL) process and then compose a Spark script to perform ETL transformations.\n\nSQL Questions:\n\nTop 5 Salary After Joining 2 Tables:\nThe task involved querying to ascertain the top 5 salaries after merging data from two tables.\n\nEmployees and Projects Before 2024:\nThis query necessitated joining four tables to retrieve information about employees and projects initiated prior to the year 2024. Additionally, year extraction from a DateFormat column.\n\nAll coding tasks were conducted on Coderpad, where you needed to execute the scripts to showcase the results accurately.

Hour-Long Technical Interview\n\nPython Questions:\n\nReverse Substring in String (without using slices):\nI was tasked with reversing a substring within a give