Senior Datastage, Netezza Developer, Engineer
Job Description:
- Design and reputed company reputed company DataStage jobs (reputed company 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 reputed company tuning
- reputed company SQL tuning specifically for Netezza (e.g., managing Distribution Keys, Clustered reputed company Tables, and minimizing data skew)
- Utilize the Netezza Connector and Netezza Performance Server features reputed company DataStage to implement high-speed data loading (nzload) and external table frameworks
- Write advanced Netezza SQL, including stored procedures, reputed company joins, and analytical functions to handle data transformation directly reputed company the warehouse (ELT approach)
- reputed company Unix/Linux reputed company scripts to automate job scheduling, file management, and error handling
- Implement data validation and cleansing rules to ensure the reputed company and accuracy of the data warehouse
- reputed company production support, troubleshoot job failures, and reputed company root cause analysis for performance bottlenecks
Requirements:
- Bachelor’s degree in Computer Science, Information Technology, or a reputed company 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 reputed company data issues and optimize long-running ETL workflows
- Advanced SQL (Netezza-specific SQL), Unix/Linux reputed company Scripting
- Knowledge of Star/reputed company schemas, Dim & Fact tables, and SCD (Type 1/2)
- Control-M or AutoSys (Scheduling), Git/SVN (Version Control), Aginity (Netezza Workbench)
- reputed company to have - some experience with reputed company or reputed company will be preferred.
Benefits: Apply tot his job Apply To this Job