The company pays below the average pay-scale of the Industry. There is lack of discipline and professionalism in Managers and employees. Company lacks in Infrastructure and this is a big setback.
I went there for an Interview on a technology, they are going to start working on and the first round was MCQ that included Reasoning, Aptitude and some SQL ques. Everybody was accommodated in a conference hall where it was quite difficult to solve questions by keeping question paper and answer sheet in hand as there was no desk. After submitting my answer sheet I was called immediately for Interview. In the interview hall I met with a person who seemed to have just come out of gym(His outfit). When he started asking questions I came to know that he know nothing about the technology. He was asking meaning less questions and whenI was asking further clarification he used to say forget it and fired next absurd question,
Example is
We have 3 Fact table(Sales, Date and Product) and 30 Dimension tables, now how will you form Schema out of these tables?
I asked:- Date and Product are fact tables?
And what about other 30 tables mean what is common column for joining purpose?
He told:- forget it
Then he asked:- Types of Schema and differences
I replied:- Star and Snowflake Schema.
He gave me a very simple scenario:- you have a report with year and month as prompt how will you ensure the total for the year is displayed at bottom
I replied: I will create a filter for year as parameter and apply total on Month.
He made face as he is dissatisfied
I replied:- I explained alternate way, using case statement.
He said "case when" will make report complex.
told:- forget it and asked similar meaning less questions 1 from mathematics and one from SQL(How to use dense rank function)
I understood that he is doing time pass.
Another thing was that there was a bond of 2 yrs for lateral hires, surprising.
This is not the reason of my conclusion that this is a bad company but I observed that organization lacks few things and that things are.
Professionalism
Infrastructure.
I am working for a tier-I indian IT MNC so I am comparing it from them and it is nowhere compared to tier-I IT companies. However people working for smaller companies may find it suitable.