I applied through a recruiter. The process took 4 weeks. I interviewed at Viewics (Pune)
Interview
First they have a written test to test our SQL queries formation knowledge. I cleared that. Next i had two rounds of technical interviews. Cleared them both. Final HR round. Cleared all rounds, but no offer letter given. They asked me to wait and never sent offer letter.
Interview questions [1]
Question 1
Grain of fact, olap, oltp, cube concepts etc.
Questions on etl flow