Job Seekers, Please send resumes to resumes@hireitpeople.com

• 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).

Job 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 others 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.

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 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.

Highly Desired Skills:

• Experience with MS SQL Server and Oracle databases

Experience required: 5-6 Years