I applied through a staffing agency. The process took 4 days. I interviewed at Seven Lakes Technologies (Pune) in Mar 2015
Interview
Simple and smooth. 4 rounds - Technical Round (SQL andDWH), Aptitude, Technical Round 2 (DWH) and HR Round.
All rounds were quick and results followed after every round. Interviewers were friendly and supportive. Altogether good experience were your resume is read at least.
Interview questions [1]
Question 1
They would like to know your knowledge on the projects you handled. Its good people are looking for what you know and not how much of you answer their questions.
1) SQL queries based on Case / Coalesce / Null values/ Joins
2) Data Mart/ Schema
3) Example of SCD from your projects.
I applied through a recruiter. The process took 1+ week. I interviewed at Seven Lakes Technologies (Bengaluru) in Jul 2015
Interview
First round will be Aptitude test to check the analytical skills and further there will be 3 technical rounds based on the requirement and prior experience. Finally there will be salary discussion.
Interview questions [1]
Question 1
Its more over about the ETL & Data centric and based on prior experience
I applied through a recruiter. The process took 3 days. I interviewed at Seven Lakes Technologies in Mar 2015
Interview
2 technical rounds with 1 online test. Last 1 with a director
Very easy interview as interviewer knowledge is less.
Most of question will be very basic SQL and excel techniques.