Netezza Migration Engineer - Azure (Remote)

Kforce Inc.

Armonk, NY(remote)

JOB DETAILS
SALARY
$80–$90
SKILLS
Analysis Skills, CA Workload Automation AE (AutoSys Edition), Communication Skills, Cryptography, Data Description Language (DDL), Data Lake, Data Migration, Data Quality, Data Sets, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), Distribution Channel, Financial Services, Health Insurance, IBM Product Family, IBM WebSphere DataStage, Informatica, Information/Data Security (InfoSec), Legal, Machine Tool, Microsoft Product Family, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Performance Tuning/Optimization, Production Support, Python Programming/Scripting Language, Query Optimization, Reconciliation, Risk Analysis, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Short Messaging Service (SMS), Statistics, Stored Procedures, System Migration, Team Player, Telecommunications, Testing, Unix Shell Programming, Validation Plan
LOCATION
Armonk, NY(remote)
POSTED
Today
Kforce's client is seeking a remote hands-on Netezza Migration Engineer to support the migration and modernization of Netezza workloads onto Microsoft Azure. This role will assess existing environments, migrate large-scale datasets, convert SQL and database objects, validate data, and optimize performance in the Azure data platform. Responsibilities:
  • Assess existing Netezza environments, including schemas, tables, views, stored procedures, functions, data volumes, workloads, dependencies, and performance characteristics
  • Develop migration plans for moving Netezza data warehouse workloads to Azure
  • Analyze Netezza-specific architecture, including distribution keys, organize keys, zone maps, data skew, and workload patterns
  • Convert Netezza SQL, DDL, views, stored procedures, and scripts into Azure-compatible SQL or modernized ELT patterns
  • Design and execute data extraction, staging, loading, reconciliation, and validation processes
  • Build or support migration pipelines using Azure Data Factory, Synapse Pipelines, Databricks, or equivalent tooling
  • Validate migrated data using row counts, checksums, hash totals, control totals, sampling, and business-rule validation
  • Tune performance in the target Azure environment, including distribution strategy, partitioning, statistics, indexing, query optimization, and workload management
  • Partner with architects, DBAs, data engineers, application teams, and client stakeholders to identify migration risks and remediation needs
  • Support test cycles, production cutover, rollback planning, and post-migration stabilization
  • Document migration approach, technical decisions, runbooks, data validation results, and operational handoff materials

Requirements:

  • Strong hands-on experience with IBM Netezza / Netezza Performance Server
  • Strong knowledge of Netezza SQL, NZSQL, DDL, stored procedures, functions, views, and utilities
  • Experience with large-scale data warehouse migration or modernization
  • Experience with Azure Synapse Analytics, Azure Data Factory, Synapse Pipelines, Azure Data Lake Storage Gen2, or Azure Databricks
  • Strong SQL development and SQL performance tuning skills
  • Experience with bulk data movement, parallel loads, incremental loads, and data reconciliation
  • Ability to identify and remediate SQL compatibility gaps between Netezza and Azure target platforms
  • Strong understanding of data warehouse concepts, including fact/dimension models, partitioning, distribution, workload management, and query optimization
  • Experience creating migration runbooks, validation plans, and cutover plans
  • Strong communication skills and ability to work with client technical teams and business stakeholders
Preferred:
  • Experience migrating Netezza to Azure Synapse Analytics
  • Experience with T-SQL, Synapse dedicated SQL pools, serverless SQL, or Microsoft Fabric
  • Experience with Python, PySpark, shell scripting, or automation frameworks
  • Experience with legacy ETL tools such as IBM DataStage, Informatica, SSIS, Control-M, Autosys, or Unix shell scripts
  • Experience with data governance, data lineage, security, PII/PHI, encryption, RBAC, and private networking in Azure
  • Experience supporting production cutovers with limited downtime
  • Experience in regulated enterprise environments such as financial services, healthcare, insurance, or telecommunications

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.


About the Company

K

Kforce Inc.

Kforce is a solutions firm specializing in technology, finance and accounting, and professional staffing services. Our KNOWLEDGEforce® empowers top companies to achieve their digital transformation goals. We curate teams of technical experts who deliver solutions custom-tailored to each client’s needs. These scalable, flexible outcomes are shaped by deep market knowledge, thought leadership and our multi-industry expertise.

 

Our integrated approach is rooted in 60 years of proven success deploying highly skilled professionals on a temporary and direct-hire basis. Each year, approximately 18,000 talented experts work with the Fortune 500 and other leading companies. Together, we deliver Great Results Through Strategic Partnership and Knowledge Sharing®.

COMPANY SIZE
1,000 to 1,499 employees
INDUSTRY
Financial Services
FOUNDED
1962
WEBSITE
http://www.kforce.com/