Questions regarding experience & behavioral in nature. What if, scenarios. What are your expectations from your manager, etc. The technical interview centered around the virtual technical that I had received where they wanted to understand my thought process.
Difference between Having and where clause in SQl server?
had a phone call interview with the client manager to describe about the previous experience and also had some technical discussion about cognos reports and framework manager. Also asked questions about how the FM models are built and also multi dimensional models.
My Professional Interests and Future Plans
All BI and Dwh questions
I was given a technical task that required creating a Power BI dashboard using a specific dataset. It was pretty much open in terms of what to include in the dashboard.
Describe a complex project you had to complete in SQL. What were the objectives at the outset? What were the results at the end? Can you describe some of the more complicated pieces of code you wrote? Describe your experiences with data validation, data clean-up, moving data between sources, e.g. Excel To SQL & Vice Versa. What were your objectives at the start of these respective exercises? What techniques did you use? What was the end result?
Standard Qlik & PBI questions, analysing a load script and talking through the pros and cons of both tools, where each one fits into the BI stack. Scenario based questions on my experience of working with Qlik, and of projects where we have solved a business problem by providing insights and analysis using the tooling. Overall this was a really enjoyable process with an interviewer who was able to provide a clear and concise data strategy, explaining where the role fits, how they work with stakeholders, and the direction the team are moving in. Very good remuneration for the job grade with excellent benefits, but in the end I declined as was offered a more senior role
What frustrates you about your job?
Many questions that relate to BI developer. Some require in depth knowledge of T-SQL and a general overview of SSIS.
Viewing 111 - 120 interview questions