Sr Datastage & Netezza Developer & Engineer,- Remote

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