EY ETL Testing interview questions

There were 2 tech round and both were fully technical, Overall it was a great experience. Tech 1: had questions related to co-related subquery, rank - dense rank, where and having and basics, They also asked me about Python Dataframe and list and tuples. Tech 2: It was moderate level interview, they had more of scenario type questions like query to get data from subquery which is used in outer query, Python code to extract data from multiple sources and AI related queries as well.