It took 1 day for the interview as it was an offline process. First was an HR Round followed by 2 technical rounds .Profile was for RPA developer mostly on macros though later on I worked on AA and python as well. The first technical round had questions on macros .they started from basics like option explicit and find last row to functions and error handling. Since I mentioned SQL and python they asked questions on queries like nested / joins .