Equisoft - Senior Data Migration Specialist

Description :

- Define data migration strategies, scope, timelines, and risk mitigation plans.

- Perform data discovery, profiling, and impact analysis.

- Create detailed data mapping documents and migration specifications.

- Estimate migration efforts and provide technical inputs for project planning.

Data Extraction, Transformation & Loading (ETL) :

- Design and implement ETL processes for data extraction, cleansing, transformation, and loading.

- Develop and optimize SQL scripts, stored procedures, and ETL workflows.

- Ensure data is transformed according to business rules and target system requirements.

- Handle large datasets and ensure performance optimization during migrations.

Data Validation & Quality Assurance :

- Ensure data accuracy, completeness, consistency, and integrity post-migration.

- Identify and resolve data anomalies, duplicates, and inconsistencies.

- Support mock migrations, dry runs, and final cutover activities.

Collaboration & Stakeholder Management :

- Translate business requirements into technical migration solutions.

- Provide regular status updates, risk assessments, and issue resolution plans.

- Mentor junior data migration engineers and provide technical guidance.

Security, Compliance & Governance :

- Ensure compliance with data governance, privacy, and security standards.

- Implement data masking, encryption, and access controls as required.

- Support audit and compliance requirements during migration projects.

- Maintain comprehensive documentation and audit trails.

Required Skills & Qualifications :

Technical Skills :

- Strong expertise in SQL and database technologies (Oracle, SQL Server, MySQL, PostgreSQL).

- Experience with ETL tools (Informatica, Talend, SSIS, DataStage, Azure Data Factory).

- Strong understanding of data modeling, data warehousing, and integration concepts.

- Experience migrating data between on-prem to cloud or cloud-to-cloud systems.

- Familiarity with data quality, reconciliation, and validation frameworks.

Soft Skills :

- Strong communication and stakeholder management skills.

- Ability to manage multiple priorities in complex environments.

- High attention to detail and ownership mindset