Offer summary

Qualifications:

8+ years of experience in SQL Server and advanced SQL concepts., Proficiency in SSIS, SSRS, and Crystal Reports., Experience with Azure Data Services including SQL Azure and Data Factory., Development experience with .NET and Web API is a plus..

Key responsibilities:

Design and develop SQL Server tables, stored procedures, and functions for ETL processes.

Create and test SSIS packages to prepare data from various systems.

Implement data transformations and ensure efficient data movement using SSIS.

Develop strategies for data migration, restoration, and archival between sources and destinations.

Job description

Experience - 8+yrs

Location - Remote

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