Data Migration Lead

Data Migration Lead

Location: Tampa, FL 33637

Duration: 9-12 Month

JD:

Role – Data Migration Lead

A Data Migration Architect must combine technical depth, planning, and communication to ensure a successful, auditable, and low-risk migration for critical OSS data.

Job Description: Exp -12-15 years with Telecom domain

Technical Expertise

Deep knowledge of relational databases (Oracle, PostgreSQL, etc.)

Experience with large, complex schemas (10000 tables, many relationships)

Proficiency in data modeling, ETL, and data quality tools

Familiarity with data migration orchestration (e.g., Airflow, Talend, Informatica)

Hands on exp in Scripting Specifically Python, Shell scripts

Message definitions/ parsing

Experience in different flavours of RDBMS ( Postgres,Oracle,Informix)

2. Migration Planning

Ability to analyze source and target schemas, identify dependencies, and define migration sequencing

Design robust migration strategies (full, incremental, delta loads)

Define rollback and recovery procedures

3. Data Quality & Validation

Define and implement data validation, reconciliation, and audit controls

Plan for data cleansing, deduplication, and transformation logic

4. Performance & Scalability

Architect migration for high throughput and minimal downtime

Plan for parallelization, batching, and error handling

5. Security & Compliance

Ensure data privacy, masking, and secure transfer

Comply with regulatory and audit requirements

6. Automation & Monitoring

Design automated migration pipelines with monitoring and alerting

Enable detailed logging and traceability for all migration steps

7. Communication & Documentation

Document migration architecture, mapping, and business rules

Communicate with business, DBAs, and application teams

8. Testing & Cutover

Plan and execute migration dry runs, cutover, and post-migration validation

Support go-live and subsequent phases