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 API
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
Added Advantages:
- Knowledge of Power BI & development experience
- Certifications - MCSA, BI, MCSD
