DATA MIGRATION SPECIALIST SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 3, 2024 - The Data Migration Specialist skilled in SQL and relational databases, adept at writing medium to complex queries and stored procedures for data cleansing, validation, transformation, and enrichment. This position possesses a robust understanding of data architecture and strong analytical skills necessary for analyzing massive-scale structured and unstructured data, as well as meeting complex business requirements. Efficient in managing client communications independently, with excellent skills in MS Excel and prioritizing tasks, bringing significant expertise to dynamic data environments including commercial loans, real estate, and structured financing.

Essential Hard and Soft Skills for a Standout Data Migration Specialist Resume
  • Data Mapping
  • ETL Processes
  • SQL
  • Data Warehousing
  • Data Analysis
  • Data Profiling
  • Data Cleansing
  • Data Transformation
  • Database Management
  • ERP Systems
  • Problem Solving
  • Communication
  • Attention to Detail
  • Adaptability
  • Time Management
  • Team Collaboration
  • Critical Thinking
  • Project Management
  • Stakeholder Engagement
  • Flexibility

Summary of Data Migration Specialist Knowledge and Qualifications on Resume

1. BS in Information Technology with 3 years of experience

  • Understanding of technical data migration process
  • Experience in Process Improvement
  • Experience with data analysis and SQL
  • Knowledge of healthcare data & workflow preferred
  • Strong problem-solving and analytical skills
  • Ability to exercise effective decision-making capabilities in a fast-paced environment.
  • Excellent communication and organizational skills
  • Knowledge and experience working with Relational Databases (RDB) e.g. SQL, MySQL and Sybase
  • Excellent development skills using JAVA, C++, Python, JavaScript, jQuery and / or NodeJs
  • Confirmed Application Lifecycle Management (ALM) experience e.g. design, development, deployment and debugging (fault-finding) etc.
  • Knowledge of Web Application design and standard methodologies, specifically in regard to SOAP and REST-based Web Services
  • Good knowledge of Cloud Solution Providers (e.g. GCP, AWS, Azure) and cloud architecture

2. BA in Data Science with 6 years of experience

  • Experience in developing and analyzing requirements for data migration tasks, including cutover planning and user migration.
  • Experience in data migration from unstructured data to structured data and vice versa
  • Experience in data migration of large datasets to and from unstructured databases.
  • Experience in document management tools including OpenText - OCR, ICR, IDR
  • Experience in working with technical system integrators to identify and fix data issues and resolve anomalies.
  • Experience in performing quality assurance checks to verify the accuracy of data loading, manipulation, and conversion.
  • Experience in data archival strategy, data consolidation, and data transformation.
  • A good understanding of tools like Captiva, XML, JSON, MarkLogic Databases and XSLT scripting and compatible tools that deal with files in those formats.
  • Able to obtain and maintain a Public Trust clearance.
  • Experience with the design and implementation of integrations using Dell Boomi
  • Knowledgeable of SQL, REST APIs, JSON, XML, EDI, Master Data Management, data warehousing and data analysis concepts

3. BS in Computer Science with 4 years of experience

  • Experience working with MS Access or other SQL-query-based database programs
  • Strong Knowledge of Microsoft SQL Server 2012 and 2014 (knowledge of Microsoft SQL Server 2005 and 2008)
  • MS Data Transformation Services (DTS) knowledge
  • Strong analytical skills and attention to detail
  • Ability to work in a team collaborative environment but to also work independently with the customer
  • Solid communication and interpersonal skills is a must (client-facing position)
  • Experience with C or Visual Basic programming would be an asset
  • Excellent written and verbal communication skills
  • Outstanding analytical and problem-solving skills
  • High accountability to work independently and provide the highest client service
  • Proficiency in writing SQL queries and using relational databases (SQL Server or Oracle)
  • Excellent analytical, logical, presentation and interpersonal communication skills
  • Strong customer orientation and ability to work in a multinational and multicultural environment.

