What are the responsibilities and job description for the Data Migration Lead position at Apex 2000?
Job Details
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