Lead ETL/Data Migration Consultant

Overview

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

Skills

SQL
Data Modeling
Test Plans
documenting
visio
Data Validation
data migrations
ETL (data migration
Data Stage (IBM Infosphere)

Job Details

Greetings from Sligo Software Solutions, Inc. !!

This is Yashwanth from SLIGO. We have an urgent requirement for Lead ETL/Data Migration Consultant position with our client.
Title : Lead ETL/Data Migration Consultant
Location : Albany, New York
Duration : 30 Months
Client : NY State - Information Technology Services (ITS)
Job ID: SLG - 19 - 11215
Respond by: 10/15/25 5:00 PM

Description

Agency is seeking a Senior Systems 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 (12+ Years)
  • 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 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 Sligo Software Solutions Inc.,