Agile Programming Methodologies, Amazon Web Services (AWS), Application Programming Interface (API), Atlassian JIRA, Cloud Computing, Data Formats, Data Migration, Data Processing, Data Storage, Data Structures, Database Extract Transform and Load (ETL), Error Handling, Informatica, JSON, Microsoft Windows Azure, Network Operations Center, Python Programming/Scripting Language, Query Analysis, REST (Representational State Transfer), Reconciliation, SQL (Structured Query Language), Snowflake Schema, Source Code/Configuration Management (SCM), Sprint Planning, Structured Data, System Migration, XML (EXtensible Markup Language)
ETL SPECIALIST — JIRA DATA MIGRATION / SNOWFLAKE ARCHIVAL
PROJECT DESCRIPTION
Seeking an experienced ETL Specialist to support a Jira data migration initiative involving multiple source repositories being consolidated into a single staging Jira repository and loaded into a newly configured Jira environment. The role focuses on data extraction, transformation, normalization, deduplication, and loading, along with archival of source data into Snowflake for long-term reporting and audit needs.
MANDATORY SKILLS
- Strong ETL development experience with Python, SQL, Snowflake, Informatica, Talend, dbt, Airflow, Azure Data Factory, or similar platforms
- Strong SQL skills for profiling, transformation, reconciliation, and validation
- Experience with Snowflake for data storage, archival, reporting, and analytical queries
- Experience with Jira data structures, Jira APIs, 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 restartability
- Ability to work with semi-structured data formats — JSON, XML, and CSV
- Experience handling large data volumes and complex source-to-target mappings
NICE-TO-HAVE SKILLS
- Experience with Jira Cloud, Jira Data Center, or Jira Service Management migrations
- Experience using Atlassian REST APIs
- Experience with Python libraries — pandas, requests, SQLAlchemy, PySpark, or Snowpark
- Experience with data governance, lineage, auditability, and archival strategies
- Experience with Azure, AWS, or cloud-based data platforms
- Familiarity with Agile delivery, sprint planning, and migration cutover activities
G
Glint Tech Solutions LLC