Netezza Developer Resume Mahwah, NJ - Hire IT People

PROFESSIONAL SUMMARY:

Having 10+ years of development experience in IT and involved in analysis, design, development, testing & implementation of business logic
Working in Retail Domain for past 4+ years
Worked in HealthCare, Telecom and Manufacturing domains prior
Highly skilled and technically - minded Netezza Developer
Have strong knowledge in multiple languages and platforms
Experienced in Onshore and Offshore working model
Have been involved into maintenance with timely delivery against aggressive deadlines

TECHNICAL SKILLS:

Development Tools: Aginity, Oracle SQL Developer, PL/SQL Developer, Toad, puTTy, Elixir Repertoire Designer, Control-M, AppWorx, IBM Rational Software Architect, Eclipse IDE, Microsoft Team foundation server, Microsoft Visual Sourcesafe 6.0 used for Version Control, Service Now(Incident/Change management)

Software: PLSQL programming, UNIX Shell Scripting, Crystal reports, DSD Language

Openet Fusionworks: Activecharge 1.5.2 for Telecom Mediation

Systems: IBM AIX Server, RedHat Linux, Sun Solaris Server, Windows

Databases: Netezza, Oracle

EXPERIENCE:

Netezza Developer

Confidential - Mahwah, NJ

Conducted ETL development in the Netezza environment using standard design methodologies
Monitored progress and documented compliance with ETL best practices standards
Assessed the Netezza environment for implementation of the ETL solutions
Ensured all deadlines were met and analyzed stability
Managed Netezza queries by performance tuning and techniques
Assisted in support functions and maintenance of data warehousing applications as per requirements

Developer

Confidential - Minneapolis, MN

Used Netezza SQL to maintain ETL frameworks and methodologies in use by the company
Suggested steps and concepts for detailed estimation, designing and functionality of data warehouses
Conducted code reviews
Wrote and drafted manuals needed for developed applications
Worked on highly complex projects in many different and varied technical areas and business segments
Collaborated with software architects to ensure alignment of the Netezza environment

PL/SQL Developer

Confidential

Involved in SDLC gathering requirements from end users
Developed views to facilitate easy interface implementation and enforce security on critical customer information
Developed stored procedures and triggers to facilitate consistent data entry into the database
Written Stored Procedures using PL/SQL and functions and procedure for common utilities
Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages
Created programming code using advanced concepts of Records, Collections, and Dynamic SQL
Developed Database Triggers for audit and validation purpose
Used pipelined functions for faster data accessibility
Writing validation packages using PL/SQL package
Used PL/SQL to validate data and to populate billing tables
Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
Developed Installation scripts for all the deliverables
Performed functional testing for the procedures and packages
Created and manipulated stored procedures, functions, packages and triggers using TOAD
Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose

PL/SQL Developer

Confidential

Performed requirement gathering, designing and development of data models for operational control and monitoring
Created tables to capture errors and data that failed Validation Checks
Re-validated corrected data from source and re-processed to get them loaded to the oracle target
Re-worked on the BAD Files that were generated by SQL Loader
Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file
Responsible to write scripts which identify the legacy data and the valid data
Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties
Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process
Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF
Used SQL hints and Indexes as needed to improve SQL performance
Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation
Wrote UNIX Shell scripts for performing development and DBA activities
Tested the ETL process in testing environment and created test cases

We provide IT Staff Augmentation Services!

Netezza Developer Resume

Mahwah, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship