Home

Data Migration Specialist (SSIS) : Lansing, MI (Remote) : 7+ Months Contract at Lansing, Michigan, USA
Email: [email protected]
From:

Jitendra Upreity,

Technocraft Sol.

[email protected]

Reply to:   [email protected]

Job Title: Data Migration Specialist (SSIS)

Location: Lansing, MI (Remote)

Duration: 7+ Months Contract

Note: *** Must provide own equipment Remote work is acceptable, but onsite visits may be required at key points in the project.

Responsibilities and Skills:

Job ID: 113910

Location: Lansing MI (DIFS)

Duration: 7+ months

Top Skills & Years of Experience:

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)

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

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. Experience with the AMANDA database is a plus. AMANDA is a solution from Granicus (formerly Calytera). THIS IS NOT THE ADVANCED MARYLAND AUTOMATIC NETWORK DISK ARCHIVER (AMANDA).

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

Keywords: quality analyst microsoft Idaho Michigan
[email protected]
View all
Mon Feb 06 20:54:00 UTC 2023

To remove this job post send "job_kill 331742" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 8

Location: Lansing, Michigan