Database Migration Analyst 2 (Need only local to GA with ID at Atlanta, Georgia, USA |
Email: [email protected] |
(Need only local to GA with ID Requisition ID: 750690 Position: Database Migration Analyst 2 Location: Atlanta, GA 30303 - HYBRID - 2 to 3 days a week onsite. Duration: 7 Months plus Skill Matrix: (7 years Minimum) Experience with data migration processes. Experience with SQL and creating Stored Procedures Experience with a relational database, such as DB2, SQL Server. Experience with PostgreSQL Bachelor's degree in a related field from an accredited college or university Experience with DBeaver Tool or IBM Data Studio Experience with Erwin Data Modeling Tool Experience with Microsoft Windows Server Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities. Strong knowledge of data mapping process and best practices Strong knowledge of Unemployment Insurance (UI) Benefits and Tax. (Preferred) 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. *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. Required Skills Experience with data migration processes. Experience with SQL and creating Stored Procedures Experience with a relational database, such as DB2, SQL Server. Experience with PostgreSQL Experience with DBeaver Tool or IBM Data Studio One years experience with Erwin Data Modeling Tool One years experience with Microsoft Windows Server. Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities. Strong knowledge of data mapping process and best practices Desired Skills Strong knowledge of Unemployment Insurance (UI) Benefits and Tax. 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. -- Keywords: user interface information technology Georgia Idaho Database Migration Analyst 2 (Need only local to GA with ID [email protected] |
[email protected] View all |
Wed Nov 06 21:16:00 UTC 2024 |