Roles & Responsibilities:
- Responsible for Creating /modifying stored procedures, functions, triggers, views as per the business requirement.
- Analyze the existing database objects and optimize it for better performance.
- Responsible for bulk load / modifying the data from the back end.
- Develop SSIS Package to load or export the data between different sources (Database to
- Database, Flat files to Database, Database to Excel/CSV/Text).
- Develop SSRS Reports for the business requirement.
- Understand the bug/enhancement requirements and modify/develop TSQL objects as per the business requirement.
Requirements:
- Good knowledge of Microsoft SQL Server 2012 with 3-4 Years of experience in Power BI with
Tableau. - Good in DB design and DB Normalization
- Good knowledge of SQL including troubleshooting and tuning.
- Good knowledge of SSIS, SSRS and SSAS
- General SQL performance and tuning skills including server configuration and tracing facilities.
- General working knowledge of job scheduling.
- Strong sense of customer commitment, loyalty, and urgency