I applied through a recruiter. I interviewed at Lore Software Solutions (New York, NY) in Apr 2018
Interview
There was total 4 rounds
1.Aptitude(verbals,maths=15)(10 Unix 10 SQL) and you will have 1 hour time
2.Technical f2f(basics on SQL)
3.f2f
4.HR round (self introduction)
And u have to sign for 18 months bond and provide 10th marks card