DATA MIGRATION LEAD SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 3, 2024 - The Data Migration Lead is equipped with extensive experience in architecting data analytics solutions on cloud platforms, emphasizing infrastructure design for DevOps implementation and optimal setup. Proficiency in data architecture spans various sources, including ERP systems like D365 and Oracle, CRM platforms such as Salesforce, and HR systems like Workday, using tools like ADF or Databricks. Expertise includes a strong foundation in data warehouse technologies like Redshift and Synapse, advanced knowledge of data modeling principles, and the ability to adapt solutions to client-specific cloud configurations and security requirements.

Essential Hard and Soft Skills for a Standout Data Migration Lead Resume
  • Data Mapping
  • ETL Processes
  • SQL Proficiency
  • Data Quality Assessment
  • Data Warehousing
  • Migration Tool Expertise
  • Data Cleansing Techniques
  • Scripting Languages
  • Database Management
  • Cloud Platform Knowledge
  • Leadership
  • Communication
  • Problem-Solving
  • Adaptability
  • Attention to Detail
  • Team Collaboration
  • Time Management
  • Stakeholder Engagement
  • Critical Thinking
  • Conflict Resolution.

Summary of Data Migration Lead Knowledge and Qualifications on Resume

1. BS in Information Systems with 8 years of Experience

  • English speaking and writing
  • Experience in ABAP Development, HANA DB development, CDS, S4HANA VDM, Technical Interfaces, and Data services.
  • Ability to possess certification in SAP ABAP and HANA
  • Experience in unit testing and well-versed with new ABAP Syntax
  • Strong Knowledge/Experience of CDS Implementation with security (CDL)
  • Strong Knowledge/Experience in building Analytics CDS objects.
  • Strong Knowledge/Experience in VDM architecture frameworks, concepts, and best practice design principles.
  • Strong knowledge of oDATA service implementation, using standard project approach or with SADL layer
  • Strong knowledge of BOPF Framework and Restful Programming
  • Experience in Performance optimization in all the above technical layers.

2. BA in Computer Science with 7 years of Experience

  • Ability to develop or revise the data migration approach as new data requirements arise
  • Ability to review project deliverables for completeness, quality, and compliance with established project standards
  • Ability to identify, clarify, and resolve issues and risks
  • Ability to lead onshore and offshore (4) teams
  • Ability to get work done with multiple teams
  • Experience with data migration projects within a Payor space.
  • Expert in Database development, ETL tools/scripting
  • Expert in database data analysis from alignment with the requirements and data anomalies analysis perspective
  • Experience with Salesforce from a data migration perspective
  • Knowledge of SAP other ERPs business process re-engineering, ETL tools such as LSMW, Informatica, PL/SQL
  • Good understanding of accounting, financials and supply chain

3. BS in Data Analytics with 10 years of Experience

  • Experience in leading and ensuring delivery of all aspects of data migration including data analysis, mapping and transfer.
  • Experience working within delivery teams for projects of significant size
  • Solid understanding of relational databases, preferably Oracle databases.
  • Strong knowledge on various data formats such as database extracts, spreadsheets, JSON, CSV etc
  • Integration and data migration experience with Salesforce
  • Demonstrate a deep understanding of the Salesforce data model and migrating data into Salesforce
  • Good Understanding of data quality and governance tools such as Informatica CDQ, Axon and EDC
  • Demonstrate experience with sophisticated coding through ETL tools such as Informatica Power Center. 
  • Experience with using Informatica in data migration projects
  • Strong relationship and facilitation skills both within diverse engineering and global cross-functional organizations

4. BA in Business Administration with 6 years of Experience

  • Experience in a cap market setting
  • Knowledge in Data Masking/profiling (Informatica TDM/IDQ/PWC)
  • Experience in Integration Architecture Blueprint & Design Solutions, Data Conversion & Migration, Data Migration Design, and IT transformation Planning
  • Data migration and management across Finance, Supply Chain HR systems
  • Experience in end-to-end project management delivery expertise including resource and capacity planning, controlling, and scope management.
  • Hands-on issue management, strong on admin and structured follow-through
  • Highly driven, results-focused achiever with creative problem-solving and critical thinking abilities who can inspire action and collaboration
  • Highly organized with a laser focus on even the smallest details
  • Outstanding written, verbal and presentation skills a must
  • Experience working in an Agile Scrum team.

5. BS in Management Information Systems with 8 years of Experience

  • Experience architecting data analytics solutions on cloud platforms
  • Experience in designing the infrastructure elements of a cloud platform including the setup and implementation of DevOps.
  • Well-versed in data architecture approaches to ingest, model and serve data from various sources including ERP (D365, Oracle etc.) , CRM (Salesforce, D365 etc.) and HR systems such as Workforce (Workday).
  • Actual tooling may include ADF or Databricks.
  • Good experience utilizing the various nonstructured and structured storage and database solutions native to the cloud providers with an emphasis on DWH technologies (Redshift / Synapse /(Parquet / Avro or Snowflake).
  • Knowledge of data modeling and data architecture principles for best practice reporting some examples include temporal tables, normal forms and slowly changing dimensions.
  • Experience architecting data solutions using modern business intelligence tools (preferably Power BI but will consider other visualization tools)
  • Strong knowledge of networking and security configurations in relation to cloud platforms
  • Able to adapt to client specifications (virtual networks, hybrid cloud configurations, role-based access control etc)
  • Strong business acumen in relation to Analytics within at least one function (e.g Marketing, Sales, Finance, Workforce, Procurement etc.)
  • Experience and demonstrated expertise in building interface solutions using ALE/EDI, SOA, RFC, BADIs