Data Migration Oracle Data Quality OLTP SQL Specialist

Location: Albany, newyork
Date Posted: 08-28-2018
Data Migration Oracle Data Quality OLTP SQL Specialist
Albany, NY  
24 Months
Job Description:

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.

Skill matrix;
1. Bachelor’s Degree in Computer Science, Information Technology or related field. #of months 10
2. At least 84 months experience developing complex end-to-end data migration programs #of months 15
3. At least 60 months experience identifying and proposing resolution of data quality problems using tools such as Oracle Enterprise Data Quality or Experian Pandora. #of months 15
4. At least 84 months experience in creating logical and physical data models for OLTP systems #of months 15
5. At least 84 months experience in complex SQL development. #of months 15
6. At least 84 months experience in internal and external stakeholder communications and outreach, including the development of presentations and other materials #of months 10
this job portal is powered by CATS