Job Detail
-
Job ID 81361
Experience 3 - 6
Job Description
Job Description:
● 2-5 Years of experience in the Design and Development of E2E BI & Analytics projects in a global enterprise environment.
● Strong T-SQL Experience (Defect triaging, Build T-SQL procedures, TVF, Views, Ragged hierarchy, Cursors, Loops, Working with local/global parameters, Reports. ability to review an existing T-SQL code block, ETL load issues, identify performance bottlenecks and tune where required. Articulate the changes and root-cause to the manager)
● Good knowledge of database performance and tuning, troubleshooting and query optimization.
● Proficient in Data warehouse design and BI application development
● Deep understanding of writing SQL code. Good to have - Experience in Power BI, SSAS tabular modelling, Azure Data Factory and DAX on Azure Platform is good to have.
● Experience in Cloud Platforms, Azure technologies like Azure Analysis Services, etc. is good to have.
● Experience in CRM systems like sales force is good to have.
● Experience working with dataset ingestion, data model creation, reports, dashboards, etc is good to have.
● Experience in other reporting tools is good to have.
● Demonstrated Ability to use GIT, Jenkins and other change management tools is good to have.
● Good knowledge of database performance and tuning, troubleshooting and query optimization
