Senior ETL Developer Resume

SUMMARY:

PROFESSIONAL EXPERIENCE:

Senior ETL Developer

Confidential

Responsibilities:

Teacher

Confidential

Responsibilities:

ETL Architect

Confidential, Dallas

Responsibilities:

Designed ETL processes for new data warehouse project for Fortune Global 500 client
Designed database table models for TeraData and Oracle
Interviewed business users to determine requirements
Translated requirements into overall strategy and specific tactics
Lead ETL team for a project to in corporate marketing data into data warehouse
Lead ETL team for a project to create asset management value - add for corporate customers
Informatica Confidential 8.1 and 8.5 programming for all stages of the ETL process
Optimized design for Teradata and Oracle tables and indexes (world's largest Teradata for Windows server farm)
SQL scripting for TeraData and Oracle
Reporting data mart design
Worked among a large, geographically diverse team
Worked with extremely large datasets of international data from overseas source servers
Worked with Business Objects reporting team to optimize database performance
Adhered to change control mechanisms

Data Warehouse ETL Architect / Programmer

Confidential, Denver

Responsibilities:

Informatica Confidential 7.1 programming for all stages of the ETL process
Worked closely with data analysts to document requirements of new features and changes
Adhered to change control mechanisms
Created documentation templates for warehouse load and extract processes
Planned, tested, and implemented schema changes
Designed and implemented audit tracking
Managed SQL Server databases and Informatica Confidential repositories
Optimized SQL Server tables and indexes
Worked with Business Objects reporting team to optimize database performance
Followed HIPPA data security requirements

Data Warehouse Programmer

Confidential, Denver

Responsibilities:

Data transformation with Informatica Confidential 7.1
Gap analysis of source system data in preparation for integrating data to data warehouse
Created metadata documents profiling data from source systems
Assisted with data warehouse modeling
Hands on database management at data warehouse and data mart levels
Worked on ETL programming for international data from overseas source servers