ETL Netezza Consultant

Location: Phoenix, AZ, us

Company Description

SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are 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.
• Ability to ramp up in new technologies.
• Ability to work in a team, in diverse/ multiple stakeholder environment.
• Experience and desire to work in a Global delivery environment.

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 who are authorized to work independently in the United States are encourage to apply. We are unable to sponsor at this time.

Note:-

1. This is a Full Time & Permanent job opportunity.
2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD can apply.
3. H1B Visa Transfer can also apply for this position.
   
4. No OPT-EAD and TN Visa candidates please.
5. Please mention your Immigration Status while applying .
6. All your information will be kept confidential according to EEO guidelines.