IBM Netezza
Sonsoft Inc
Apply to this jobSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
Qualifications
Basic
· Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education.
· Minimum of 4+ years of work experience in the Information Technology Field.
· Minimum of 4+ years of hands on Netezza experience.
· Experience in full software development lifecycle of the Data Warehousing Project.
· Strong knowledge of Netezza Architecture: Nodes, S-Blades, FPGA, Disk Enclosures.
· Efficient usage of Netezza DDL Statements – Derived Tables, EXTERNAL Tables, Materialized Views.
· Hands on Knowledge on Netezza Concepts – Data Distribution, Zone-Maps.
· Understand the Concept of Locking Mechanisms in Netezza.
· Experience on Query Tuning mechanisms using proper usage of Statistics in Netezza.
· Efficient in Writing SQL’s with complex joins, aggregations, UNIX Scripts.
· Good understanding of Data Warehouse Modeling concepts.
· Experience in using the built in Netezza Functions.
· Efficient in writing NZSQL and NZLOAD Scripts and executing the scripts.
· Responsible for writing efficient views based on user and reporting requirements.
· Must be able to provide Solutions or Enhancements to fix the data issues quickly when reported by the clients or users.
· Flexibility to Self-learn and understand the system, further assist with query tuning and application performance.
Preferred
· At least 4 years of experience in software development life cycle stages.
· Certification in Netezza.
· At least 4 years of experience in Project life cycle activities on development and maintenance projects.
Qualifications
Basic
· Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education.
· Minimum of 4+ years of work experience in the Information Technology Field.
· Minimum of 4+ years of hands on Netezza experience.
· Experience in full software development lifecycle of the Data Warehousing Project.
· Strong knowledge of Netezza Architecture: Nodes, S-Blades, FPGA, Disk Enclosures.
· Efficient usage of Netezza DDL Statements – Derived Tables, EXTERNAL Tables, Materialized Views.
· Hands on Knowledge on Netezza Concepts – Data Distribution, Zone-Maps.
· Understand the Concept of Locking Mechanisms in Netezza.
· Experience on Query Tuning mechanisms using proper usage of Statistics in Netezza.
· Efficient in Writing SQL’s with complex joins, aggregations, UNIX Scripts.
· Good understanding of Data Warehouse Modeling concepts.
· Experience in using the built in Netezza Functions.
· Efficient in writing NZSQL and NZLOAD Scripts and executing the scripts.
· Responsible for writing efficient views based on user and reporting requirements.
· Must be able to provide Solutions or Enhancements to fix the data issues quickly when reported by the clients or users.
· Flexibility to Self-learn and understand the system, further assist with query tuning and application performance.
Preferred
· At least 4 years of experience in software development life cycle stages.
· Certification in Netezza.
· At least 4 years of experience in Project life cycle activities on development and maintenance projects.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Full-Time Permanent job opportunity for you.
- Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Summary
Develop, tune, and maintain Netezza-based data warehousing solutions; optimize SQL and performance.
Job title
IBM Netezza
Experience level
4+ years
Industry
software
Location requirements
Charlotte, NC, US; remote not specified.
Salary
Not specified
Visa sponsorship
H-1B sponsor history
Management role
No
Required skills
Preferred skills
Specializations
Structured locations inferred from the posting.
Charlotte, NC, USA