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, AzureData Factory and DAX on Azure Platform is good to have.Experience in Cloud Platforms, Azure technologies likeAzure Analysis Services, etc. is good to have.Experience in CRM systems like sales force is good to have.Experience working with dataset ingestion, data modelcreation, reports, dashboards, etc is good to have.Experience in other reporting tools is good to have.Demonstrated Ability to use GIT, Jenkins and other changemanagement tools is good to have.Good knowledge of database performance and tuning,troubleshooting and query optimization.Skills Required
T-SQL Experience, ETL load issues, Development of E2E BI