Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Principal Data Architect (Historical Data Migration)
Job
Resource Innovative Technologies LLC
Bethesda, MD (In Person)
Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
75
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Job Description:
Principal Data Architect (Historical Data Migration)Location:
Bethesda, Maryland Role Summary:
Lead solution architecture and technical governance for a large-scale historical data migration (3B+ records) from DB2 to Salesforce using a PostgreSQL staging/ETL layer. Own end-to-end migration strategy, scalability/performance design, data quality and reconciliation, and phased (throttled) capability activation with incremental delta loads to enable reliable, auditable Production cutover. Qualifications- 20+ years in data architecture/engineering, leading large-scale migrations (hundreds of millions to billions of records) from legacy/mainframe sources (e.g., DB2) to cloud/SaaS targets.
- Strong SQL + PostgreSQL (staging/ETL persistence): schema design, partitioning, bulk loading, tuning, and operational rigor (HA/DR/backup, auditability, reconciliation).
- Delta/incremental load design (CDC/watermarking, micro-batching), with idempotent processing and replay/backfill strategies.
- Salesforce data loading at scale: object modeling, external IDs, load sequencing, Bulk API patterns, and governor/locking constraints.
- Data quality, de-duplication, and survivorship frameworks for customer/transaction domains; strong validation and reconciliation patterns.
- Cloud experience on AWS supporting large-scale data platforms/migration factories (e.