Description

The main responsibilities are: 

  • The Data Migration Specialist is responsible for migrating data from various data sources to an AMANDA database. 
  • The Data Migration Specialist is responsible for migrating data from Oracle to MS SQL Server database. 
  • The ideal candidate would have participated in large data migration projects, and have experience migrating data to MS SQL Server.  
  • 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

Required Skills

  • 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 with Microsoft SSIS
  • Knowledge of T-SQL 
  • Ability to write complex SQL statements
  • 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
  • Experience with AMANDA solution from Granicus (formerly Calytera) is a plus.
  • Experience with MS SQL Server and Oracle databases (Highly Desired)


 

Key Skills
Education

Any Graduate

Back To Jobs