|Reference # :||20-00103||Title :||IT Specialist|
|Location :||Albany, NY|
|Position Type :||Contract|
|Experience Level :||Start Date :||01/24/2020|
Rent Regulation System Modernization
The RRSM project will result in a solution that will address the business transformation of three core business functions and the development of a modern, web-based application and reporting system for Homes and Community Renewal's Office of Rent Administration (ORA), the Tenant Protection Unit (TPU) and the General Counsel's office.
Perform all stages of data migration from data analysis to pre go-live validations, user acceptance testing, user sign-off, cut-over planning and post go-live validations. Interact with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration. Develop logical and physical data model for OLTP system. Design, develop and maintain data migration programs and manage migration tools using SQL Server Integration Services (SSIS) and T-SQL. Develop data quality reports for the business to identify and drive data cleansing and remediation efforts. Writing T-SQL for data validation and post conversion reports. Develop complex queries using T-SQL.
Document data extraction, mapping, cleansing and migration processes.
Please see our complete list of jobs at: