ETL Database Specialist

Full Time
Washington, DC 20002
Posted
Job description

Responsibilities:

  • Perform dataset assessment of AWS doee-libera-data
  • Derive data migration plan.
  • Help with normalizing data from undetermined file format.
  • Derive schema documentation for LIBERA and ECOS (LIBERA will be sunset)
  • Derive data dictionary for mapping of fields to ECOS database.
  • Derive documentation for dashboard and visualization development.
  • Derive process flows for data conversion and migration processes.
  • Conversion and dataset migration requirements for LIBERA to ECOS
  • Derive scripts/data-matching process between LIBERA database and ECOS dataset.
  • QA/QC test data migration effort
  • Experience with handling sensitive data to be migrated.
  • Provides all activities related to the administration of computerized databases.
  • Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function.
  • Designs, creates, and maintains databases in a client/server environment.
  • Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.
  • Advises users on access to various client/server databases.
  • Designs, implements, and maintains complex databases with respect to Job Control Language (JCL), access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
  • Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., Cognos)/back-end programming languages (e.g., Structured Query Language (SQL).
  • Performs database programming and supports systems design.
  • Additional duties include maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

Minimum Education/Certification Requirements:

  • Bachelor’s degree in IT or related field or equivalent experience

Job Types: Full-time, Contract

Pay: Up to $38.00 per hour

Benefits:

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Employee assistance program
  • Employee discount
  • Flexible spending account
  • Health insurance
  • Life insurance
  • Paid time off
  • Professional development assistance
  • Referral program
  • Tuition reimbursement
  • Vision insurance

Schedule:

  • 8 hour shift
  • Day shift

COVID-19 considerations:
All employees are required to show proof of Covid-19 vaccination. If asking for an exemption, candidates agree to be subjected to a weekly Covid-19 test.

Ability to commute/relocate:

  • Washington, DC 20002: Reliably commute or planning to relocate before starting work (Required)

Education:

  • Bachelor's (Required)

Experience:

  • data conversion tools: 8 years (Required)
  • Design, create, and maintain databases: 8 years (Required)
  • SQL: 8 years (Required)
  • Database migration: 8 years (Required)
  • Database Normalization: 8 years (Required)
  • Perform Dataset assessment: 8 years (Required)
  • Derive process flows for data conversion and migration: 8 years (Required)
  • Conversion of dataset, formatting, and dataset migration: 8 years (Required)

Work Location: One location

arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, arclintfl.com is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs