Senior Systems Architect (SQL)

Experienced Recruiting Partners

Senior Systems Architect (SQL)

Albany, NY
Full Time
Paid
  • Responsibilities

    Location: Onsite in Albany, NY

    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.

     

    Qualifications:

    60 - 84 Months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

     

    Preferred Qualifications:

    • 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)