ETL Developer Resume

Informatica / ETL Developer

Summary of Qualifications:

Around 7 years of IT experience in Design, Develop, Test and troubleshoot various software and Business Intelligence applications
Experience in various Industry verticals like Retail , Manufacturing, Healthcare , Finance, Telecommunication with appropriate DW/ETL Implementations
5 Years of strong Data Warehousing experience specializing in RDBMS, ETL, data modeling and data warehousing techniques
Expertise in the ETL Tool Informatica which includes components like Power Center, Power Mart, Power Connect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager, Repository Server Administration Console, IDE - Informatica Data Explorer, IDQ - Informatica Data Quality
Experience in working with various Data Sources like Sybase, Oracle, MS Access, MS Excel, MF COBOL EBCDIC Files, Flat Files, XML Files, etc
Involved in the configuration, administration of Informatica 8.6.1, upgrading the repository from 8.6.1 to 9.1
Worked onCDC at the database layer for nearReal Time Data warehousingusing Informatica.
Expertise in performance tuning ETL code, mappings, sessions and database
Experience in the complete life cycle of quite a few Data Warehouse implementations
Excellent knowledge ofOLTP System Study, Analysis andE-R modeling
Good experience in UNIX Shell Scripting and ETL Process Automation using Shell Programming
Experience in resolving on-going maintenance issues and bug fixes
Experience in Dimension and Fact table loading and data load validations
In depth knowledge of Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
Progressive experience in all phases of the iterative Software Development Life Cycle (SDLC) with a rich experience in gathering the functional requirements and competent in creating the Unified Modeling language (UML)
Experience in using the Informatica command line utilities likepmcmdto controlworkflowsin non-windows environments
Quick learner and adaptive to new and challenging technological environments and initiative to learn new technologies and tools quickly

Technical Competencies:

ETL Tools :Informatica Power Center/Power Mart 9.1/8.x/7.x, Power Exchange
RDBMS : Oracle 11g/10g/9i/8i,MS SQL Server 2008/2005/2000,Sybase, DB2, Netezza, Teradata, etc.
Operating Systems :MS-DOS, Linux, UNIX, Windows 95/98/2000/XP/Vista.
Data Modeling :Erwin 4.0/3.5.2.
Languages/Utilities :UNIX Shell Scripting (Korn shell).
GUI Tools :Toad, Peregrine, CVS, SQL assistant, SQLdeveloper, etc.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship