Hexad Infosoft Interview Questions and Answers

Interview preparation tips for other job seekers - I interviewed with Techved consulting and had a horrible experience, it was like a bad dream.The process was a mess from start to finish ,process started with getting a call from the company HR, second interview was scheduled with CEO after 9 pm ,before logging in zoom call i confirmed with HR for the scheduled interview at 9 pm & was confirmed by HR ,waited for more than 15 minutes and nobody turned up ,after 9:15 pm HR says CEO is busy & rescheduled it to another day at same time 9 pm ,this time too before logging in I confirmed with HR if the CEO will turn up for the interview which I was told yes and I logged and waited for CEO to join but he didn't after multiple calls & Text to HR , finally CEO joins the meeting around 9:30 Pm,spoke to CEO for 10-15 minutes & he asked me to come down to his office for final conversation with him.Went to the mumbai office,they gave me a form to fill and strangely asked me to write an essay which i never did for any other company being having so many years of job experience.
And also till the time you don't reach their office HR will follow up with you like anything ,once you enter the office then it's totally a different world. Mine second half of the day was totally wasted they call me in goregaon office & intentionally eats your time for the meet which was mutually pre booked and confirmed scheduled.So after filling the form i was made to wait for long time before this person Francis comes who was never present in whole process and again takes the interview & he asked everything in detail of companies worked ,your targets ,incentives, remuneration etc and when asked him about his company salary & incentive structure he didn't reply & said that will be informed later also the budget they have is less of what I am expecting but the incentive is great and people are making three times of salary as their incentive ,asked him whats the target given on which he reply it will be informed later ,They want to ask you everything & when you ask them response is, it will be informed later .I told him I already had a discussion with another HR about the budget on which i was assured its fairly in range and also I am here as per the CEO, for meeting him for final discussion.After that I was again made to wait for more than a hour and they keep moving you from 1st floor to 2nd floor as per their small conference room availability.After waiting for about 3 hour I told the HR that I am getting late & will be leaving as I have another work commitment on which HR looks for CEO and ask me to wait for few more minutes,just when I was about to meet CEO, Francis ask me to wait and sends a girl who came to interview much after me being there, which was highly unprofessional & then francis ask me to meet another guy on different floor for interview before meeting the CEO ,gave the interview to this new guy and again they want to know everything about you and when u ask about the job nature and process he said he is from finance team once you join the team will guide u ,also they don't pay u for the days you worked for since their salary cycle is 20 to 21 and they hold employee salary of the 10 days and give it as FNF when employee resigns which is absurd .So after extensively speaking with HR & CEO on call along with waiting for more than 3 hour Francis comes an says that I have more experience and they are looking for a junior role with less experience and I can leave now,I told him I spoke extensively with HR and also with the CEO ,who invited me for the final meeting .First company found where the HR is more powerful than CEO & override CEO commitment & does insult candidate with zero respect for candidate time. Too many hints they gave as Red Flag ,it's a typical lala company with baniya employees behaviour.
-10 rating for Techwait Insulting company
Ceo should make their HR write an essay on basic human interaction,work ethics ,Time management, professionalism & Toxic traits.
Life Tip - before joining this company make sure you have a good Health & Term insurance .

Interview preparation tips for other job seekers - Got the invite through naukri.com
On day 1 there were 3 rounds.
1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.
2nd round was HR round where resume related questions like qualification and projects are asked along with a basic question of interest in this field. This round will be of 5 to 15 minutes max.
3rd round was technical round where questions related to the technical expertise is asked. This round is a bit tough but if prepared well in advanced can be done easily. This round will last upto somewhere around 30 to 45 mins on an avg.
All the rounds were of basic level but the wait time is more as there were many candidates for the post.
Tip: prepare well with basic SQL queries as they are mostly asked and if answered well gives an advantage.

After these three rounds was asked to wait for 1 week for the results.

Qs
1. What is the difference between DDL and DML?
2. How to fetch a employee record with the second highest salary from the employees table?
3. What was one of the trickiest incident you have faced and how did you counter it?
4. How SQL is divided?
5. Difference between SQL and MYSQL
6. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
7. Define SQL set using some examples.
8. Define joins using examples.
9. What is a constraint?
10. What is primary key?
11. What is foreign key?
12. What is tableau?
13. How tableau connection is established?
14. How many types of filters are there in tableau?
15. How KPI metrics can be depicted in tableau?
16. How dashboards are made?
17. What is the difference between dashborading and report generation?
18. What is storytelling?
19. Difference between Power BI and tableau
20. Which one do you prefer tableau or Power BI and why?
21. Data types in SQL

Interview preparation tips for other job seekers - When I was cleared my all round of interview and then HR comes to me and said 'congratulations you are selected ' and please come tomorrow for the documentation. Tomorrow the HR assign me the task of assessment, that was not acceptable 😑 because I was cleared my all round off interview and they told me to come for the documentation. On the last day I was resigned my last company because I got selected. But this situation is very difficult for me whether I failed assessment then they reject me. I did my assessment and have cleared 🙌 and then they told me for typing test which results is passes and then they started the documentation. It takes approx 21 days to get offer letter.

Interview preparation tips for other job seekers - Remote work although partially supported, is highly discouraged.