Data Migration Architect

  • Full-time
  • Service Line: Consulting

Company Description

About Deloitte

Deloitte is a leading global provider of audit and assurance, consulting, financial advisory, risk advisory, tax and related services. Our global network of member firms and related entities in more than 150 countries and territories (collectively, the “Deloitte organization”) serves four out of five Fortune Global 500® companies. Learn how Deloitte’s approximately 312,000 people make an impact that matters at www.deloitte.com.

About the Cloud Practice

Deloitte is an industry leader in our clients Digital transformations. We recognize that the backbone enabling our clients highest aspirations for analytics and cognitive solutions is next-gen Cloud infrastructure. From cloud consulting, to implementation, and ongoing managed services we offer a full scope of Cloud services and solutions. We want talent who is ready to innovate cloud services and empower our clients to leap frog forward in their technical capabilities. Building your career at Deloitte offers the opportunity to work with cutting-edge Cloud technologies to deliver next-Gen Cloud solutions. We embrace the tech pioneer mindset and always enable our talent to keep their skills evolving at the speed at which the technology marketplace is evolving.

Job Description

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.

  • 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.

Qualifications

 Technical Experience required:

  • 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

Skills: 

  • 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

Additional Information

At Deloitte, we want everyone to feel they can be themselves and to thrive at work—in every country, in everything we do, every day. We aim to create a workplace where everyone is treated fairly and with respect, including reasonable accommodation for persons with disabilities. We seek to create and leverage our diverse workforce to build an inclusive environment across the African continent.

Privacy Policy