About the Company
Mainframe DB2 Data Architect with deep expertise in log‑based Change Data Capture, real-time data replication, and hybrid cloud data modernization, specializing in non‑intrusive CDC designs using IBM and third‑party tools.
About the Role
Database Migration Schema transformation of DB2/VSAM /IMS into target relational models (Oracle, PostgreSQL, SQL Server, Azure SQL) including DDL/index/view generation and VSAM field/key rationalization to normalized structures.
Responsibilities
- Data migration & reconciliation: export legacy data, scrub/mask as required, import to target, and perform roundtrip equivalence using checksums/recordlevelcomparisons; maintain referential integrity across environments.
- Data Architecture & Modelling Tools: Data integrity and balance accuracy with documented reconciliation packs for customer signoff.
- Co-existence and CDC (Sync-back to Mainframe): Experience of CDC Fundamentals, DB2-specific CDC design, High-availability CDC architectures (active-active, restartability), Log scraping and capture agents (non-intrusive CDC).
Qualifications
- CDC Tools & Products (Hands-on Expectations):
- IBM InfoSphere Data Replication (IIDR) / CDC
- IBM Db2 Data Gate for z/OS
- IBM Analytics Accelerator (CDC feeds to analytics)
- Informatica PowerExchange CDC for DB2 z/OS
- Precisely / Syncsort CDC
- Oracle GoldenGate (architectural comparison skill)
- Qlik Replicate (CDC pipelines)
Required Skills
- Integration & Modernization Skills: Integration with cloud-native analytics and BI.
- API and event-driven patterns built on CDC streams.
- Mainframe-to-cloud parallel-run migration strategies.
- Coexistence of ETL + CDC architectures.
Preferred Skills
- Experience with various CDC tools and architectures.
Pay range and compensation package
[Pay range or salary or compensation]
Equal Opportunity Statement
[Include a statement on commitment to diversity and inclusivity.]
