Database Migration Analyst (Data Engineer or Data Analyst with ETL & migration exp.) in Atlanta, GA 30303 - Onsite at Atlanta, Georgia, USA |
Email: [email protected] |
From: Jatin Keshav, Techgene Solutions LLC [email protected] Reply to: [email protected] Role: Database Migration Analyst (Data Engineer/Data Analyst with ETL & migration exp.) Location: Atlanta, GA 30303 - Onsite Duration: 7 Months Interview: Either Web Cam or In Person LOCAL PROFILES ONLY Skill Required / Desired Amount of Experience Experience with data migration processes. Required 5 Years Experience with SQL and creating Stored Procedures Required 5 Years Experience with a relational database, such as DB2, SQL Server. Required 3 Years Experience with PostgreSQL Required 1 Years Bachelor's degree in a related field from an accredited college or university Required Experience with DBeaver Tool orIBM Data Studio Required 1 Years Experience with Erwin Data Modeling Tool Required 1 Years Experience with Microsoft Windows Server Required 1 Years Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities. Highly desired Strong knowledge of Unemployment Insurance (UI) Benefits and Tax. Highly desired Strong knowledge of data mapping process and best practices Highly desired 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. 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. 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. Thanks & Regards, Jatin Keshav Recruitment Manager Techgene Solutions, LLC O: 908-800-7107 Ext: 337 Email : [email protected] Keywords: user interface Georgia Database Migration Analyst (Data Engineer or Data Analyst with ETL & migration exp.) in Atlanta, GA 30303 - Onsite [email protected] |
[email protected] View all |
Tue Nov 05 22:27:00 UTC 2024 |