Database Migration Analyst 2
Database Migration Analyst 2
Posted on :
06-11-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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.
Job Summary
- We are looking for a Data Migration Analyst to perform the analysis to migrate DB2LUW 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.
Qualifications:
- Bachelors 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 lowerlevel Database Migration Analyst position equivalent.
Required Skills
- 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 years experience with Erwin Data Modeling Tool
- One years experience with Microsoft Windows Server.
Desired Skills
- Experience with Extract Transform and Load (ETL) tools SQL Server Integration Services (SSIS) and DB2LUW export utilities.
- Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.
- 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.
Skill
Required / Desired
Amount
of Experience
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
Bachelors degree in a related field from an accredited college or university
Experience with DBeaver Tool orIBM 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 DB2LUW export utilities.
Strong knowledge of Unemployment Insurance (UI) Benefits and Tax.
Strong knowledge of data mapping process and best practices
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
