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
  • ITPAM

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 SpecialistJuly 2010

  • 1.0.0Version
  • 117Download
  • 1File Count
  • March 1, 2020Create Date
  • March 1, 2020Last Updated

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