SUMMARY:

• 7 years of expertise experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Powercenter8.6.1/ 7.x/6.2.
• Five years of experience in data warehousing application using ETL tool Sql, Unix, etc.
• Expertise in implementing complex mapping transformation rules enabling loading data from Source to target Databases in a complex, high volume environment.
• Experience in Production Support of complex applications involving complex graphs, daily execution of batches and defect management.
• Experience in working in Unix Environment.
• Strong Analytical, Designing, Testing and Problem solving skills.
• Strong adherence to quality and standards.
• Accelerate and Enhance a Wide Range of Projects
• Informatica Data Services supports a full range of data integration projects and initiatives.
• Able to interact effectively with other members of Business Engineering, Quality Assurance, Usersand other teams involved with the SystemDevelopment Life cycle
• Expertise in preparing various documents related to projects such as High level design documents, low level design documents, Unit Test Cases, etc.
• Excellent Communication skills in interacting with various people of different levels of the project.
• Managed multiple tasks within Banking & Financial Service industries in a high - transaction processing environments with excellent analytical, business process, written and verbal communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchange.

BI Tools: BusinessObjectsXIR2/6.5(DesktopIntelligence,WEBI,Desinger),Cognos,Informatica Data Analyzer/Power Analyzer

Data Profiling Tools: Informatica Data Explorer(IDE)

RDBMS: Oracle 11i/10g/9.x/8.x, Teradata V2R5,DB2, Netezza4.6.8,SQL Server 2005,MS Access

Design / Application Tools: Erwin, Microsoft Visio (Visio Soft Diagram), TOAD, SQL Navigator, SQL Developer etc.Control-M, Tivoli

Languages/Scripting: SQL, PL/ SQL,UNIX Shell Scripting

Operating Systems: UNIX/LINUX, MS-DOS, Windows NT/2000/XP

Methodologies: Ralph Kimball and Bill Inmon methodologies

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Sr. Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator, Informatica, and RDBM systems like Oracle, DB2, Sybase and SQL Server.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used Data Migration tools
• The migration was implemented following the Kimball Methodology using MS SQL Server 2005, Analysis Services 2005, and Integration Services 2005
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Mapping & design of Planet press documents/forms from SIS (AS/400 system) DB files
• Created various Data Marts from Data Warehouse and generated reports using Cognos.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and imported data fromSales Force - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 9.1, Power Exchange 8.1.2, Informatica Repository Manager, Oracle10g/9i, Cognos8.xDB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,SQL

Confidential, NJ

Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 7.1.2, Erwin3.5, SQL Scripting, Sybase,UNIX Korn Shell Programming Oracle 10g/9i, DB/2, PL/SQL, Transact-SQL.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Prepared a detailed Technical Design Document after analyzing the Functional Specifications and the Architectural Diagram. The Technical Design Document captured all functional and technical requirements.
• Worked with different sources like Oracle, SQL Server, DB2 and flat files.
• Performed Data Cleansing before loading it on data warehouse.
• Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Wrote PL/SQL Procedures for data extractions, transformation and loading.
• Developed Workflows with various Tasks and Parameter files.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control).
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Reviewed with utilities i.e. Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Modified pre-existing scripts and used them to automate scheduling process using Autosys.
• Preparation of Test Cases for testing each of the interfaces which were used by the QA team.
• Extensively used Informatica Metadata Reporter to analyze and manage repository efficiently.
• Performed Code review to ensure that ETL development was done according to the company’s ETL
• standard and that ETL best practices were followed.
• Documentation of Technical specifications, business requirements and functional specifications for the Informatica mappings created for the building of the entire data warehouse.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2005, Oracle Designer, Teradata V2R4 / V2R5, Toad, PL/SQL, Linux, Erwin and Windows 2000 / XP.

Confidential, Seattle, WA

ETL Developer

Responsibilities:

• Major involvement in creating and tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in Work flow monitor
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator and Router Transformations.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Designed and developed Mappings with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator.
• Used Change Data Capture (CDC) to implement Incremental Data Extraction so that only the modified and new records will be extracted to the destination rather than full extraction
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Created Tasks and Workflows using Task Manager and Workflow Designer

Environment: Informatica Power Center, Work Flow Manager, Oracle 10g, Erwin, TOAD, XML, UNIX.