Job Details

ID #4891387
Estado Distrito de Columbia
Ciudad Usdc
Tipo de trabajo Full-time
Salario USD TBD TBD
Fuente Teracore
Showed 2020-09-25
Fecha 2020-09-25
Fecha tope 2020-11-24
Categoría Etcétera
Crear un currículum vítae

Database Specialist

Distrito de Columbia, Usdc 00000 Usdc USA

Vacancy caducado!

Job Description

Position Description:

The Database Specialistshall support the data transition from the legacy financial and procurement systems (Core Account System Suite) to our client's new financial, procurement and asset management system (Financial Systems Modernization Solution – FSMS). To support the data migration, the Database Specialist will assist with planning and preliminary analysis of the data; data crosswalk preparation; data analysis; data cleansing and testing; and mock data preparation. The Database Specialist shall have specific knowledge of Red Hat Linux, and be able to perform Extract, Transform, and Load (ETL) work from Excel, text, CSV, Oracle and ODBC data sets. Highly preferable,the specialist will also have experience with migrating from SAS 9.4 to SAS Viya.

The candidate shall possess:

  • Support the data migration, assist with planning and preliminary analysis of the data; data crosswalk preparation; data analysis; data cleansing and testing; and mock data preparation.
  • Specific knowledge of, Red Hat Linux, and be able to perform Extract, Transform, and Load (ETL) work from Excel, text, CSV, Oracle and ODBC data sets. SAS Viya knowledge is a strong plus.
  • Preferably migrating from SAS 9.4 to SAS Viya.
  • Have experience with and be thoroughly versed in Oracle Federal Financials R12.7 and SAS Viya.
  • Shall will develop data marts for conversion into data sets, and maintain or help maintain documentation on all new data sets and processes created.

Qualifications

Required Skills:

  • Bachelor’s Degree in a related field.
  • Ability to work multiple tasks on an ongoing basis.
  • 2 plus years of experience performing ODI development in an Oracle BI Applications environment to customize/enhance COTS product offering.
  • 2 plus years of configuration/administration experience with ODI in an OBIA environment.
  • Ability to work with teams.

Desired Skills:

  • 2 plus years of hands-on project experience in OBIEE/OBIA Development
  • 2 plus years of Federal Financial experience working with a Federal agency
  • Will have experience with and be thoroughly versed in Oracle Federal Financials R12 and SAS Viya.
  • Will work with Coast Guard personnel as well as any other contractors that Coast Guard currently has or may add in the future.
  • Will develop data marts for conversion into data sets, and maintain or help maintain documentation on all new data sets and processes created.
  • Supports the development of data extraction, transformation, and load scripts to pull data from the source applications and populate the conversion templates for loading data into the target applications
  • Support the development of unit test plans, performing unit tests, and documenting the results
  • Have excellent problem solving skills.
  • Be an effective communicator, verbally and written.

Clearance Required:

  • US Citizenship and background investigation required to attain favorable entry on duty (EOD)/public trust clearance.

Additional Information

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. All your information will be kept confidential according to EEO guidelines.

Vacancy caducado!

Suscribir Reportar trabajo