Our client, a leading enterprise with the best technology platform in its domains, is seeking a highly-skilled Data Migration Engineer. As a Data Migration Engineer, you will be responsible for ensuring the seamless transfer of data from various sources into the new system. You will collaborate with cross-functional teams to understand data requirements and develop effective strategies for data migration.
Analyze data requirements: Collaborate with business analysts and stakeholders to understand data migration requirements. Evaluate data sources, structures, and quality to determine the feasibility and complexity of migration.
Design and develop migration plans: Create comprehensive migration plans detailing data mapping, extraction, transformation, and loading processes. Establish guidelines and standards for data migration, ensuring data integrity and security throughout the process.
Execute data migrations: Implement migration plans, following industry best practices and company guidelines. Extract, transform, and load data from various sources into the target system, ensuring accuracy, completeness, and timeliness of data transfers.
Address data quality issues: Identify and address data quality issues during the migration process. Collaborate with data owners and subject matter experts to resolve data discrepancies and gaps. Develop and implement data cleaning and validation procedures to ensure data accuracy.
Monitor migration progress: Track and monitor the progress of data migrations, ensuring adherence to timelines and milestones. Identify and resolve any potential bottlenecks or issues that may impact the migration process.
Test and validate migrated data: Perform thorough testing and validation of migrated data to ensure its integrity and accuracy. Validate data against predefined criteria and business rules. Generate reports and documentation to report on the success and quality of data migrations.
Provide technical support: Assist end-users and stakeholders with any data-related queries or issues post-migration. Offer technical guidance and expertise to support data integration, transformation, and reconciliation activities.
Document processes and procedures: Create and maintain documentation related to data migration processes, tools, and methodologies. Ensure documentation is up-to-date, accessible, and easily understandable to enable knowledge sharing and future reference.
Bachelor's degree in Computer Science, Information Systems, or a related field.
Proven experience as a Data Migration Engineer or in a similar role.
Strong understanding of data migration methodologies, tools, and best practices.
Proficiency in data extraction, transformation, and loading techniques.
Solid knowledge of SQL and scripting languages (e.g., Python, Perl) for data manipulation.
Familiarity with database management systems (e.g., Oracle, SQL Server) and data integration tools.
Experience in working with ETL (Extract, Transform, Load) tools.
Excellent problem-solving and analytical skills.
Strong attention to detail and organizational abilities.
Effective communication skills to collaborate with cross-functional teams.
Ability to work under pressure and meet tight deadlines.