Analysis Skills, Data Migration, Data Modeling, Data Quality, Database Extract Transform and Load (ETL), Documentation, Microsoft Visio, Process Development, Process Modeling, Quality Assurance, Reconciliation, Requirements Management, SQL (Structured Query Language), System Architecture, Team Player, Test Plan/Schedule, Testing
Day-to-Day Tasks:
- 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.
- 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.
Requested Qualifications:
- 60 months of experience working on projects involving tasks related to design/development/testing for the migration of legacy data, 10%2B 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)