Principal Technical Specialist

Job Title: Senior Technical Specialist
Education: B.E\B.Tech\MCA\B.SC
Experience: 8+Years
Location: Hyderabad / Bangalore / Mumbai

Key Skills: SQL Server, MSBI, SSRS, SQL, Power BI

Job Description:

1. Required experience in MSSQL server programming.
2. Required experience in implementing RDBMS tables and it s maintenance.
3. Required experience in Implementing, maintaining DB objects such that Stored procedure, Triggers, User Functions etc.
4. Required experience in Implementing, maintaining JOBs and its Agents.
5. Required experience in Dynamic queries
6. Should have experience in Optimization and its techniques.
7. Should be able to maintain DB objects version control
8. Required experience in exporting db scripts for deployment across different environments.
9. Contribute to the Reports development lifecycle including understanding of requirements, designing and development of reports.
10. Creating SQL Queries to provide ad-hoc reports, analysis, and datasets based on business needs.
11. Should have experience in creating parameterized reports, Drilldown and Drill through reports, Block report and Matrix Report.
12. Should have experience SSRS expressions, Sub reports in SSRS.
13. Should have experience to display data form multiple Dataset in the single Tablix.
14. Application of the Raw grouping and Colum grouping to fetch Total, Subtotal report.
15. Worked with report manager for deploying the reports across all the environments.
16. Support the day-to-day performance, maintenance, and monitoring of SQL/SSRS reports and interfaces.
17. Ensure that proper controls are in place so that reports are accurate and timely resolve any issues/errors.
18. Should have experience in deployment of reports to SSRS server and configured to Shared Database.
19. Should have experience in creating Static and Data driven Subscription.
20. Should be knowing the Power Bi Desktop to develop the Power Bi reports.
21. Should have experience in Power bi Deployment in Power Bi Services.
22. Should have experience Power Query and its transformations.
23. Should have experience in Data Modelling.
24. Should have experience in data visualization and use the correct visualization for required business needs.
25. Should have experience in creating and maintaining workspace.
26. Experience in the making report attractive by applying expression for Fonts, Fill color etc.
27. Create and manage data models that support the organizations reporting and analytics requirements.