DB2 Lead

Role DB2 Lead Location Aylesbury, UK Employment Type / Duration Contract (Inside IR35) Tentative Start Date April Language NA Must : The associate should be responsible for analyzing the current method of data migration from mainframe applications to Microfocus and providing recommendations for processing. Additional responsibilities include: Analyzing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures. Reviewing existing migration tools and providing recommendations for improving performance of the migration process. Providing necessary change and support documentation. Good experience on one of the DBs like Oracle/ MSSQL, etc Meet with clients or management to understand data migration requirements and needs Strategize and plan an entire project, including moving the data and converting content as necessary, while considering risks and potential impacts Audit existing data systems and deployments and identify errors or areas for improvement Cleanse or translate data so that it can be effectively moved between systems, apps, or software Defined masking rules after performing PHI analysis on sensitive information PII PHI Prepared subset extract files to extract sliced data from production down to pre production environments Experience in Test Data modeling and Management activities(Data Generation, Data Sub - Setting, Data Masking and data clonig, data preparation using automated data extraction, test matching and production copy data to test systems) Oversee the direct migration of data, which may require minor adjustments Test the new system after the migration process as well as the resulting data to find errors and/or points of corruption Document everything from the strategies used to the exact migration processes put in place-including documenting any fixes or adjustments made Develop and propose data migration best practices for all current and future projects Ensure compliance with regulatory requirements and guidelines for all migrated data NEED to Have Skills: IBM DB2 Data Migration(z/os), Microsoft SQL Server, PostgreSQL. It's a replacement demand for a customer facing role