ETL Specialist- Jira Data Migration

Job Title: ETL Specialist — Jira Data Migration / Snowflake Archival

Location: Plano, Texas (Onsite) (only Local candidates)

Project description:

We are seeking an experienced ETL Specialist to support a Jira data migration initiative involving multiple Jira source repositories being consolidated into a single staging Jira repository and eventually loaded into a newly configured Jira environment. The role will focus on data extraction, transformation, normalization, deduplication, and loading activities, while also supporting archival of source repository data into Snowflake for long-term reporting and audit needs.

Responsibilities:

Design, build, and support ETL pipelines for extracting data from multiple Jira source repositories.

Ingest Jira data from APIs, database extracts, CSV/JSON/XML files, or other approved source formats.

Transform and normalize Jira entities such as projects, issues, epics, stories, tasks, subtasks, users, comments, attachments, workflows, statuses, priorities, labels, custom fields, links, and history.

Implement deduplication logic across multiple Jira repositories to identify duplicate issues, users, components, labels, and related metadata.

Support data mapping from source Jira schemas into the target Jira configuration.

Load cleansed and validated data into a staging Jira repository and support final migration into the target Jira instance.

Archive source repository data into Snowflake using structured, queryable data models.

Build reusable ETL scripts, jobs, and data quality checks.

Collaborate with data analysts, QA testers, Jira administrators, and customer stakeholders.

Document ETL logic, transformation rules, exception handling, reconciliation results, and load procedures.

Troubleshoot data load failures, schema mismatches, encoding issues, API limitations, and data quality exceptions.

ETL design documents.

Source-to-target mapping specifications.

Transformation and deduplication logic.

Snowflake archival data model.

ETL jobs/scripts/pipelines.

Data reconciliation reports.

Load execution logs and exception reports.

Migration support documentation.

Must have Skills :

Strong ETL development experience using tools such as Python, SQL, Snowflake, Informatica, Talend, Matillion, dbt, Airflow, Azure Data Factory, or similar platforms.

Strong SQL skills for profiling, transformation, reconciliation, and validation.

Experience working with Snowflake for data storage, archival, reporting, and analytical queries.

Experience with Jira data structures, Jira APIs, Jira exports, or similar enterprise ticketing/work management platforms.

Experience with data normalization, deduplication, merge rules, survivorship logic, and master-data-style matching.

Strong understanding of batch data processing, error handling, logging, and restart ability.

Ability to work with semi-structured data formats such as JSON, XML, and CSV.

Experience handling large data volumes and complex source-to-target mappings.