drjobs DBHDS - Data Migration Specialist

DBHDS - Data Migration Specialist

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Richmond - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Engagement Type

Contract

Short Description

Data Migration Specialist
ON SITE REQUIRED: 23 days/week
Pls note: Initial webbased interviews will be conducted; however the team may request a second round IN PERSON with the finalists.

Complete Description

A Data Migration Specialist is a professional who specializes in the movement of data from one system or platform to another.

Pls note: Initial webbased interviews will be conducted; however the team may request a second round IN PERSON with the finalists.


ON SITE REQUIRED: 23 days
No Parking provided for contractors

ABOUT THE ROLE

Main Responsibilities of a Data Migration Specialist

The following list describes the typical responsibilities and deliverables of a Data Migration Specialist:

  • Transform and load data into the respective data warehouse for a modernization initiative.
  • Transform data to meet target system requirements
  • Translate functional requirements into technical specifications for ETL development.
  • Troubleshoot and resolve data migration issues
  • Validate and analyze data sets to ensure data consistency and internal requirements are met.
  • Analyze DBDHS Legacy data data quality rules business rules data dictionaries
  • Analyze prepare and execute data cleansing services.
  • Analyze specify and document data migration requirements with clients and internal teams.
  • Articulate how Legacy data will be cleansed and adapted to fit into the new Future solution.
  • Assist others with the selection of approaches methods and / or services as required.
  • Attend Project standups and Stakeholder meetings
  • Champion standards and implementation process that you define with the team.
  • Collaborate with data architects to design data migration solutions
  • Collaborate with the IMS Business customers and the DBHDS EDW Team ensuring quicker and more accurate data management.
  • Complete assigned tasks in an organized manner to ensure project deadlines.
  • Develop and execute data migration process and procedures (from analysis to post implementation) including scripts and programs
  • Develop and execute test plans to ensure client requirements are fulfilled.
  • Contribute to the release and cutover strategy.
  • Coordinate with stakeholders to gather requirements and system assessments as it related to data.
  • Create and maintain utilities SQL scripts as needed to accelerate the process.
  • Ensure adherence to compliance needs for the agency.
  • Implement new Mapping and ETL scripts.
  • Lead data cleaning and dedupe program to drive accurate and complete data.
  • Maintain appropriate levels of data security and privacy relating to customer data.
  • Ensure documentation are created an maintained to enable migration process and post implementation support.
  • Create and Monitor data migration progress and build dashboards to support audit reconciliation and verification
  • Perform regular backups to ensure data preservation.
  • Propose a data migration and reconciliation strategy.
  • Represent DBHDS IT and the Data cleansing/migration initiative at meetups with DBHDS internal and external partners
  • Retrieve data from the database or electronic files as requested.
  • Validate postmigration results and communicate outcome with Key DBHDS Central Office Leadership and Business Stakeholders Key External DBHDS Reporting Stakeholders CO Security VITA and DBHDS IT.
  • Verify data by comparing it to source documents.
  • Write validation scripts to run over the Staging tables to report any invalid data.
Required/Desired Skills
Skill Required/Desired Amount of Experience Proficiency in data extraction and transformation tools Required 6 Years Strong SQL querying and scripting skills Required 7 Years Knowledge of and Experience with ELT/ETL processes Required 6 Years Familiarity with data modeling and database design principles Required 7 Years Understanding of data warehousing concepts and practices Required 7 Years Experience with data migration in largescale enterprise environments Required 7 Years Understanding of data synchronization and replication techniques Required 7 Years Strong analytical and problemsolving abilities Required 6 Years Critical thinking and decisionmaking skills Required 7 Years Ability to handle multiple tasks and prioritize effectively Required 6 Years Expertise in AWS Desired 2 Years Expertise in Snowflake Desired 2 Years
Questions
Description Question 1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment Question 2 Please list candidates email address. Question 3 In what city and state does your candidate CURRENTLY reside Question 4 The role requires 23 days ON SITE each week. If selected does your candidate agree to this arrangement

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.