Description

You will lead the analysis and execution of migrating DB2-LUW data to a PostgreSQL environment.

Responsibilities

• Develop and execute data migration strategies, including data cleansing and validation processes.
• Create complex SQL scripts and stored procedures for ETL processes.
• Collaborate with Application Development SMEs to ensure proper data mapping and ETL optimization.
• Maintain migration documentation and status updates on SharePoint.
• Validate data integrity throughout the migration lifecycle.

Required Skills

• 5 years of experience with data migration processes.
• 5 years of experience with SQL and creating stored procedures.
• 3 years of experience with relational databases such as DB2 or SQL Server.
• 1 year of experience with PostgreSQL.
• 1 year of experience with DBeaver or IBM Data Studio.
• 1 year of experience with Erwin Data Modeling Tool.
• 1 year of experience with Microsoft Windows Server.
• Bachelor's degree in a related field and 4 years of related experience, or a Master's degree.

Preferred Skills

• Experience with ETL tools like SQL Server Integration Services (SSIS) and DB2-LUW export utilities.
• Knowledge of Unemployment Insurance (UI) Benefits and Tax.
• Knowledge of data mapping processes and best practices.

Key Skills

Education

Any Graduate