Informatica Developer Resume

SUMMARY:

Informatica Developer with 7+ years of IT Experience in analysis, design, development, implementation and troubleshooting of Data Mart / Data Warehouse applications using ETL tools like Informatica Power Center 9.x/8.x/

TECHNICAL SKILLS:

ETL Tools : Informatica Power Center 8.x/9.x

Reporting Tools: Cognos, Business Objects

Programming Skills: Shell Scripting, SQL, PL/SQL

Databases: Oracle 9i/10g/11g, SQL Server 2008/2005/2000 , Teradata V2R4 V2R5, DB2

Methodologies: Data Modeling - Logical, Physical Dimensional Modeling - Star / Snowflake

Operating Systems: UNIX (Sun-Solaris, HP/UX, IBM AIX), LINUXWindows NT/XP

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

Worked as a Team Member on multiple engagements for Data Warehousing and Salesforce.com data Migration/Integration projects as an ETL Developer using different versions of Informatica Power Center as ETL Tools.
Extensive experience in Salesforce.com Data Migration using Informatica with SFDC Connector and Apex Data Loader.
Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like DB2 UDB, Oracle, Flat files, XML files, Sybase and MS SQL Server into Oracle, Teradata, XML, and SQL server targets
Design, develop and support application solutions with a focus on Teradata architecture and its utilities such as Fast Load, Multi Load, Fast export, TPump and BTEQ .
Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, Shortcuts, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
Good understanding of relational database management systems like Oracle and SQL Server and extensively worked on Data Integration using Informatica for the Extraction, transformation and loading of data from various database source systems
Extensively worked on Informatica tools Repository manager, Designer, Workflow manager, Workflow monitor.
Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Expertise in Session partitioning and tuning session and lookup/aggregator/joiner caches for performance enhancements .
Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
Strong in UNIX Shell scripting . Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like Autosys.
Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
Enthusiastic and adaptive of new technologies with Strong technical, Analytical, problem solving and Presentation skills.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship