Data Migration Specialist || Richmond, VA (Hybrid) || USC, GC only
End-client: State of VA (Behavioural Health and Developmental Services)
Working with a Prime Vendor || Final round will be face-to-face.
No Parking is provided for contractors
Job Description:
Interview Type: Both Web Cam and In-Person Interview (Need Local candidate)
Initial web-based interviews will be conducted; however, the team may request a second round In Person with the finalists.
A data migration specialist is a professional who specializes in moving data from one system or platform to another.
Responsibilities:
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 related to data.
- Create and maintain utilities, and SQL scripts as needed to accelerate the process.
- Ensure adherence to agency compliance needs.
- 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 is created and maintained to enable the 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 outcomes 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.
|
Skills |
Year of exp required |
|
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 large-scale enterprise environments (Required) |
7 years |
|
Understanding of data synchronization and replication techniques (Required) |
7 Years |
|
Strong analytical and problem-solving abilities (Required) |
6 years |
|
Critical thinking and decision-making 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) |
3 Years |
Akash Kumar
Recruitment Team Lead
Techcenter Technologies Incorporated
3240 East State Street Ext, Hamilton, New Jersey 08619
https://www.linkedin.com/in/akash-kumar-757b06131/
Open Jobs: https://www.techcentertechnologies.com/us-staffing-careers
To unsubscribe from future emails or to update your email preferences click here