This job has closed.

eTeam · 2 months ago

Senior Data Migration Developer

United States

Full-time

Remote

Senior Level

eTeam is a company focused on data migration solutions, and they are seeking a Senior Data Migration Developer to support their Enterprise Data Warehouse Migration Program from Netezza to Snowflake. The role involves designing and building data synchronization scripts and ensuring data integrity during the migration process.

Information Technology

Growth Opportunities

H1B Sponsor Likely

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

Qualification

PythonJython scriptingSnowflakeStream SetsNetezza data structuresData profilingCleansingTroubleshooting skillsData quality frameworks

Required

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

Company

eTeam

Glassdoor4.0

eTeam is a staffing agency that also provides payrolling services.

Founded in 1999

Somerset, New Jersey, USA

501-1000 employees

http://www.eteaminc.com

H1B Sponsorship

eTeam has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (36)

2024 (205)

2023 (11)

2022 (7)

2021 (24)

2020 (25)