SQL DBA + SSIS developer

Requirement Title :Require ExperiencedSQL DBA + SSISdeveloper

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