Senior Data Migration Developer

1 week ago


Chicago, IL, United States eTeam Full time
Title: Data Migration Developer(Netezza to Snowflake)
Location: Remote
Duration: 6 Months of Contract


Must-Have Skills:
Strong hands-on experience with Python or Jython scripting for data extraction and synchronization
Proficiency with Stream Sets for orchestration, scheduling, and automation of data pipelines
Advanced knowledge of Snowflake, including development of stored procedures, custom logic, and incremental load strategies
Experience with Netezza data structures and ability to map, transform, and migrate to Snowflake
Experience performing data profiling, cleansing, and validation to ensure accuracy and integrity
Proven ability to monitor production data loads and maintain performance during migration activities
Strong troubleshooting and problem-solving skills to resolve migration issues effectively
Familiarity with data quality frameworks and post-migration validation processes

Detailed Job Description:
This role supports the Enterprise Data Warehouse (EDW) Migration Program from Netezza to Snowflake. The Senior Developer will be responsible for designing and building data synchronization scripts to manage both historical and incremental data migration from Netezza to Snowflake. A framework for this data synchronization exists already but the candidate will be responsible to move the data and resolve issues in doing so. The ideal candidate will have strong experience in Python/Jython scripting, Stream Sets orchestration, and Snowflake stored procedures.

Key Responsibilities:
Analyze legacy Netezza data structures and develop mapping strategies to Snowflake.
Create, test, and deploy Python/Jython scripts for extracting and syncing data from Netezza to Snowflake.
Develop, test, orchestrate, and schedule Stream Sets jobs to execute data sync scripts.
Conduct data profiling, cleansing, and quality checks to ensure data integrity and completeness.
Create and maintain custom Snowflake stored procedures for data extraction using custom logic, including checksum calculations for incremental loads.
Create, modify, maintain, and deploy Stream Sets manifests for data sync activities.
Monitor Netezza production loads to ensure no disruption during data extraction.
Provide proactive suggestions and assistance in identifying and resolving potential issues.
Update and manage scheduling timelines for Stream Sets jobs.
Ensure optimal balancing of data pulls from Netezza to avoid performance impacts.
Execute post-migration data validation to confirm successful and accurate data transfer.

  • Chicago, IL, United States ApTask Full time

    About Client: The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...


  • Chicago, IL, United States Artech Full time

    Job Opportunity in Chicago, IL Join our dynamic team in Chicago, IL, where innovation meets opportunity. As a key player in our Technology Software Services vertical, you'll be at the forefront of data migration solutions in a vibrant and bustling city known for its rich culture and diverse community. Duration: 6 months, 100% Onsite, 5 Days a week Key...


  • Chicago, IL, United States Diverse Lynx Full time

    SAP Data Migration Lead Public Cloud Data Architect with expertise in defining and executing data migration strategies using SAP tools (Data Migration Cockpit, LTMC). Experience in managing SAP data governance, ensuring data quality, and integrating with external systems via SAP BTP. Must have experience in SAP Activate methodology with at least 2 full-cycle...


  • Chicago, IL, United States Diverse Lynx Full time

    SAP Data Migration Lead Public Cloud Data Architect with expertise in defining and executing data migration strategies using SAP tools (Data Migration Cockpit, LTMC). Experience in managing SAP data governance, ensuring data quality, and integrating with external systems via SAP BTP. Must have experience in SAP Activate methodology with at least 2 full-cycle...


  • Chicago, IL, United States RLDatix Full time

    RLDatix is on a mission to transform care delivery worldwide, ensuring every patient receives the safest, highest-quality care. Through our innovative Healthcare Operations Platform, we're connecting data to unlock trusted insights that enable improved decision-making and help deliver safer healthcare for all. At RLDatix we're making healthcare safer,...


  • Chicago, IL, United States iSoftTek Solutions Inc Full time

    Workday Data Migration Test Lead Position: Workday Data Migration Test Lead Duration: 12+ months (until the end of 2026) Location: Hybrid – 3 days onsite per week in Chicago, IL (Local is preferred but will consider relocation candidates.) JD: We are seeking a seasoned Workday Test Lead to support a major Workday migration project. This onshore,...


  • Chicago, IL, United States Ztek Consulting Full time

    Overview Global Executive Search Consultant at ZTek Consulting Inc Role: Salesforce Technical Lead, onsite in Chicago, IL - Full-time Base pay range $100,000.00/yr - $135,000.00/yr Must Have Technical/Functional Skills Hands-on complex coding on APEX, LWC, and integration is mandatory. There will be live coding in the interview Sales, service, and...


  • Chicago, IL, United States 1872 Consulting Full time

    Senior .NET Developer - Azure Focus Chicago, IL (potentially other cities) - onsite just 1 day/week most weeks, max 2 days onsite every now and then Summary This role is with a global professional services firm, that just started their push from on-prem to Azure in 2022. This .NET Developer will sit on a team of 10: 6 .NET Developers 1 DevOps Engineer 3...


  • Chicago, IL, United States 1872 Consulting Full time

    Senior .NET Developer - Azure Focus Chicago, IL (potentially other cities) - onsite just 1 day/week most weeks, max 2 days onsite every now and then Summary This role is with a global professional services firm, that just started their push from on-prem to Azure in 2022. This .NET Developer will sit on a team of 10: 6 .NET Developers 1 DevOps Engineer 3...

  • Data Architect

    1 week ago


    Chicago, IL, United States Artech Full time

    Job Title: Data Architect / Senior Data Engineer - GCP Location: CHICAGO, USA, IL Required Skills & Qualifications Applicants must be able to work directly for Artech on W2 Proven experience in data modeling, integration, and security Strong expertise in performance optimization and data governance Hands-on experience with Google Cloud Platform (GCP)...