New

Position Applying For:Legacy Systems Specialist I

Join & Explore The Possibilities at BuzzClan

  • Legacy Systems Specialist I  | USA-CO-Denver  |  | 23-JUN-21 
    Perform analysis of Oracle database data, data models, and advise client on the best way to transform and integrate required data into modified source database structures required to support modernized Trails application. 
    
·         Understand legacy systems and processes and provide analysis of impacts and risks associated with bridging of source data to legacy database
    
·         Responsible for identifying and testing data bridges between legacy and modernized  database structures. 
    
·         Analyze and identify risks associated with bug workarounds that impact the data and database
    
·         Contribute toward root cause analysis of data related defects
    
·         Support integrated testing of interfaces and validation of data mapping, data migration, as well as data  conversion activities conducted during pre go-live and post go-live activities
    
·         Act in the role of Data Steward including creating data artifacts and add, change or delete within existing Erwin DIS
    
 

    Qualifications

    Resource Requirements
    
·         Deep understanding of Extract, Transform, Load (ETL) concepts and tools (Toad, SQL Developer)
    
·         Demonstrated high level of understanding of ETL development concepts & patterns
    
·         Data Migration ­ 3+ years
    
·         Data Conversion ­ 3+ years
    
·         Data Mapping, Data Modeling, and Analysis ­ 3+ years
    
·         Data Validation  3+ years
    
·         Strong analytical skills with a focus on ensuring data integrity, access and security
    
·         Reporting and data visualization skills using software such as Visio, Tableau, Crystal Reports
    
·         Experience utilizing data governance software such as erwin preferred
    
·         Familiar with Oracle db environments, PL/SQL, SQL Plus, Oracle 19c experience preferred
    
·         Experience utilizing other development tools (TFS, Azure DevOps, No-SQL, MongoDB, Mulesoft) 
    
·         Experience working with State of Colorado agencies preferred