Skills
Experience in MS SQL/Oracle
Experience in OLTP Database
Experience in Database Designing
Experience in Data Migration (Migration from Legacy system to new system and from old existing data structure to new data structure)
Experience in Data Migration Estimation, Planning(using WBS, Table)
Experience in preparing Exception Reports on Data Migration
Experience in Data Migration Testing
Experience in Data Cleansing
Experience in setting Data Rules
Experience in Data Migration Dependency Check
Experience in any ETL tool
Job Description
Position : Data Migration Lead
Location : Bangalore
Skills : DB Design ,Data Migration,Microsoft SQL Server 7.0, 2000,2005, 2008 and 2012 ,SSRS,SSIS
Experience : 7.0– 13.0 Years
Qualification : B.E/B.Tech/MCA/M.Sc
Job Description :
1.Design, document, and communicate the Data transformation,migration and test strategies and plan its implementation.
2.Define and manage the data migration process and methodology so that it meets the overall project goals and timeline for delivery.
3. Identify the required Data transformation,migration and testing tools, and design and build further tools to aid the migration as necessary.
4. Collaborate with MI manager and SME to analyse/review the legacy data assets, structure and quality in the source database
5. Identify any necessary changes to the target data structure
6. Define & implement data cleansing and de-duping procedures.
7. Define & implement data validation rules and processes.
8.Ensure that Data Migration Test Strategy complies with the overarching Test Strategy and Quality Assurance established internally and by external Quality Assurance Consultants
9. Define the business sign-off criteria for migration and ensure that the lifecycle of data is tracked appropriately
10.Engage with the Project, Customer Services, Management Information teams and Stakeholders to identify the Data Migration and related risks and issues, mitigation plans and resolution actions
11. Prepare regular Data Migration progress reports and issue to the project managers
12. Support the Project manager with planning input for the development of the Data Migration delivery plan and reviews/updates of the plan
13. Recommend or promote standards regarding the use of tools including ETL, T-SQL and scheduled SQL tasks.
Technical skills
Experience in MS SQL/Oracle
Experience in OLTP Database
Experience in Database Designing
Experience in Data Migration (Migration from Legacy system to new system and from old existing data structure to new data structure)
Experience in Data Migration Estimation, Planning(using WBS, Table)
Experience in preparing Exception Reports on Data Migration
Experience in Data Migration Testing
Experience in Data Cleansing
Experience in setting Data Rules
Experience in Data Migration Dependency Check
Experience in any ETL tool
