SQL DBA + SSIS developer

Requirement Title :   Require Experienced  SQL DBA + SSIS  developer

Availability  :   EST time zone  (  till 6 PM EST  ) - ( till 4.30 am IST- approximately)

Experience  : 8+ Years

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 :
• Design and develop SQL Server table, stored procedures, functions, views and triggers to be used during the ETL process
• Designing and developing SSIS packages, Test & prepare SQL ETL solutions to acquire and prepare data from numerous systems for ORM
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
• Working with SSIS package, Test & prepare ETL processes to ensure accurate and efficient movement of data
• Develop strategies to migrate, restore, backup, archive data between sources and warehouse destinations
• Provide support and acceptance testing including the development or refinement of test plans

Skills Required

Sql Server, Advanced Sql, Ssis, Sql Profiler, Ssrs, Crystal Reports