Lorven Technologies
Role - Data Migration Specialist - Location: Richmond, VA (Hybrid Role) - Contra
Lorven Technologies, Richmond, Virginia, United States, 23214
Position: Data Migration Specialist
Location: Richmond, VA (Hybrid Role)
Contract
*Local Candidates
*Both Webcam and In-person
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 requirementsTranslate functional requirements into technical specifications for ETL development.Troubleshoot and resolve data migration issuesValidate 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 meetingsChampion standards and implementation process that you define with the team.Collaborate with data architects to design data migration solutionsCollaborate 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 programsDevelop 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 verificationPerform 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 partnersRetrieve 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.
Location: Richmond, VA (Hybrid Role)
Contract
*Local Candidates
*Both Webcam and In-person
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 requirementsTranslate functional requirements into technical specifications for ETL development.Troubleshoot and resolve data migration issuesValidate 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 meetingsChampion standards and implementation process that you define with the team.Collaborate with data architects to design data migration solutionsCollaborate 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 programsDevelop 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 verificationPerform 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 partnersRetrieve 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.