System Architect / Lead ETL Data Migration

  • Albany, NY
  • Posted 11 hours ago | Updated 11 hours ago

Overview

On Site
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - 30 Month(s)

Skills

Requirements Elicitation
DMV
Quality Assurance
Computer Hardware
Interfaces
Development Testing
Migration
SQL
Testing
Data Validation
Test Plans
Workflow
Modeling
Microsoft Visio
Data Modeling
Extract
Transform
Load
Data Migration
IBM InfoSphere DataStage
IBM InfoSphere

Job Details

Role : System Architect/ Lead ETL Data Migration

Experience : 14+ Years

Location : Albany, NY (Day1 Onsite)

Description

Agency is seeking a Senior Architect to work with staff for the purpose of analyzing, developing, and testing for all aspects of the NYS DMV data migration modernization initiative. The DMV Transformation program is a multi-phase, multi-year program, which includes multi phases of modernization projects.

Duties

  • The candidate will analyze, design/functional specifications which adhere to IT standards and policies.
  • Migrate data to appropriate repositories.
  • Participate in requirement gathering and design discussions.
  • Verbally communicate with senior IT SMEs to elicit requirements.
  • Responsible for developing ETL processes for the migration of NYS DMV legacy data.
  • Work in a team environment, as well as independently.
  • Comply with data standards and policies. Assist with Quality Assurance testing.

Mandatory Requirements

  • Experience (14+Years)
  • Systems Architect Defines the architecture of a computerized system (i.e., a system composed of software and hardware) in order to fulfill certain requirement, including a breakdown of the system into components, the component interactions and interfaces (including with the environment, especially the user), and the technologies and resources to be used in the design.

Requirements

  • This is an 100% Onsite
  • 60 months' experience working on projects involving tasks related to design/development/testing for the migration of legacy data, 10+ data sources
  • 60 months of SQL experience
  • 60 months experience testing experience, including: Data Validation, creating comprehensive test plans, executing test plans, and reconciliation of data migrations
  • 60 months experience: Documenting workflow processes in modeling tools (such as Visio), Data Modeling
  • 60 months' experience with ETL (data migration) using Data Stage (IBM Infosphere)
  • R sum
  • Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable)
  • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Maagsoft Inc.