Title : Sr SQL Server Developer
Location : Remote work
Responsibilities:
- Rich programming experience in coding using T-SQL, Stored Procedures/Functions, Triggers, Views.
- experience in Database design and Back-up of SQL Server 2005/2008/2012.
- Involving in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008/2012 and SSIS in Business Intelligence Development Studio (BIDS).
- Analyzed the different source system data to be used in building the target system
- Involved in data mapping and created packages in SSIS 2012 using various Control flows and data flow Transformations to implement Business Rules.
- Involved in configuring packages and deploying and scheduling SSIS Packages.
- Prepared the complete data mapping and Report Definitions for the project
- Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
- ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Apply data modeling techniques to ensure development and implementation support efforts to meet integration and performance expectations.
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes.