> Markdown version of [/jobs/ext/284575-lead-etl-data-migration-consultant-with-datastage](https://www.wearedevelopers.com/jobs/ext/284575-lead-etl-data-migration-consultant-with-datastage). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead ETL/Data Migration Consultant with DataStage

- **Company:** Sligo Software Solutions Inc.
- **Location:** Albany, NY, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Validation, Data Governance, Extract Transform Load (ETL), Data Migration, IBM InfoSphere DataStage, IBM InfoSphere (ETL Tools), Microsoft Visio, PeopleSoft Customer Relationship Management (CRM), SQL Databases, Test Execution Engine, People Soft
- **Published:** May 17, 2026
- **Apply:** https://www.careerjet.com/jobad/us0f1f028267eeff354a73c4ba54e1d694

## About the Role

* 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., * This is an 100% Onsite.
 * 60 months of 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 of testing experience, including: Data Validation, creating comprehensive test plans, executing test plans, and reconciliation of data migrations.
 * 60 months of experience: Documenting workflow processes in modeling tools (such as Visio), Data Modeling.
 * 60 months of experience with ETL (data migration) using Data Stage (IBM Infosphere).
 * R sum
 * Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
 * Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

## 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

 * Participate in requirement gathering and design discussions.
 * Speak directly 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.
 * Initiate training to learn new technologies and methodologies that demonstrate value.
 * Assist with Quality Assurance testing., CLIENT IS NOT LOOKING FOR TECHNO FUNCTIONASL CONSULTANT PeopleSoft Business Analyst PeopleSoft CRM, HCM & Financials Modules Data Migration, PL/SQL Development, and Cross-Envi…
 + 17 hours ago
 + Apply easily


## Related Videos

- [Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client](https://www.wearedevelopers.com/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [The Chief Joy Officer and Decoding Motivation@Work](https://www.wearedevelopers.com/videos/1501-the-chief-joy-officer-and-decoding-motivation-work)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [What is Software Engineering?](https://www.wearedevelopers.com/magazine/289-what-is-software-engineering)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)