Sample ETL Informatica Lead Resume

Posted in Information Technology Resume Examples
Jonathon Whitley
4675 Adonais Way
Winder, GA 30680
(222) 577-7388
Email : [email]

Career Goal
A talented and resourceful professional looking for the right opportunity to build a long term career as an ETL Informatica Lead and contribute my skills in designing and implementing Data Warehouse and Data Mart applications, and Transformation processes using ETL tool.
Technical Skills
Well-versed in ETL tools:
  • Informatica PowerCenter
  • SSIS
  • SAS DI Studio 3.4

Technically skilled in databases:

  • Oracle 11g
  • SQL Server
  • Sybase
  • Teradata

Expertise in data modeling tools:

  • Dimensional data modeling
  • Star schema modeling
  • Snow flake modeling

Adept in BI and reporting tools:

  • Business Objects
  • SAS OLAP Cube Studio

Talented in Job schedulers:

  • Autosys
  • Windows task scheduler
  • LSF platform scheduler

Good knowledge of programming languages:

  • SQL
  • XML
  • UNIX shell scripting

Proficient with multiple operating systems:

  • Windows
  • Linux

Immense ability to oversee:

  • Data warehousing
  • Data integration
  • Data migration
Relevant Experience
ETL Informatica Lead
Axius Technologies Inc
January 2012 – Present
Winder, GA
  • Prepared and updated inputs, estimates and requirements for assigned projects.
  • Participated in gathering and analysis of business requirements.
  • Conducted impact analysis for existing business processes.
  • Formulated and maintained data sources, test plans and conditions.
  • Provided assistance during UAT and implementation reviews.
  • Designed and developed new Informatica mappings and workflows.
  • Developed and implemented realtime API with Informatica transformations.
  • Evaluated and documented Informatica mappings and staging tables.
ETL Informatica Lead
Diverse Lynx
November 2010 – January 2012
Wilmington, DE
  • Formulated extraction strategies for research data warehouses.
  • Created exception handling processes for Informatica mapping processes.
  • Utilized Hyperion for data validation of new data marts.
  • Participated in understanding and analysis of business rules and transformation methodologies.
  • Provided assistance for loading of data from source systems such as Oracle and SQL server.
  • Maintained and managed data warehouses for multiple clients.
  • Automated and administered ETL processes for workflows.
  • Suggested suitable modifications for dashboards to ensure proper reporting.
Educational Background
Master’s Degree in Computer Science
Shawnee State University
August 2008 – May 2010
Portsmouth, OH
Professional Certification
Informatica Certified Professional Data Quality Specialist July 2010
We know how to prepare a professional resume!