Position Summary:
This position will be responsible for development of data integration solutions using Netezza technologies. The primary focus is to develop and implement solutions that bring data from a variety of sources spread across geographically distant locations and deliver data to Netezza databases used for enterprise business intelligence and reporting. This position must take into consideration the business case, objectives, requirements and constraints typical for large scale multi-terabyte Data Warehousing applications spanning diverse data sources, multiple BI solutions and large user audiences. This role works closely with Business Analysts, Database Administrators, QA, BI Developers, and Architects.
Essential Job Functions:
- Maintain current ETL frameworks and methodologies using the Netezza SQL and unix Shell scripting.
- Utilize standard design patterns for ETL development in a Netezza environment.
- Analyze performance metrics to ensure delivery deadlines and system stability.
- Lead analysis, design and development of end-to-end ETL solutions in a multi-host environment.
- Collaborate with architects to align the ETL design to the business case and the overall solution.
- Assess the readiness of the Netezza environment (including the systems, tools, technologies, processes, and resource requirements) to implement the ETL solution.
- Grow and transfer Netezza knowledge to other team members
- Under general direction, works on projects/issues of high complexity that require in-depth knowledge across multiple technical areas and business segments.
- Follow and document current and emerging ETL Best Practices.
- Participates in code reviews.
- Follows all change and problem management processes.
- Prepares documentation required for production deployment such as runbooks and release manuals.
- Provides Level 2 "developer on call" support for data integration applications.
- Provides accurate level of effort estimates for data integration development to project managers.
Job Requirements:
- Expert knowledge of Netezza platform and associated tools such as NZload, Data export, temp table usage, and distribution keys.
- Expert design/coding skills, unit testing methodologies and techniques.
- Demonstrated competency in all phases of business intelligence and data warehousing projects, from inception to production deployment.
- Solid understanding of data warehousing principles, concepts and best practices (e.g. ODS, Data Marts, Staging).
- Strong understanding of Release Management process and required applications.
- Must be able to work effectively with both business and technical stakeholders.
- Familiar with business intelligence tools such as MicroStrategy, Tableau or similar.
- Understanding of data modeling principles for data warehousing (Normalization and Star Schema).
- Knowledge of business requirements definition and documentation.
- Strong problem solving and analytic skills.
Solid understanding of MS Office Suite (Visio, MS Project, others...) Strong verbal and written communication skills.
Preferred Qualifications:
- 5+ years of overall IT experience.
- 5+ years hands-on experience in multi-terabyte Netezza data warehousing environments performing technical project efforts including design, build, test, and data conversion/migration.
- 5+ years of experience developing complex ETL solutions utilizing Netezza SQL and Shell scripting.
- 2+ years of hands-on experience with scheduling tools (preferably Tidal).
Education and Experience:
Bachelor's degree (B. A.) from four-year college or university; or equivalent training, education and experience.
Travel Requirements:
No
Supervisory/Managerial Responsibilities:
No Supervisory responsibilities with this position.