Data Migration Specialist
Richmond, VA, VA
Contracted to Full Time
Experienced
Role : Data Migration Specialist
Location: Richmond, VA(hybrid) – Need Only local candidates within 30-40 miles
Job ID: 754979
Interview Mode: Both Web Cam and In Person Interview (Face to Face interview)
Pls note: Initial web-based interviews will be conducted; however, the team may request a second round IN PERSON with the finalists.
ABOUT THE ROLE
Location: Richmond, VA(hybrid) – Need Only local candidates within 30-40 miles
Job ID: 754979
Interview Mode: Both Web Cam and In Person Interview (Face to Face interview)
Pls note: Initial web-based interviews will be conducted; however, the team may request a second round IN PERSON with the finalists.
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 stand-ups 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 post-migration 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.
Apply for this position
Required*