Simple Software Solutions Group, Inc

Sr Datastage & Netezza Developer & Engineer,- Remote

Simple Software Solutions Group, Inc  •  Jacksonville, FL (Remote)  •  3 months ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description


POSITION SUMMARY


Sr Datastage & Netezza Developer & Engineer
,
some experience with Snowflake or Databricks will be preferred.


RESPONSIBILITIES


Qualifications


  • Bachelor’s 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 Netezza’s 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
Simple Software Solutions Group, Inc

About Simple Software Solutions Group, Inc

Simple Solutions is a US based company and Microsoft Partner with a global presence that provides a broad range of software and IT services solutions to better help our clients manage their business. Our personalized service follows industry “best practices” and delivers cost effective and efficient solutions for our client’s business and IT needs.

Simple Solutions has a broad portfolio of cloud and packaged software expertise with development and Integration services. We are also providers of custom and off-the-shelf software products to address specific business and IT challenges.

Simple Solutions has a broad portfolio of cloud and packaged software expertise with development and Integration services. We are also providers of custom and off-the-shelf software products to address specific business and IT challenges.

Industry
IT & Software
Company Size
11-50 employees
Headquarters
West Palm Beach, Florida
Year Founded
2017
Website
sssg.us
Social Media