Job Description

Reference # : 20-00103Title : 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:

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online