SQL expertise were not able to write simple queries in the interview.
So from now please screen the candidates well and make sure they have expert knowledge on SQL and tableau.
Pls be informed that we will have practical SQL questions in the interview where candidate may be asked to write queries on the fly.
Responsibilities
· Strong ability in translating business requirements and needs into analytic solutions, within multiple areas in IT and with various stakeholders, including key leaders and managers
· Leverage data to understand in depth IT business processes, identify areas of opportunity for process improvement.
Write queries, analyze, visualize, and provide analytics on data to build reporting solutions to support various company initiatives. E.g., build rich and dynamic dashboards using Tableau
· Develop deep understanding of analytical data models
· Support project development life cycles through data modeling, reporting and analytics
· Participate in the on-going development of the business intelligence and data warehousing functions within the wider organization
· Create training materials to guide business users on how to use dashboards
· Participate in the creation and support of development standards and best practices
· Explore and recommend emerging technologies and techniques to support/enhance BI landscape components
· Automate solutions where appropriate.
Must have Skills
· Strong SQL Skills is a MUST ( CT , LEFT/RIGHT/INNER JOIN, Subqueries, Correlated subqueries, Nested queries, Rankin window functions, Handling time series using window function (LAG/LEAD))
· At least 4-6 years of business intelligence and data warehouse experience
· At least 2 year of experience with Tableau
· Prefer a candidate with scripting experience (Python/R/Javascript/PHP/ Perl/Ruby/etc.)
· Prefer a candidate with experience building and maintaining pipelines
· Knowledge of ETL processes and designs
- SQL Level of expertise
| Basic / Medium /Expert |
- Table level of expertise
| Basic /Medium /Expert |
- Working experience on below mentioned SQL/Topics
| Topics | Yes/No | | CTE | | | LEFT/RIGHT/INNER JOIN | | | Subqueries | | | Correlated subqueries | | | Nested Queries | | | Ranking window functions | | | Handling time series using window function (LAG/LEAD) | | |
| 4. Tableau Working experience on below | Topics | Yes/No | | Relationship feature in tableau and how it works, when to use and when not to use | (Would be nice to get descriptive feedback for this particular skill) | | LOD Expressions | | | Tableau calculations | | | Custom Sorting | | | Dashboard and Worksheet actions | | | Tableaus order of operations | | | Dashboard Design | | |
| 5. Database Working experience on below (Optional) | Topics | Yes/No | | Normalization (3NF) concepts and when to | | | Denormalization concepts and when to | | | Relationship between entities (1:1, 1:m, m:1, m:m). | Any real life experience working with these relationships and how was it handled at BI layer.(Would be nice to get descriptive feedback for this particular skill) | |