4. BA in Management Information Systems with 5 years of experience

  • Hands-on-experience delivering solutions related to enterprise integration, APIs, service-oriented architecture, and technology modernizations using Dell Boomi
  • In-depth understanding of enterprise integration patterns and prowess to apply them in the customer's IT landscape
  • Excellent understanding of REST with in-depth understanding on how Boomi processes can be exposed, consume services using the different http methods, URI and Media type using Basic Auth/Client Certificate auth types
  • Understand Atom, Molecule, Atmosphere Configuration and Management, Platform Monitoring, Performance Optimization Suggestions, Platform Extension, User Permissions Control Skills.
  • Knowledge of API governance and skills like caching, DB management and data warehousing
  • Experience in configuring AS2, HTTPS, SFTP, SOAP, and DB involving different authentication methods
  • Proficient in using database connectors and comfortable with writing/reviewing SQL scripts
  • Knowledge of process deployment, applying for extensions, setting up schedules, Web Services user management process filtering and process reporting
  • Ability to build integration solutions using Dell Boomi for cloud, hybrid and on-premise integration landscapes
  • Expert with XML and JSON activities like creation, mapping and migrations
  • Experience with integration on SAP, SharePoint, Salesforce, cloud-based apps, Web applications and engineering application

5. BS in Data Analytics with 4 years of experience

  • Ability to support and resolve issues related to data integration deliveries or platform
  • Knowledge on the usage of certificates on the Boomi platform
  • Knowledge about operations activities, awareness of ITIL process and guidelines
  • Knowledge of EDI, Master Data Management, data warehousing and data analysis concepts
  • Knowledge of API Management Gateway concepts in general. 
  • Knowledge of Azure API Gateway and configuration
  • Experience working in a validated environment (Pharma, Insurance, etc.)
  • Experience in software development using .NET
  • Solid Microsoft Excel skills
  • Familiarity with the Google Office Suite such as Google Docs, Gmail, and Google Sheets
  • Highly organized and motivated to achieve success

6. BS in Software Engineering with 6 years of experience

  • Experience with SQL/Relational databases.
  • Good understanding of Data Architecture and Strong Analytical skills to analyze the data, and understand the business requirements.
  • Strong querying skills should be able to write medium to complex queries and build and analyze Stored Procedures.
  • Ability to write stored procedures to perform data cleansing/ validation/ transformation/ enrichment activities.
  • Experience with manipulating massive-scale structured and unstructured data.
  • Ability to import/export data from tables.
  • Good communication skills, Resource should be capable of working independently with the Client Team and managing the communication and client coordination.
  • Good knowledge of MS Excel.
  • Ability to prioritize and efficiently execute tasks.
  • Solid analytical, technical, problem-solving, and research skills
  • Able to communicate in English well 
  • Experience with dynamic data sets and functions
  • Experience with Commercial Loans, Real Estate, Structured Financing, Cashflows Budgets

7. BS in Information Systems with 7 years of experience

  • Strong communication and writing skills with the ability to explain technical content to a non-technical audience.
  • Knowledge of understanding of the legacy DMS systems.
  • Hands-on writing scripts or source reports getting the data from other DMS systems.
  • Excellent organizational skills and be able to multi-task easily from one project to another.
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
  • Must have technical expertise regarding data models, data mining, and segmentation techniques.
  • Ability to present findings, reports and make recommendations.
  • Good interpersonal skills with the ability to build strong relationships.
  • Ability to work in a multi-cultural environment.
  • Experience with  DMS Data migration
  • Having multiple DMS system data migration experiences
  • Experience with MySQL, MongoDB, AWS Dynamo/Athena.

8. BA in Business Analytics with 5 years of experience

  • An understanding of core concepts around permissions, file systems, and mapping drives
  • Ability to implement and maintain file system and share level permissions on file server directories, system/group policies for user groups, and data replication
  • Experience with Exchange management tools and Powershell
  • Strong working knowledge of Outlook and Excel
  • A strong focus on client service and responsiveness
  • Ability to define problems, collect data, establish facts and draw valid conclusions
  • Deep experience in SAP roll-outs and technical ability in SAP Data Migration
  • Understanding of SAP ADM
  • Capable of driving implementation and software development processes
  • Knowledge of S/4 HANA 
  • Understanding of implementing best practices using technologies like S/4 HANA Migration, SAP Data Services
  • Knowledge of SQL/database structures
  • Knowledge of Microsoft SQL Server Integration Services 
Relevant Information
Data Migration Analyst Skills, Experience, and Job Requirements
Data Migration Consultant Skills, Experience, and Job Requirements
Data Migration Lead Skills, Experience, and Job Requirements
Data Migration Manager Skills, Experience, and Job Requirements