ETL Netezza Consultant

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

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.
• At least 2 years of experience in Design and Architecture review.
• At least 2 years of experience in application support and maintenance (including some experience on-call support).
• Good Analytical skills.
• High impact communication.

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.

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 full time job with Infosys
2. GC,USC ,EAD -GC,H4-EAD,L2-EAD