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