Database Migration Analyst 2 :: Atlanta, GA (Hybrid)

---

Job description

Ark Solutions Inc is looking for Database Migration Analyst 2!

Position: Database Migration Analyst 2

Location: Atlanta, GA (Hybrid)

Duration: 7+ Months and possibility of extension

Description:

We are looking for a Data Migration Analyst to perform the analysis to migrate DB2-LUW data to a PostgreSQL environment. The candidate will play a crucial role in planning, executing, and validating data migration, ensuring data integrity is accurate. The candidate will develop and execute data migration strategies, including data cleansing and validation processes to ensure data quality; the candidate will create complex SQL scripts and stored procedures for ETL process. The candidate will work with Application Development SME's to ensure data is mapped properly and ensure the ETL process is optimized. The candidate will maintain documentation and status on a SharePoint site.

Under general supervision, designs, implements, and maintains moderately complex data migration task, ensuring data integrity is accurate. The candidate will develop and execute data migration strategies, including data cleansing.

Qualifications:

Bachelor's degree in a related field from an accredited college or university AND Four years of related experience OR MASTERS degree OR Two years of experience at the lower-level Database Migration Analyst position equivalent.

Required Skills:

Five years' experience with data migration processes.

Five years' experience with SQL and creating Stored Procedures

Three years' experience with a relational database, such as DB2, SQL Server.

One years' experience with PostgreSQL

One years' experience with DBeaver Tool or IBM Data Studio

One year's experience with Erwin Data Modeling Tool

One years' experience with Microsoft Windows Server

Desired Skills:

Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities.

Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.

Strong knowledge of data mapping process and best practices

Skills
Required / Desired
Experience

Experience with data migration processes
Required
5 Years

Experience with SQL and creating Stored Procedures
Required
5 Years

Experience with a relational database, such as DB2, SQL Server
Required
3 Years

Experience with PostgreSQL
Required
1 Year

Bachelor's degree in a related field from an accredited college or university
Required

Experience with DBeaver Tool orIBM Data Studio
Required
1 Year

Experience with Erwin Data Modeling Tool
Required
1 Year

Experience with Microsoft Windows Server
Required
1 Year

Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities
Desired

Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.
Desired

Strong knowledge of data mapping process and best practices
Desired

<!– job description page –>