IBM Netezza

  • Full-time

Company Description

Sonsoft , 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.

Job Description

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

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.

Additional Information

** 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:-

  1. This is a Full-Time Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holder, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.