Oracle Data Migration Developer

Location: Albany, NY
Date Posted: 07-02-2018
Oracle Data Migration Developer
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.

Duties include but are not limited to:
  • 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.

Candidates should have at least 84 months experience and a majority of the following should apply: 
Each candidate should fill out the months of experience they have for each item in the table:
1. Bachelor’s Degree in Computer Science, Information Technology or related field. #of months 10
2. At least 84 months experience performing 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

Key Business Solutions, Inc.

|| Office: 916 646 2080 Ext 227 || Fax: 916 646 2081
Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
this job portal is powered by CATS