What are the responsibilities and job description for the Database Migration Analyst 2 position at RICEFW Technologies Inc?
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 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.
Qualifications
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.
Required/Desired Skills
Skill Required /Desired Amount Candidate Experience Experience with data migration processes. Required 5 Experience with SQL and creating Stored Procedures Required 5 Experience with a relational database, such as DB2, SQL Server. Required 3 Experience with PostgreSQL Required 1 Bachelor's degree in a related field from an accredited college or university Required 0 Experience with DBeaver Tool orIBM Data Studio Required 1 Experience with Erwin Data Modeling Tool Required 1 Experience with Microsoft Windows Server Required 1 Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities. Highly desired 0 Strong knowledge of Unemployment Insurance (UI) Benefits and Tax. Highly desired 0 Strong knowledge of data mapping process and best practices Highly desired 0
Questions
No. Question Answer Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? Question2 What is your candidate's email address? Question5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement? Question6 If selected for engagement, your candidate will be expected to start no later than 2 weeks (10 business days) after the client's selection date? Do you agree to this requirement? Question7 HYBRID work option: However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement?
*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 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.
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.
- Five years’ experience with data migration processes.
- Five years’ experience with SQL and creating Stored Procedures
- Three years’ experience with a relational database, such as DB2, SQL Server.
- One years’ experience with PostgreSQL
- One years’ experience with DBeaver Tool or IBM Data Studio
- One year’s 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 Unemployment Insurance (UI) Benefits and Tax.
- Strong knowledge of data mapping process and best practices
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.
Required/Desired Skills
Skill Required /Desired Amount Candidate Experience Experience with data migration processes. Required 5 Experience with SQL and creating Stored Procedures Required 5 Experience with a relational database, such as DB2, SQL Server. Required 3 Experience with PostgreSQL Required 1 Bachelor's degree in a related field from an accredited college or university Required 0 Experience with DBeaver Tool orIBM Data Studio Required 1 Experience with Erwin Data Modeling Tool Required 1 Experience with Microsoft Windows Server Required 1 Experience with Extract, Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2-LUW export utilities. Highly desired 0 Strong knowledge of Unemployment Insurance (UI) Benefits and Tax. Highly desired 0 Strong knowledge of data mapping process and best practices Highly desired 0
Questions
No. Question Answer Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? Question2 What is your candidate's email address? Question5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement? Question6 If selected for engagement, your candidate will be expected to start no later than 2 weeks (10 business days) after the client's selection date? Do you agree to this requirement? Question7 HYBRID work option: However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement?
