We provide IT Staff Augmentation Services!

Etl Developer Resume

0/5 (Submit Your Rating)

Richmond, VA

Hire Now

SUMMARY

  • Ten years of experience in System Analysis, Design and Development in the fields of databases, data warehouse and client server technologies
  • Eight years of extensive experience in using ETL (Extraction, Transformation, Loading) utilizing Informatica 5.1/6.2/7.1.3/8.5.1 (Power Mart/Power Center)
  • Strong knowledge of Ab Initio data movement concepts like parallelism, multi - stage component utilization, m commands and EME air commands
  • Strong knowledge of performance tuning of Ab Initio graphs using transform components like Join, Rollup, multi-reformat etc
  • More than three years of experience using ERWIN as leading data modeling tool
  • Extensive experience in writing stored procedures (PL/SQL), triggers and packages using Oracle/Sybase
  • Experienced in using OLAP Tools such as Business Objects 4.1.4/5.1.4 (Designer, BO) and Web Intelligence 2.6/2.7
  • Extensive experience in performance tuning of sources, mappings, targets and sessions
  • Extensive experience in the creation of ETL Mappings and Transformations using Informatica PowerMart/ PowerCenter to move data from multiple sources into target
  • Involved in gathering and analyzing the business/system requirements, drafting technical design documents, implementing solutions, trouble shooting, applying patches/fixes and maintaining effective documentation adhering to high quality standards during various phases of the project lifecycle
  • Well versed with SDLC processes like change management, issue management, configuration & object tracking, QA methodologies etc
  • Excellent communication and interpersonal skills. Worked closely with the client on various occasions and played a key role while interacting with Functional Personnel/Users for effective issue resolution
  • Proven abilities in managing increased responsibilities and delivering critical projects on schedule

TECHNICAL SKILLS

ETL: INFORMATICA Power Center/Power Mart 8.6.1/7.1.3/6.2/6.1/5.1 Ab Initio GDE 3.1.3.2

Databases: Oracle 11/10.x/9.x/8i/7.x, SQL Server 2008/7.0/6.5 , MS Access 7.0/2000, Sybase 12.5/15, DB2 8.0, Teradata 13.x

DB Query Tools: Advance Query Tool 6.1.4, WinSQL 4.1, Embarcadero DBArtisian 8.1.2TOAD 9.0.1.8/8.0/7.6 , SQL*Plus, PL/SQL Developer 5.1

Database Modeling: Erwin 7.1/4.0/3.5.2 , ER/Studio 6.6, TOAD 9.0.1.8/8.0/7.6

Database Skills: Stored Procedures, Views, Database Triggers and Packages.

Operating Systems: Microsoft Windows 95/98/00/NT/XP, MS-DOS, Linux, Solaris 8 and UNIX

OLAP/DSS Tools: BusinessObjects 5i, Supervisor, Designer, InfoView 4.0, BusinessMiner 4.2, Broadcast Agent 5.0, WebIntelligence 2.6

Test Management Tools: Mercury Quality Center 9.0

Version Control Tools: TortoiseSVN 1.6.15/1.4.8, Tivoli Scheduler, Clear Case

Languages: C, C++, SQL, PL / SQL, UNIX Shell Scripting, Java, COBOL, PERL, HTML, DHTML, JavaScript, JSP, XML

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship