I applied through a recruiter. The process took 5 days. I interviewed at R Systems (Pune) in Oct 2024
Interview
Fast and Easy. Two technical rounds 1 HR round. L1 was conducted by R systems and L2 was of client side. L1 and L2 happened within 2 days. HR is also communication friendly.
Interview questions [1]
Question 1
what is surrogate key, explain scd type 2 informatica, how to improve query performance in sql, explain your projects, how to find duplicates, how to delete duplicates, joins in sql, difference between lookup and joiner, which one is faster, types of lookup
