Description

Design and implement high-availability data migration, replication, and CDC architectures bridging mainframe and cloud environments.

Responsibilities

• Execute data migration and reconciliation, scrubbing legacy data, importing to targets, and validating roundtrip equivalence via checksums.
• Design CDC solutions for co-existence, ensuring log scraping, capture agents, and restartability for active-active architectures.
• Model data architectures to maintain referential integrity and balance accuracy, delivering documented reconciliation packs for sign-off.
• Integrate cloud-native analytics and BI using API and event-driven patterns built on CDC streams.
• Architect parallel-run migration strategies and coexistence models for ETL and CDC pipelines.

Required Skills

• 5+ years of experience in database architecture and data engineering.
• Hands-on expertise with CDC tools: IBM InfoSphere Data Replication (IIDR), Db2 Data Gate for z/OS, or Informatica PowerExchange.
• Proficiency in Oracle, PostgreSQL, SQL Server, and Azure SQL.
• Strong knowledge of DB2 and VSAM data structures and integration.
• Experience with ETL processes and cloud-native analytics integration.
• Bachelor's degree in Computer Science or related field.

Preferred Skills

• Experience with IBM Analytics Accelerator or Oracle GoldenGate for architectural comparison.
• Familiarity with Qlik Replicate for CDC pipeline implementation.

Key Skills

Education

Bachelor's degree