T-SQL Power BI Tech Lead

6 - 10 years

12.0 - 20.0 Lacs P.A.

Bengaluru

Posted:2 months ago| Platform: Naukri logo

AI Match Score
Apply Now

Skills Required

technicalbidata warehousingdbmsazure data factoryt-sqldashboardssqlgitdesignjenkinse2edaxetlssasmicrosoft azurepower biazure analysis servicesapplication developmentapp developmenttdata warehousing conceptstroubleshootingsql codereporting tools

Work Mode

Work from Office

Job Type

Full Time

Job Description

Must have, 5-9 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. Nice 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.

Information Technology and Services
Bengaluru

RecommendedJobs for You

Chennai, Pune, Mumbai, Bengaluru, Gurgaon

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

Pune, Bengaluru, Mumbai (All Areas)