Netezza Data Architect: ETL & Oracle DW to Netezza

Cygnus Professionals; Atlanta (GA); On-site; USD 75,000 - 95,000; Full time

Job summary

Cygnus Professionals is looking for a skilled ETL Developer based in Atlanta, Georgia. The role involves reviewing existing ETL processes, developing extracts for historical data, and implementing nightly data loads from Oracle environments to Netezza.

The ideal candidate will have extensive experience with DataStage and Oracle DW, along with a strong understanding of database management on the Netezza platform. Responsibilities also include redesigning Materialized Views and ensuring data integrity across systems.

Qualifications

• Experience with ETL processes, especially leveraging DataStage and Oracle DW.
• Familiarity with database management on the Netezza platform.
• Ability to develop and redesign Materialized Views.

Responsibilities

• Review current ETL processes for efficiency.
• Develop one-time ETL extract for historical data.
• Create logic for Materialized Views within Netezza.
• Implement nightly ETL extracts from Oracle DW.
• Source directly from Oracle EBS for data loads.
• Load production data from Netezza to test appliance.

Tools

DataStage

Oracle DW

Netezza

Job description

Cygnus Professionals is looking for a skilled ETL Developer based in Atlanta, Georgia. The role involves reviewing existing ETL processes, developing extracts for historical data, and implementing nightly data loads from Oracle environments to Netezza.

The ideal candidate will have extensive experience with DataStage and Oracle DW, along with a strong understanding of database management on the Netezza platform. Responsibilities also include redesigning Materialized Views and ensuring data integrity across systems.