Senior DataStage ETL Engineer — Netezza ELT Specialist

Zohorecruit; Jacksonville (FL); On-site; USD 110,000 - 160,000; Full time

Job summary

Zohorecruit in Jacksonville, FL is seeking an experienced Data Engineer specializing in ETL development with DataStage and Netezza. You will design, tune, and maintain complex ETL jobs, optimize SQL for Netezza, and implement high-speed data loading strategies.

You will also develop shell scripts for automation, enforce data validation rules, and provide production support to ensure warehouse integrity. Collaboration with teams on data modeling and scheduling workflows is essential.

Qualifications

• Bachelor's degree required.
• 5-8 years of data engineer experience in ETL Development.
• Experience with DataStage-Netezza integration preferred.

Responsibilities

• Design and develop complex DataStage jobs (Parallel and Sequence) to extract data from various sources (Flat Files, DB2, SQL Server, APIs) and load them into Netezza.
• Optimize DataStage jobs using partitioning, sorting, and buffer tuning.
• Perform SQL tuning specifically for Netezza (e.g., distribution keys, clustered base tables, data skew).
• Utilize the Netezza Connector and Netezza Performance Server features within DataStage to implement high-speed data loading (nzload) and external table frameworks.
• Write advanced Netezza SQL, including stored procedures, complex joins, and analytical functions for ELT within the warehouse.
• Develop Unix/Linux shell scripts to automate job scheduling, file management, and error handling.
• Implement data validation and cleansing rules to ensure data warehouse integrity.
• Provide production support, troubleshoot job failures, and perform root cause analysis for performance bottlenecks.

Skills

ETL Development

Netezza architecture

Troubleshooting ETL

Dimensional Modeling

SCD (Type 1/2)

Control-M

AutoSys

Git

SVN

Aginity

Snowflake/Databricks (nice to have)

Education

Bachelor’s degree in Computer Science, Information Technology, or a related field

Tools

DataStage

Netezza

Control-M

AutoSys

Git

SVN

Aginity

Snowflake/Databricks

Job description

Zohorecruit in Jacksonville, FL is seeking an experienced Data Engineer specializing in ETL development with DataStage and Netezza. You will design, tune, and maintain complex ETL jobs, optimize SQL for Netezza, and implement high-speed data loading strategies.

You will also develop shell scripts for automation, enforce data validation rules, and provide production support to ensure warehouse integrity. Collaboration with teams on data modeling and scheduling workflows is essential.