Informatica ETL Specialist Resume

Posted in Information Technology Resume Examples
Joseph Epperson
4556 Hilltop Street
Richmond, MA 1254
(123) 325-7231
Email : [email]

Career Goal
Seeking the position of Informatica ETL Specialist to share my technical expertise in Informatica PowerCenter, IBM InfoSphere DataStage and Informatica 9
Technical Skills
Profound knowledge of RDBMS concepts:

  • Oracle Builder Forms
  • BO Reports XI

Solid understanding of operating systems:

  • Windows XP
  • UNIX
  • AIX

Familiarity with debugging and additional tools:

  • Quality Center
  • Clear Quest

Cognitively expert in training tools:

  • Information Analyzer
  • Teradata ViewPoint

Dexterity in scheduling tools:

  • Autosys
  • Informatica Scheduler
  • Control M 6.4

Adept in database applications:

  • Teradata 13
  • Oracle 10g
  • MS SQL Server

Expertise in database tools:

  • SQL Loader 9.2
  • SQL Plus 9.2
  • Rapid SQL

Technical abilities to:

  • Prepare complex SQL queries and design ETL integration solutions
  • Understand healthcare terminologies and Informatica data mapping tools
Relevant Experience
Informatica ETL Specialist
Open Systems Technologies
January 2012 – Present
Richmond, MA
  • Participated in loading of data source and files in target tables.
  • Provided technical assistance in workflow debugging and mapping of staging tables.
  • Prepared and executed test plans as per business requirements.
  • Conducted unit and integration testing in Quality Center.
  • Created UNIX scripts, ETL scripts and parameter scripts.
  • Developed mapping attributed with Workflow Designed programs.
  • Designed SQL scripts for troubleshooting of data quality problems.
  • Executed negative tests and XML messages for generation of expressions.
Informatica ETL Specialist
INC Research
November 2010 – January 2012
Raleigh, NC
  • Conducted cost benefit analysis and formulated conceptual specifications.
  • Participated in application of business concepts for company data.
  • Prepared database designs by translation of use cases.
  • Resolved system problems and updated training materials.
  • Analyzed new integration technologies and reviewed business issues.
  • Tested and documented ETL programs from various specifications.
  • Implemented data transformation activities with SQL and Perl languages.
  • Generated ETL performance reports and conducted ETL optimization.
Educational Background
Master’s Degree in Information Technology
Western Technical College
August 2008 – May 2010
La Crosse, WI
Professional Certification
Informatica Certified Professional Data Explorer Specialist July 2010

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