Job Description :

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

Scope of Work

Contractor, will be working on the Department of Human Services Trails Product and shall provide the Services as follows:

  • Perform analysis of Oracle database data, data models, and advise OIT and CDHS 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

Similar Jobs you may be interested in ..