SQL Server BI Developer / Data Migration Specialist
Nava Software Solutions, Lansing, MI, United States
NAVA Software solutions is looking for a SQL Server BI Developer / Data Migration Specialist
Details:
SQL Server BI Developer / Data Migration Specialist
Duration: 12 months
Location: Remote - onsite visits may be required at key points in the project.
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)
Details:
SQL Server BI Developer / Data Migration Specialist
Duration: 12 months
Location: Remote - onsite visits may be required at key points in the project.
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)