Description

You will execute data migration from a DB2-LUW environment to PostgreSQL.

Responsibilities

• Plan, execute, and validate data migrations, ensuring data integrity.
• Develop and run data migration strategies, including cleansing and validation.
• Create complex SQL scripts and stored procedures for ETL processes.
• Collaborate with Application Development SMEs to map data correctly and optimize ETL.
• Maintain migration documentation and status on SharePoint.

Required Skills

• Five years of experience with data migration processes.
• Five years of experience with SQL and creating Stored Procedures.
• Three years of experience with a relational database, such as DB2 or SQL Server.
• One year of experience with PostgreSQL.
• One year of experience with DB2 or IBM Data Studio.
• One year of experience with Erwin Data Modeling Tool.
• One year of experience with Microsoft Windows Server.

Preferred Skills

• Experience with ETL tools like SQL Server Integration Services (SSIS) and DB2-LUW export utilities.
• Strong knowledge of data mapping process and best practices.

Key Skills

Education

Any Graduate