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