Sr SQLServer_Database Developer(#8+years # Contract #Remote #Immediate #Max 15LPA

SQL Server Database developer:Experience 8+ years.Budget: 1.2Lakhs per monthDuration: 3-6 monthsLocation: Remote

Primary Skills:SQL Server & Advance SQL concepts SSRS & Crystal Reports SSIS and its concepts with SQL Jobs & profiler Azure Data Services (SQL Azure, Azure Data Factory, Data lake)Experience of Data Migration, Restoration & Archival Prior development experience with .NET & Web

Roles & Responsibilities:i. Design and develop SQL Server table, stored procedures, functions, views and triggers to be used during the ETL process.ii. Designing and developing SSIS packages, Test & prepare SQL ETL solutions to acquire and prepare data from numerous systems for ORMiii. Builds data transformations with SSIS including importing data from files, moving data from one database platform to anotheriv. Working with SSIS package, Test & prepare ETL processes to ensure accurate and efficient movement of datav. Develop strategies to migrate, restore, backup, archive data between sources and warehouse destinationsvi. Provide support and acceptance testing including the development or refinement of test plans

Will added DQA skills below:Responsible for test plan, strategy, and test data preparation as well as reporting and tracking defects to closure.Data flow validation from the staging area to intermediate tables, surrogate key checks, and data transformation rules validation.Collaborate with BAs to understand ETL Requirements, create.Traceability matrix to map user stories to specific test cases.Coordinate with development to track, test and validate bug fixes, RCA of defects.Experience with different defect management tools such as HP ALM & JIRAWork with Software quality assurance processes.Certification in relevant testing technologies will be a plus.

Key Skills

• .NET Framework