Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

iShift

NewBe an early applicant

Data Migration Lead / Data Conversion Analyst - 2 days Onsite Hybrid in Harrisburg, PA - Long Term Contract

Posted

Description

Data Migration Lead / Data Conversion Analyst (Contract)

Location: Harrisburg, PA

Work Arrangement: Hybrid

Employment Type: Long-Term Contract

Duration: 2+ Years


Position Overview

We are seeking an experienced, hands-on Data Migration Lead / Data Conversion Analyst to lead the end-to-end data conversion workstream for a large-scale Customer Account Information (CAI) application modernization initiative.


The ideal candidate will have strong expertise in legacy data migration, relational database modeling, SQL, ETL/ELT processes, data profiling, cleansing, transformation, and reconciliation.

This role will be responsible for assessing legacy databases, defining data migration strategies, designing source-to-target mappings, developing conversion processes, and leading migration testing, production cutover, and post-migration validation.


Key Responsibilities

  • Own the end-to-end data migration strategy, architecture, planning, execution, and delivery.
  • Analyze legacy databases, files, interfaces, historical records, business rules, and data dependencies.
  • Design and maintain source-to-target mappings, data dictionaries, logical and physical data models, and entity relationships.
  • Define data migration, transformation, remediation, archival, and retention strategies.
  • Develop and optimize ETL/ELT processes, SQL scripts, staging structures, validation controls, and reconciliation reports.
  • Perform data profiling, cleansing, de-duplication, standardization, and exception management.
  • Lead migration testing, trial conversions, data quality validation, and reconciliation activities.
  • Plan and execute production migrations, cutovers, rollback strategies, and post-go-live validation.
  • Ensure data accuracy, integrity, security, traceability, and compliance with applicable privacy requirements.
  • Collaborate with Product Managers, Business Analysts, Solution Architects, Developers, DBAs, and business stakeholders.
  • Maintain technical documentation, migration runbooks, test results, defect logs, and knowledge-transfer materials.


Required Qualifications

  • 7+ years of experience in Data Migration, Data Conversion, Data Engineering, Database Development, or Data Analysis.
  • Strong hands-on SQL experience and relational database expertise.
  • Proven experience leading at least one large-scale legacy application data migration from discovery through production cutover.
  • Strong understanding of relational data modeling, entity relationships, normalization, keys, and referential integrity.
  • Hands-on experience with source-to-target mapping, data profiling, cleansing, ETL/ELT development, and complex data transformations.
  • Experience with automated data validation, reconciliation, migration testing, and defect resolution.
  • Experience planning migration rehearsals, production cutovers, rollback strategies, and post-migration validation.
  • Ability to work closely with technical teams, architects, DBAs, business stakeholders, and vendors.
  • Strong documentation, communication, analytical, and problem-solving skills.
  • Understanding of data security, role-based access, data integrity, auditability, and privacy requirements.


Preferred Qualifications

  • Experience modernizing legacy transactional, customer information, or case-management applications.
  • Experience with public-sector, utilities, financial services, or other regulated industries.
  • Familiarity with Microsoft SQL Server, Microsoft Azure data services, Azure Data Factory, or SSIS.
  • Experience with phased migrations, incremental/delta conversions, and data synchronization.
  • Knowledge of data governance, metadata management, data lineage, master data, and data quality management.
  • Experience with Azure DevOps, source control, and automated migration pipelines.
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent experience.
  • PMP or relevant data engineering certifications are a plus.


Ideal Candidate Profile

The ideal candidate will have hands-on experience leading enterprise-level data migration and conversion projects, particularly involving legacy application modernization and complex transactional databases.


Key Skills: Data Migration, Data Conversion, SQL, ETL/ELT, Data Modeling, Source-to-Target Mapping, Data Profiling, Data Cleansing, Data Reconciliation, Legacy Modernization, Microsoft SQL Server, Azure Data Factory, SSIS..


Thanks & Best Regards

Piyush Sharma

Recruitment

eMail: Psharma@ishift.net | www.ishift.net

7014 East Camelback Road, Suite 1452

Scottsdale, Arizona 85251

Skills

Apply

See also