Tsql Developer

• Role & responsibilities:

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.
• 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..