ETL Developer Resume Richmond, VA - Hire IT People

EXPERIENCE SUMMARY:

Overall 4+ years of experience in software development life cycle as a Informatica developer.
Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Oracle.
Extensively worked on Informatica Power Center tools - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
Has experience in data modeling using Star SchemaModeling andSnowflakemodeling, FACT and Dimensions tables.
Worked on Slowly Changing Dimensions (SCD)
Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet & Mapping Designer.
Hands on experience with mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and Re-Usable transformations.
Experience in using SQL, PL/SQL.
Experience in Basic Unix commands.
Good experience in error handling and problem fixing in Informatica.
Multi Country working experience and has experience in working with Offshore teams.
Excellent communication and Inter personal skills
Strong verbal and written communication skills

TECHNICAL SKILLS:

Data warehousing Tools: Informatica Power Center 9.6.1.

Databases: Oracle11g.

Programming GUI: SQL, PL/SQL and UNIX Shell Scripting

Tools/Utilities: PL/SQL developer, ETL

Operating Systems: Windows XP/NT/2003, UNIX

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Analyzed teh business requirements and functional specifications.
Extracted data from oracle database and staged into a single place and applied business logic to load them in teh central oracle database.
Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in teh data warehouse.
Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
Developed mappings in Informatica to load teh data from various sources.
Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with teh logic embedded in teh mappings.
Extensively used Informatica debugger to figure out teh problems in mapping. Also involved in troubleshooting existing ETL bugs.
Created a list of teh inconsistencies in teh data load on teh client side so as to review and correct teh issues on their side.
Written documentation to describe program development, logic, coding, testing, changes and corrections.
Followed Informatica recommendations, methodologies and best practices.

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

Developing teh mappings using needed Transformations in Informatica tool according to technical specifications to populate teh data into Target tables from Source systems.
Developing and implementing teh coding of Informatica Mapping for teh different stages of ETL (Extraction Transformation and Loading).
Developing various Mappings to load teh data from various sources by using different Transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Expression and Sequence Generator to load teh feeds data.
Fixing teh invalid informatica mappings and troubleshoot teh technical problems of teh database.
Development of Informatica Mappings to accomplish Auditing and Error handling of Target load.
Developing Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored teh results using workflow monitor.
Debugging teh informatica sessions by utilizing teh logs of teh sessions.
Creating UNIX shell script for teh start and stop procedures of teh sessions.
Performing unit testing at various levels of teh ETL.
Extensively worked on identifying teh bottlenecks and fine-tune teh mappings.