Process
I have an interview in UBS in May 2021, Firstly they will shortlist your CV if it matches with their requirements then the first round will be the Technical round by AVP. They will ask you questions as per your year of experience in the Oracle PL-SQL, SQL & UNIX shell scripting. He or she will fire you questions as per the ranking you give for the particular skill out of 5. They will find out if the candidate who will strong in basics of PL-SQL as well as advanced PL-SQL, performance tuning, Bulk collect, Indexing and partitioning. Most of the questions were scenario based. Below are the questions for your reference.
Questions
What is local & global indexes ?
Partitioning of tables and types
What is partition pruning?
Which command is used in Unix to find 1 month older file?
What are locks & what is deadlock condition?
Performance tuning techniques for poor performance queries
Was this helpful?
Interview Statistics
The following metrics were computed from 2 interview experiences for the UBS Senior Developer role in Pune, India.
Success Rate
UBS's interview process for their Senior Developer roles in Pune, India is extremely selective, failing the vast majority of engineers.
Experience Rating
Candidates reported having very good feelings for UBS's Senior Developer interview process in Pune, India.
