I applied through a recruiter. The process took 3 weeks. I interviewed at Focus Technology Solutions, Inc. (Boston, MA) in Feb 2022
Interview
I had total 4 interviews. 1st was technical with mostly SQL questions about query optimization and system tables with window functions. Few python question about ingesting JSON file.
2nd interview was with manager discussing around my experience in health care industry.
Interview questions [1]
Question 1
Pulling schema information for table with their types and if there is any index on any column