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 processDesigning and developing SSIS packages, Test & prepare SQL ETL solutions to acquire and prepare data from numerous systems for ORMBuilds data transformations with SSIS including importing data from files, moving data from one database platform to anotherWorking with SSIS package, Test & prepare ETL processes to ensure accurate and efficient movement of dataDevelop strategies to migrate, restore, backup, archive data between sources and warehouse destinationsProvide support and acceptance testing including the development or refinement of test plansAdded Advantages :
Knowledge of Power BI & development experienceCertifications - MCSA, BI, MCSDSkills Required
Sql Server, Advanced Sql, Ssrs, Crystal Reports, Ssis