ETIC, Data Migration, Senior Associate

We are seeking a highly skilled Data Migration Engineer to join our team. This role focuses on ensuring the smooth transition of data between various systems, maintaining data integrity, and optimizing data processes to support evolving business needs.

Must Have

• Devise comprehensive data migration strategies.
• Execute data migration tasks including ETL processes, ensuring data accuracy.
• Analyze existing data structures and design efficient migration processes.
• Collaborate with cross-functional teams for integrated data flows.
• Perform thorough data mapping and validation activities.
• Develop automated validation scripts for data quality.
• Create detailed technical documentation of migration processes.
• Provide ongoing support and troubleshoot data migration issues.
• Identify opportunities to improve data migration processes and efficiency.
• Implement performance tuning techniques for data transfer rates.
• Ensure data migration activities comply with governance and security policies.
• Implement data protection practices for sensitive information.
• Strong knowledge of data migration projects and various technologies.
• Proficiency in data migration tools like Informatica, Talend, or similar.
• Strong knowledge in Python and scripting.
• Basic knowledge in Cloud service providers: AWS/Azure/GCP.
• Advanced SQL scripting skills for ETL processes.
• Familiarity with data modeling, database design principles, and RDBMS.
• Excellent analytical skills to assess complex data structures.
• Ability to troubleshoot and resolve migration-related issues promptly.
• Strong communication skills for technical and non-technical stakeholders.
• Experience working in a team-oriented environment and leading data migration initiatives.
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Experience in data migration, data integration, or related fields.

Good to Have

• Relevant certifications in data migration tools.

Line of Service

Advisory

Industry/Sector

Technology

Specialism

Advisory - Other

Management Level

Senior Associate

Job Description & Summary

We are seeking a highly skilled Data Migration Engineer to join our team. This role focuses on ensuring the smooth transition of data between various systems, maintaining data integrity, and optimizing data processes to support evolving business needs.

Roles and Responsibilities:

Data Migration Planning and Execution:

Devise comprehensive data migration strategies that align with business objectives and project timelines.

Execute data migration tasks, including extraction, transformation, and loading (ETL) processes, ensuring data accuracy and completeness.

Systems Analysis and Integration:

Analyze existing data structures and design efficient processes for data migration considering system differences.

Collaborate with cross-functional teams to ensure integrated data flows and optimized performance across environments.

Data Mapping and Validation:

Perform thorough data mapping and validation activities to verify data consistency and accuracy during migration.

Develop automated validation scripts to ensure data quality post-migration.

Technical Documentation and Support:

Create detailed technical documentation of data migration processes, mapping schemas, and data models.

Provide ongoing support and troubleshoot issues related to data migration, ensuring minimal disruption to business operations.

Performance Optimization:

Identify opportunities to improve data migration processes, enhancing efficiency and reducing execution time.

Implement performance tuning techniques to optimize data transfer rates and system resources.

Compliance and Security:

Ensure all data migration activities comply with data governance, security policies, and regulatory requirements.

Implement data protection practices to secure sensitive and proprietary information during migration activities.

Preferred Knowledge and Experience:

• Technical Expertise:
• Strong knowledge of data migration projects involving various technologies and systems.
• Proficiency in using data migration tools and technologies such as Informatica, Talend, or similar solutions.
• Strong Knowledge in Python and scripting
• Basic Knowledge in Cloud service providers : AWS/Azure/GCP
• Database and SQL Skills:
• Advanced SQL scripting skills to efficiently manage data extraction, transformation, and loading (ETL) processes.
• Familiarity with data modeling, database design principles, and relational database management systems (RDBMS).
• Problem-Solving and Analytical Skills:
• Excellent analytical skills to assess complex data structures and identify optimal solutions for data migration challenges.
• Ability to troubleshoot and resolve migration-related issues promptly.
• Communication and Collaboration:
• Strong communication skills to effectively collaborate with technical and non-technical stakeholders.
• Experience working in a team-oriented, collaborative environment and leading data migration initiatives.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• years of experience in data migration, data integration, or related fields.
• Relevant certifications in data migration tools will be considered a plus.

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Agile Scalability, Amazon Web Services (AWS), Analytical Thinking, Apache Airflow, Apache Hadoop, Azure Data Factory, Communication, Creativity, Data Anonymization, Data Architecture, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Databricks Unified Data Analytics Platform, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling, Data Pipeline {+ 27 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date