Randstad
Database migration analyst 2
Randstad, Atlanta, Georgia, United States, 30383
job summary:Our client is seeking for a local candidate in Atlanta GA for long term opportunity. 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 SME's to ensure data is mapped properly and ensure the ETL process is optimized. The candidate will maintain documentation and status on a SharePoint site.
location: Atlanta, Georgiajob type: Contractsalary: $59 - 60 per hourwork hours: 8am to 5pmeducation: Bachelors
responsibilities: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 year's 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.
qualifications:
Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors (required)
skills:
SQLdata migrationDB2PostgreSQLETL
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
location: Atlanta, Georgiajob type: Contractsalary: $59 - 60 per hourwork hours: 8am to 5pmeducation: Bachelors
responsibilities: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 year's 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.
qualifications:
Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors (required)
skills:
SQLdata migrationDB2PostgreSQLETL
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.