ETL Engineer Resume Tempe, AZ - Hire IT People

SUMMARY:

I am seeking employment as a Data Warehouse Specialist
Gathering requirements
Data modeling
Over 5 Years of Informatica ETL loading of legacy and database data.
Report Writing for end users
A solid understanding of Finance and Marketing that helps me understand business needs & requirements.

TECHNICAL SKILLS:

Developer Tools: Informatica PowerCenter 8.1, SQL, T - SQL, SSIS, SSRS,PL/SQL,Oracle Designer, Oracle Reports

Data Warehouse Training: Received training in Dimensional Modeling at Kimball University

Operation Systems: NT, UNIX

RDBMS: Oracle, SQL Server

General Tools: Microsoft Office, PVCS, SQL Analyzer, TOAD

EMPLOYMENT HISTORY:

Confidential, Tempe, AZ

ETL Engineer

Responsibilities:

Leading the effort of integrating our source system applications to the enterprise field services application, Confidential .
This involves sourcing system of record data from both internal and external applications and bringing it into a format that is accepted by Confidential .
This is an enterprise wide project that has allowed me to interface with external vendors, senior management, and data/application architects.

Technologies Used: SSIS, SSRS, PL/SQL, Visio, SQL Server

Confidential, Houston, Texas

Senior Data Analyst, & ETL Developer

Responsibilities:

After coming in at a junior level, I have took part in multiple projects and enhancements in the company data warehouse.
I have been active involved in JAD sessions where we gather reporting requirements from power users across our organization.
After gathering the data requirements, I have conducting extensive data analysis to determine the optimum way to structure, model, and organize the data for reporting purposes.
After the data modeling, I was ACTIVELY involved in the ETL process of our projects by having worked for over 5 years with the Informatica PowerCenter tool.
The ETL process utilized the crontab process as well as Kornshell scripts in a Unix environment.
I developed ETL processes to load legacy flat files as well as sourcing data from external databases.
I have also recently been managing the Informatica Repository for Confidential .
This includes backing up and upgrading the repository on an ongoing basis.

Technologies Used: Informatica PowerCenter, PL/SQL, Unix Solaris, Syncsort, Oracle

Confidential, Houston, TX

Database Developer

Responsibilities:

I developed reports and forms using Oracle Developer tools while utilizing heavy SQL and PL/SQL code. The modules performed such actions as retrieving pricing and supply costs, inputting current replacement costs for Retail Stores and Company Owned and Operated Stores for Tosco Corporation, a Fortune 500 company.
Performed development and maintenance of over 50 reports, performed such duties as ensuring Y2k compliance of various forms, and created documentation of the functional and technical development for many modules.
AdminiStar
I developed an administrative tool for documenting and reporting both fixes and enhancements to be performed on various modules.

Confidential, Houston, TX

Senior Data Analyst, & ETL Developer

Responsibilities:

Assisted in the implementation of the Confidential & Confidential Smartstream software through product readiness testing,
Worked with outside consultants to determine any reports to be developed,
Used the Hyperion financial software to compare and explain the ledger to financials variances,
Developed basic forms and reports for my team using Oracle Developer 2000