DWH Architect Resume

Posted in Information Technology Resume Examples
Joseph Swanson
2729 Young Road
Boise, ID 83702
(123) 476-7182
Email : [email]

Career Goal
DWH Architect with expertise in Informatica Power Center, RTM, Data Mart and Administration Console seeking employment in a stable company with opportunities for growth
Technical Skills
Expertise in scheduling tools:

  • Control-M
  • Informatica

Specialist in designing tools:

  • MS Visio
  • MS Excel

Dexterity in version control devices:

  • MS Visual Safe Source
  • Harvest
  • Dimension

Quick and excellent in OLAP tools:

  • MicroStrategy
  • OEM
  • APEX

Familiarity with reporting systems:

  • Cognos
  • SSRS
  • SSIS

Adept in build tools:

  • ANT
  • Maven

Solid understanding of SQL tools:

  • SQL Loader
  • SQL navigator
  • TOAD

Technical abilities to:

  • Understand client server technologies and design DWH architecture
  • Implement and use workflow monitor and development tools
Relevant Experience
DWH Architect
Federated Investors, Inc.
January 2012 – Present
Boise, ID
  • Assisted in evaluation of data warehouse sources and business requirements.
  • Prepared and maintained star schemas, logical models and Snowflake.
  • Designed and developed mapping layers in adherence to reporting needs.
  • Developed mappings, worklets and transformations as per document specifications.
  • Utilized Sorter and router transformations for creation of mappings.
  • Participated in simulation of scenarios for performance enhancements.
  • Executed performance tuning of mappings and sessions.
  • Created DDL scripts and UNIX shell scripts for various engineering processes.
DWH Architect
Lorven Technologies
November 2010 – January 2012
Boston, MA
  • Participated in DW project phases from designing to implementation.
  • Maintained enterprise repository for running production jobs.
  • Developed and implemented ETL jobs for various dimensions.
  • Provided assistance in manipulation of source data with PDI designer.
  • Supported various data sources including text file with systematic steps.
  • Created ETL transformations and reviewed SAP applications.
  • Designed and executed star schema and dimension tables.
  • Prepared and updated data warehouses in logical and physical forms.
Educational Background
Master’s Degree in Information Technology
Mid-State Technical College
August 2008 – May 2010
Wisconsin Rapids, WI

Create your own professional looking resume for free using our resume builder!