ETL Netezza Consultant

Reposted 24 Days Ago
Be an Early Applicant
Phoenix, AZ, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop and maintain ETL solutions on IBM Netezza. Write NZSQL/NZLOAD and complex SQL, use Netezza DDL and functions, tune queries using statistics, implement data warehouse models, create efficient views, provide application support and on-call troubleshooting, and contribute to design and architecture reviews.
Summary Generated by Built In
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

Skills Required

  • Bachelor's degree or foreign equivalent (or one year relevant work experience in lieu of every year of education)
  • Minimum of 4+ years work experience in Information Technology
  • Minimum of 4+ years hands-on Netezza experience
  • Experience in full software development lifecycle of Data Warehousing projects
  • 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 of Netezza concepts (Data Distribution, Zone-Maps)
  • Understanding of locking mechanisms in Netezza
  • Experience with query tuning using statistics in Netezza
  • Efficient in writing complex SQL with joins and aggregations
  • Experience writing UNIX scripts
  • Good understanding of data warehouse modeling concepts
  • Experience using built-in Netezza functions
  • Efficient in writing and executing NZSQL and NZLOAD scripts
  • Ability to write efficient views based on reporting requirements
  • Ability to provide solutions/enhancements to quickly fix data issues
  • Flexibility to self-learn and assist with query tuning and application performance
  • At least 4 years experience in software development life cycle stages
  • Certification in Netezza
  • At least 4 years experience in project life cycle activities on development and maintenance projects
  • At least 2 years experience in design and architecture review
  • At least 2 years experience in application support and maintenance (including on-call support)
  • Good analytical skills
  • High impact communication
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
Phoenix, AZ, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
Phoenix, AZ, USA
87 Employees

Samsara Logo Samsara

Manager, Implementation - Enterprise Select

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
109K-166K Annually

HoneyBook Logo HoneyBook

Account Executive

Fintech • Payments • Productivity • Software • Automation
Remote or Hybrid
USA
270 Employees
95K-140K Annually

Similar Companies Hiring

Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees
Revel.io Thumbnail
Aerospace • Hardware • Robotics • Software
US
50 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account