Senior Consultant

"Schema Mapping & Transformation (PostgreSQL/Oracle to Cloud schema); JSON parsing XML transformation Automated Data Quality Testing (using Python, Postman, or custom frameworks) "DTCC- Non OMAI Atlassian Migration Data & Automated Testing Developer to own data validation, schema structural mappings, and end-to-end automated testing during Jira Data Center to Cloud transition. Your primary mission is to ensure zero data loss, maintain absolute compliance consistency, and programmatically catch configuration drifts or corruption before final cutover. Rather than running manual UI tests, you will architect automated data comparison pipelines, write testing frameworks against live APIs, and validate complex relational databases against Atlassian Cloud JSON endpoints. Key Responsibilities Schema Mapping & Transformation Analyze legacy Jira Data Center relational database schemas (PostgreSQL/Oracle) and create structured data transformations to match Jira Cloud’s multi-tenant object schemas. Automated QA Engineering Build, maintain, and execute automated test suites (using Python, Postman, or custom frameworks) that programmatically cross-check pre-migration and post-migration data scopes (e.g., matching issue counts, custom field data arrays, attachments, and histories). Data Integrity Verification Develop validation scripts to catch structural anomalies, duplicate configuration objects (like identically named workflows or statuses), and broken entity relationships during iterative dry run.l API Validation & Reconciliation Leverage Jira DC and Cloud REST APIs to perform automated mass-diffing of system entities, checking that issue links, epics, sub-tasks, and agile board boards match down to the exact field mapping. Audit Logging & Reporting Generate programmatically driven data-reconciliation scorecards for executive stakeholders and compliance audits, ensuring GDPR-compliant data sanitization (mapping usernames to accountIds cleanly).