ETIC, Data Migration, Senior Associate

AI in this role

databricks

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?

Government Clearance Required?

Job Posting End Date

How we score this

ETIC, Data Migration, Senior Associate at PwC scores 25 out of 100 on AI centrality, which makes it AI Level 1 of 4 (Little AI) on this board. The level measures how much of the work is AI, not seniority.

Classification

AI Level 1. The work itself involves no AI, or AI only appears as scenery, such as a company tagline.