ABOUT THE JOB

As a Data Migration Lead, you'll be responsible for data migration and analysis. You will work closely with the client to identify their requirements and develop new data models that can efficiently handle the volumes of data being migrated.

KEY RESPONSIBILITIES

• Work with the customer, users, technical architect, and application designers to define the data migration requirements and structure for the application.
• Lead the data migration plan, analysis, design, and build effort.
• Work with the technical architects and application designers to understand the data conversion requirements fully and to design the conversion procedures and applications.
• Review the database deliverables throughout development to ensure quality and traceability to requirements and adherence to all quality management plans and standards.
• Ensure that the application developers and data migration developers responsible for data migration thoroughly understand the requirements and designs.
• Work with other architects to ensure that all components work together to meet objectives and performance goals as defined in the requirements. Identify and communicate any cross-area or cross-release issues that may affect other areas of the project.
• Support the development and test teams with the creation of test data. Ensure test data conforms to data security requirements.
• Ensure security in reporting and data warehousing.
• Take ownership of design, development and testing of all data extract, transform and load (ETL) activities
• Working with the project team to ensure that all ongoing data transformation, de-duplication, extraction and load functions once ready for production deployment are documented in detailed data lineage models
• Work with data owners to verify and obtain approval that any transformed data retains its quality/accuracy
• Own the reject and exception handling processes associated with data
• Develop best practice, processes, and standards for effectively carrying out data migration activities.
• Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
• Manage assigned risks and monitor potential impacts as part of the data migration plan.

EXPERIENCE

• Ability to develop or revise the data migration approach as new data requirements arise
• Ability to develop and manage all aspects of the data migration effort, including the plans, interdependencies, schedule, tools, and required personnel.
• Ability to convert data and related techniques to acquire data needed to support testing, training, and other application development activities

QUALIFICATIONS

• Strong technical database and scripting skills. Azure, SQL
• 5+ years of experience working with large scale, data processing systems in a Data/Data Warehouse environment.
• Good understanding of Source to Target mapping between CRM Dynamics and Salesforce
• Understanding of Salesforce CRM Data Model
• Understanding of CRM Dynamics data structurers