System Architect-W2

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)