Vacancy expired!
- 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
- Coordinate with Data Architect for various technical documentation
- Minimum 5 years’ experience with Microsoft SQL Server
- Ability to write complex SQL statements to query data in MS SQL server and Oracle
- Experience writing SQL stored procedures and functions
- Ability to tune SQL queries for better performance
- Experience using version management tools (Git is a plus)
- Experience with Azure DevOps
- Experience with Agile Methodology (Kanban is a plus)
- Knowledge of AMANDA database structure and table relationships is a plus
- Experience with MS SQL Server and Oracle databases