1st round with Manager : Most of the questions on current project, SQL - Window Function, Python -Stacks.
2nd round with Senior Manager - SQL - Window Functions(optimal code), Python(basics)-Optimal and Secanrio based question.
Interview questions [1]
Question 1
Explain about current project?
In and out of my current project including datasets, tools and technologies etc..,
Never give interview there are lot of cases where they ask to resign and don’t give offer letter and ghost candidates. It’s a fraud company. Interview process is very bad as well interviewer are not that knowledgable
I applied online. The process took 6 weeks. I interviewed at EXL Service (Irving, TX)
Interview
3 Rounds of Interview
Round 1: Technical Interview with coding assessment on Python and SQL
Round 2: Technical Interview on SQL, PLSQL, PySpark, GCP Services and Scenario based questions.
Round 3: Client Interview very specific to domain, I was asked on ETL Pipeline building, edge cases, Coding assessment on Python, SQL, PLSQL, PySpark
Interview questions [1]
Question 1
Design an ETL pipeline that loads data every hour from X system to Y System with consistency and reliability describing edge cases.
