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