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 and data-warehouse solutions on Netezza. Write NZSQL/NZLOAD and complex SQL, tune queries, use Netezza DDL and functions, support production systems (including on-call), perform architecture and design reviews, fix data issues, and improve performance.
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 equivalent experience)
  • Minimum of 4+ years work experience in IT
  • 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) and locking mechanisms
  • Query tuning experience using statistics in Netezza
  • Proficient writing complex SQL (joins, aggregations) and UNIX scripts
  • Experience writing NZSQL and NZLOAD scripts and executing them
  • Good understanding of data warehouse modeling concepts
  • Ability to write efficient views to meet reporting requirements
  • Provide solutions/enhancements to quickly fix data issues; application support and maintenance (including on-call)
  • Certification in Netezza
  • At least 4 years experience in software development life cycle stages
  • At least 4 years experience in project life cycle activities (development and maintenance)
  • At least 2 years experience in design and architecture review
  • At least 2 years experience in application support and maintenance
  • 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