Data Migration Lead / Data Conversion Analyst - 2 days Onsite Hybrid in Harrisburg, PA - Long Term Contract
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
Sign in to read and join the discussion.