Database Migration Analyst 2

Padmore Global Connections LLC; Atlanta (GA); Híbrido; USD 90.000 - 120.000; A tiempo parcial

Descripción de la vacante

Padmore Global Connections LLC is seeking a Data Migration Analyst to migrate DB2-LUW data to PostgreSQL in a hybrid Atlanta setting. You will plan, execute, and validate data migrations, ensuring data quality through cleansing and validation steps.

You will develop SQL scripts and ETL processes while coordinating with developers and maintaining SharePoint documentation. The role requires strong SQL, data mapping, and experience with both DB2 and PostgreSQL environments, with a focus on data

Formación

• Bachelor's degree in a related field plus four years of related experience, or a Master's degree.
• Two years of experience at the lower-level Database Migration Analyst position equivalent.
• Five years experience with data migration processes.
• Five years experience with SQL and creating Stored Procedures.
• Three years experience with a relational database (DB2, SQL Server).
• One year experience with PostgreSQL.
• One year experience with DBeaver Tool or IBM Data Studio.
• One year experience with Erwin Data Modeling Tool.
• One year experience with Microsoft Windows Server.

Responsabilidades

• Design, implement and maintain moderately complex data migration tasks with data integrity.
• Develop and execute data migration strategies including data cleansing and validation.
• Create complex SQL scripts and stored procedures for ETL processes.
• Coordinate with Application Development SMEs to map data and optimize ETL.
• Maintain documentation and status on a SharePoint site.

Conocimientos

Data migration

SQL

Stored Procedures

Relational databases

PostgreSQL

DBeaver

IBM Data Studio

Erwin Data Modeling Tool

Windows Server

Educación

Bachelor's degree in related field

Master's degree

Herramientas

DBeaver Tool

IBM Data Studio

Erwin Data Modeling Tool

Descripción del empleo

About the job Database Migration Analyst 2

Interview Type: Either Web Cam or In Person

Work Arrangement: Hybrid

Engagement Type: Contract

Short Description:

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.

Complete Description:

*Candidate MUST be local to Metro Atlanta*

Job Summary

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 SMEs to ensure data is mapped properly and ensure the ETL process is optimized. The candidate will maintain documentation and status on a SharePoint site.

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

• 1. Five years experience with data migration processes.
• 2. Five years experience with SQL and creating Stored Procedures
• 3. Three years experience with a relational database, such as DB2, SQL Server.
• 4. One years experience with PostgreSQL
• 5. One years experience with DBeaver Tool or IBM Data Studio
• 6. One years experience with Erwin Data Modeling Tool
• 7. One years experience with Microsoft Windows Server.

Desired Skills

• 1. Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities.
• 2. Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.
• 3. Strong knowledge of data mapping process and best practices

Personal Qualities

Be innovative, energetic, energizing, flexible and eager to learn. Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills .Ability to work independently and meet requested deadlines promptly