Database Migration Analyst (Hybrid)

$124,800 - $124,800/Yr

Gsk Solutions - Atlanta, GA

Full-time - Entry Level

Atlanta, GA

Professional, Scientific, and Technical Services

About the position

The Database Migration Analyst will be responsible for analyzing and executing the migration of DB2-LUW data to a PostgreSQL environment. This role is crucial for ensuring data integrity and quality throughout the migration process. The analyst will develop and implement data migration strategies, create complex SQL scripts, and collaborate with application development subject matter experts to optimize the ETL process. Additionally, the analyst will maintain documentation and project status on a SharePoint site.

Responsibilities

• Perform analysis to migrate DB2-LUW data to a PostgreSQL environment.
• Plan, execute, and validate data migration processes.
• Develop and execute data migration strategies, including data cleansing and validation processes.
• Create complex SQL scripts and stored procedures for ETL processes.
• Work with Application Development SMEs to ensure proper data mapping and optimized ETL processes.
• Maintain documentation and project status on a SharePoint site.

Requirements

• Bachelor's degree in a related field from an accredited college or university or a Master's degree.
• 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 or SQL Server.
• One year of experience with PostgreSQL.
• One year of experience with DBeaver Tool or IBM Data Studio.
• One year of experience with Erwin Data Modeling Tool.
• One year of experience with Microsoft Windows Server.

Nice-to-haves

• Experience with ETL tools like SQL Server Integration Services (SSIS) and DB2-LUW export utilities.
• Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.
• Strong knowledge of data mapping processes and best practices.

Benefits

• Competitive hourly rate of $60/hr on C2C.
• Opportunity to work on critical projects for Fortune 500 clients.