What are the responsibilities and job description for the Data Migration Specialist position at InfoPeople Corporation?
About the Role
Main Responsibilities :
- 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 legacy data, data quality rules, business rules, and 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 processes defined with the team.
- Collaborate with data architects to design data migration solutions.
- Collaborate with business customers and teams, ensuring quicker and more accurate data management.
- Complete assigned tasks in an organized manner to ensure project deadlines are met.
- Develop and execute data migration processes 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, 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 programs 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 migration processes 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 IT and the data cleansing / migration initiative at meetups with internal and external partners.
- Retrieve data from the database or electronic files as requested.
- Validate post-migration results and communicate outcomes with key leadership and business stakeholders.
- Verify data by comparing it to source documents.
- Write validation scripts to run over the staging tables to report any invalid data.
Skills Required :
