Data Migration Specialist

Description

The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database.
• Experience with Microsoft SSIS
• Experience with Microsoft SQL Server
• Knowledge of T-SQL
• Ability to write complex SQL statements
• Experience with AMANDA solution from Granicus (formerly Calytera)

Responsibilities

• Adhere to data standards and scripting standards set at the project level
• Analyze existing Oracle and MS Access databases
• Work with Business Analysts to understand the requirements and identify gaps between
• requirements and data in existing databases.
• Map existing databases fields to new AMANDA database fields
• Document and validate data mapping with the Project team.
• Develop and document the data migration plan in collaboration with Data Architect.
• Execute data migration plan by migrating data from the source databases to the AMANDA
• database.
• Apply the data governance rules as well as data retention policies to data migration
• Support efforts to cleanse source data via scripts and/or reports identifying data requiring
• manual cleansing
• Review AMANDA table structure based on the design in AMANDA for mapping the data from
• source to Amanda database structure
• Collaborate with other Data Migration Specialists and review each other’s scripts to ensure
• consistency
• Test data migration processes and validate data was migrated correctly.
• Manage data migration scripts by versioning them via source control
• Constantly work to fine-tune data migration scripts to improve performance.
• Collaborate with the QA team on data migration activities