ETL Developer Resume

SUMMARY

Has overall IT experience of over 6.5 years. The functional expertise includes productive work and deliverables in the following areas:
More than 6 years of Data Warehousing and ETL experience using Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
Good knowledge in Informatica, Netezza, PL/SQL and SQL.
Expertise in Toad (Tool for Oracle Application Developers), SQL Developer, Aginity for Netezza
Experience in working with Netezza database.
Proficient in using Informatica Designer, Workflow manager, Workflow monitor and Repository Manager.
Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Expression, Router, Joiner, Update Strategy, Stored Procedure, Sorter, SQL transformation and Sequence Generator.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Responsible to design and develop the mappings to load data.
Worked on aggregator to transpose data.
Involved in weekly status meeting updates with onsite manager.
Implemented rules to handle tricky and complex scheduling tasks in ORSYP.
Parameterized DB connections, Input file names.
Prepared Unit test cases and performed Unit testing for validating the data to meet expected results.
Worked on slowly changing dimensions.
Worked on generating parameter file dynamically to meet complex business requirement.
Developed a framework in Netezza for nonstop data availability for predictive models.

Environment: Informatica Power Center 9.1, Oracle11g, Netezza, Windows 7

Confidential

Netezza Developer

Responsibilities:

Implemented complex SQL logics for generating health parameters from clinical data
Involved in daily standup calls for updates and issues
Co - coordinating with business for gathering requirements
Converted SAS code to Netezza procedures.
Integrating all health parameters for creating scoring tables using analytical and aggregate function.
Loading flat files to Netezza using NZLOAD utility
Generating scoring table for predictive analysis on members data
Prepared Unit test cases and performed Unit testing for validating the data to meet expected results.

Environment: Informatica Power Center 9.1, Oracle11g, Netezza, Windows 7

Confidential

ETL Developer

Responsibilities:

Converted complex SQL scripts to NZSQL procedures
Responsible to design and develop the mappings to load data.
Migrated small tables using IBM Fluid Query reducing lots of development efforts
Migrated large tables using Informatica power center
Created a new framework to load data from stages to target tables reducing maintenance efforts
Prepared Unit test cases and performed Unit testing for validating the data.

Environment: Informatica Power Center 9.1, Oracle11g, Netezza, Windows 7