Sr Datastage & Netezza Developer & Engineer, Remote

Jacksonville, FL - USA

Monthly Salary: $ 60 - 70

Experience Required: 8-10years

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

POSITION SUMMARY

Sr Datastage & Netezza Developer & Engineer

some experience with Snowflake or Databricks will be preferred.

RESPONSIBILITIES

Qualifications

Bachelors degree in Computer Science Information Technology or a related field
5-8 years of data engineer experience in ETL Development with at least 2 years specifically focused on the DataStage-Netezza integration
Deep understanding of Netezzas MPP architecture S-Blades and FPGA processing
Proven ability to debug complex data issues and optimize long-running ETL workflows
Advanced SQL (Netezza-specific SQL) Unix/Linux Shell Scripting
Knowledge of Star/Snowflake schemas Dim & Fact tables and SCD (Type 1/2)
Control-M or AutoSys (Scheduling) Git/SVN (Version Control) Aginity (Netezza Workbench)
Nice to have - some experience with Snowflake or Databricks will be 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. managing Distribution Keys Clustered Base Tables and minimizing 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 to handle data transformation directly within the warehouse (ELT approach)
Develop Unix/Linux shell scripts to automate job scheduling file management and error handling
Implement data validation and cleansing rules to ensure the integrity and accuracy of the data warehouse
Provide production support troubleshoot job failures and perform root cause analysis for performance bottlenecks

Required Skills:

Sr Data Eng Design & develop complex DataStage jobs to extract data with Netezza Senior Qualifications Bachelors degree in Computer Science Information Technology or a related field 35 years of experience in ETL Development with at least 2 years specifically focused on the DataStage-Netezza integration Deep understanding of Netezzas MPP architecture S-Blades and FPGA processing Proven ability to debug complex data issues and optimize long-running ETL workflows Advanced SQL (Netezza-specific SQL) Unix/Linux Shell Scripting Knowledge of Star/Snowflake schemas Dim & Fact tables and SCD (Type 1/2) Control-M or AutoSys (Scheduling) Git/SVN (Version Control) Aginity (Netezza Workbench) 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. managing Distribution Keys Clustered Base Tables and minimizing 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 to handle data transformation directly within the warehouse (ELT approach) Develop Unix/Linux shell scripts to automate job scheduling file management and error handling Implement data validation and cleansing rules to ensure the integrity and accuracy of the data warehouse Provide production support troubleshoot job failures and perform root cause analysis for performance bottlenecks

Required Education:

Masters Preferred

POSITION SUMMARYSr Datastage & Netezza Developer & Engineer some experience with Snowflake or Databricks will be preferred. RESPONSIBILITIESQualificationsBachelors degree in Computer Science Information Technology or a related field5-8 years of data engineer experience in ETL Development with at le...