Pyramid Consulting, Inc ยท 2 months ago
Data Migration Lead
Tampa, FL
Full-time
Onsite
Senior Level
$50/hr - $55/hrPyramid Consulting, Inc. is a leading IT Industry company, and they are seeking a Data Migration Lead for a 12-month contract opportunity in Tampa, FL. The role involves overseeing data migration strategies, ensuring data quality and compliance, and automating migration pipelines.
ConsultingInformation TechnologyLegalProfessional ServicesSoftwareStaffing Agency
Responsibilities
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
Define and implement data validation, reconciliation, and audit controls
Plan for data cleansing, deduplication, and transformation logic
Architect migration for high throughput and minimal downtime
Plan for parallelization, batching, and error handling
Ensure data privacy, masking, and secure transfer
Comply with regulatory and audit requirements
Design automated migration pipelines with monitoring and alerting
Enable detailed logging and traceability for all migration steps
Document migration architecture, mapping, and business rules
Communicate with business, DBAs, and application teams
Plan and execute migration dry runs, cutover, and post-migration validation
Support go-live and subsequent phases
Qualification
Required
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)
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
Define and implement data validation, reconciliation, and audit controls
Plan for data cleansing, deduplication, and transformation logic
Architect migration for high throughput and minimal downtime
Plan for parallelization, batching, and error handling
Ensure data privacy, masking, and secure transfer
Comply with regulatory and audit requirements
Design automated migration pipelines with monitoring and alerting
Enable detailed logging and traceability for all migration steps
Document migration architecture, mapping, and business rules
Communicate with business, DBAs, and application teams
Plan and execute migration dry runs, cutover, and post-migration validation
Support go-live and subsequent phases
Benefits
Health insurance (medical, dental, vision)
401(k) plan
Paid sick leave (depending on work location)
Company
Pyramid Consulting, Inc
Pyramid Consulting, a global leader in workforce and technology solutions, empowers individuals and organizations to transform and thrive in the most challenging and competitive markets.
Founded in 1996
5001-10000 employees
H1B Sponsorship
Pyramid Consulting, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (178)
2024 (112)
2023 (95)
2022 (62)
2021 (50)
2020 (117)
Funding
Current Stage
Late StageLeadership Team
Ramesh Maturu
President and Co-Founder
Manish Kaushik
Chief Financial Officer
Recent News
2025-08-18
Company data provided by crunchbase