Remote Jobs
DOEE ETL Database Specialist Journeyman
NewWhat's your preference?
Job Description
- Req#: 15818
8 years of experience. Provides all activities related to the administration of computerized databases.
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.
1. Provides all activities related to the administration of computerized databases.
2. Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function.
3. Designs, creates, and maintains databases in a client/server environment.
4. Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data.
5. Advises users on access to various client/server databases.
6. 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.
7. 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).
8. Performs database programming and supports systems design.
9. 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
Required/Desired Skills
SkillRequired /DesiredAmountof Experience designing, creating, and maintaining databases in a client/server environmentRequired8YearsSQL experienceRequired8YearsBachelor's degree in IT or related fieldRequired12YearsDatabase migrationRequired8YearsDatabase Normalization Required8YearsPerform Dataset assessmentRequired8YearsDerive process flows for data conversion and migration Required8YearsConversion of dataset, formatting, and dataset migration Required8YearsExperience in the use data conversion toolsRequired8Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidate's email address. Question3Candidates submitted above the NTE vendor rate of $$/hour will not be considered. Do you accept this requirement?Question4There are no reimbursable expenses. Do you accept this requirement?Question5Are you able to report in office.About the company
The best remote jobs for you
Notice
Talentify is 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 protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.