1st round was a self-assessment coding round on coderbyte platform, it was 4 hours long and there was 1 SQL question, 1 python sliding window question, 1 AWS question and multiple ci/cd conceptual questions. 2nd round was a technical round on python and SQL this was average. 3rd round was with the director about previous work experience, and some conceptual questions on PySpark, i felt i did okay in this but this is where i was rejected