Database Migration Analyst

Coventek - Atlanta, GA

Full-time - Mid Level

Atlanta, GA

Telecommunications

About the position

The Data Migration Analyst at Coventek Inc. is responsible for designing, implementing, and maintaining moderately complex data migration tasks, ensuring data integrity and accuracy. This role involves developing and executing data migration strategies, including data cleansing and validation processes, to ensure high data quality. The analyst will work closely with Application Development Subject Matter Experts (SMEs) to ensure proper data mapping and optimization of the ETL process, while also maintaining documentation on a SharePoint site.

Responsibilities

• Design and implement data migration tasks ensuring data integrity.
• 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.
• Optimize the ETL process for efficiency.
• Maintain documentation and status updates on a SharePoint site.

Requirements

• Bachelor's degree in a related field from an accredited college or university and four years of related experience, or a Master's degree, or two years of experience at a 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 relational databases such as DB2 and 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 such as 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.