Please scroll down, To apply

Database Migration Analyst - Hybrid

hiring now
New job

cyberThink, Inc

2024-11-07 23:40:23

Job location Atlanta, Georgia, United States

Job type: fulltime

Job industry: Administration

Job description

Job Description:

As a Database Migration Analyst, you will play a critical role in migrating DB2-LUW data to a PostgreSQL environment. You will lead data migration efforts, ensuring data integrity, quality, and accuracy throughout the process. Key responsibilities include developing and executing migration strategies, performing data cleansing, creating complex SQL scripts and stored procedures for ETL processes, and collaborating with Application Development Subject Matter Experts (SMEs) to validate data mappings. Documentation and status updates will be maintained on a SharePoint site.

Key Responsibilities:

Analyze and execute data migration strategies to move DB2-LUW data to PostgreSQL

Conduct data cleansing and validation processes to ensure data accuracy and quality

Develop complex SQL scripts and stored procedures for ETL processes

Collaborate with Application Development SMEs to verify accurate data mapping

Optimize ETL processes for efficient data transfer and performance

Maintain detailed documentation and status updates on SharePoint

Use DBeaver Tool or IBM Data Studio to support migration activities

Leverage Erwin Data Modeling Tool for data structure analysis

Manage tasks on Microsoft Windows Server environments

Ensure project milestones are met on time while maintaining data integrity

Required Skills, Experiences, Education and Competencies:

Bachelor's degree in a related field and 4 years of relevant experience, or Master's degree

Minimum 5 years' experience with data migration processes

Minimum 5 years' experience with SQL and stored procedure development

Minimum 3 years' experience with relational databases such as DB2 or SQL Server

Minimum 1 year of experience with PostgreSQL

Experience with DBeaver Tool or IBM Data Studio (1+ years)

Experience with Erwin Data Modeling Tool (1+ years)

Experience working with Microsoft Windows Server environments (1+ years)

Preferred Skills:

Experience with ETL tools, including SQL Server Integration Services (SSIS) and DB2-LUW export utilities

Strong understanding of Unemployment Insurance (UI) Benefits and Tax systems

Knowledge of data mapping processes and best practices

The hourly range for roles of this nature are $40.00 to $80.00/hr. Rates are heavily dependent on skills, experience, location, and industry.

cyberThink is an Equal Opportunity Employer.

Inform a friend!

<!– job description page –>
Top