SUMMARY:

• 8+ years of experience in datawarehouse using Informatica power center 9.6.1/9.5.1 /9.1/8.6/8.1, ETL OLAP and OLTP
• Experience in dealing with various Data sources like Oracle 11/10g/9i, Oracle PL/SQL, T - SQL, SQL Server 2010/2008, Teradata, Ms-Access, MS - Excel and Flat files, web services, XML, COBOL / VSAM files etc.
• Dimensional Data Modeling experience on Data modeling, ERwin 4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Ralph Kimball Approach, Star Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling, Star and Snowflake Schemas.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Experince in creating Mappings and Mapplets using various connected and unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator, SQL, Java, Transaction control and upated strategy transformations.
• Proficient in using Informatica Designer, workflow manager, workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Worked exclusively in implementing the types of slowly changing dimensions (SCDs) - Type I and II in different mappings as per the requirements.
• Experience working on performance tuning in Informatica using Pipeline partitioning and Push down optimization.
• Experience in preparing the ETL Design Documents like High Level and low level Design documents. Involved in the Unit testing, integration testing, System testing and UAT using Quality Center.
• More than a year of experience on Teradata platform using Teradata utilities such as Teradata sql assistant, load utilities such as Teradata parallel transponder, FastLoad, FastExport.
• Experience in using Informatica Power Exchange Navigator to extract data from Mainframe sources.
• Good knowledge on data quality measurement using IDQ and IDE.
• Good exposure to development, testing, debugging, implementation, documentation, end user and production support.
• Good experience writing Technical specification documents, ETL Design documents, Test plans and Deployment plans.
• Aptitude for analyzing, identifying problems and coming with out of the box solutions.
• Ability to achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.
• Excellent communication, interpersonal and analytical skills.
• Self-motivated, quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS:

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

Databases: Oracle (11g/10g/9i/8i), SQL Server (2008, 2012), DB2, Teradata.

Reporting Tools: OBIEE 11.7.0, Hyperion and Business Objects.

Scheduling Tools: Control M, TWS (Tivoli workflow scheduler), CA7.

Programming Languages: UNIX, C++, Java, Visual Basic .NET, SQL, PL/SQL, HTML, XML, and Unix Shell/Perl bash Scripting.

Development Tools: Oracle Developer Suite, SQL Developer, Teradata SQL Assistant, SQL plus, Toad, DB Visualizer.

Operating System: UNIX, Linux, Sun OS, AIX, Windows 2000/2003/2008/ XP/7.

Office Applications: MS-Office 2000/2003/2007, Visio.

Other Utilities: SQL *Loader, BTEQ, FastLoad, Export, MultiLoad, Teradata SQL Assistant, Notepad ++, HP Quality center, Beyond compare etc.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. Informatica/ETL Developer

Responsibilities:

• Interacts with business users to understand the requirements.
• Create technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.
• Expertise in creatingdatabases, users, tables, triggers,views, stored procedures, functions, Packages, joins and hash indexes in relational databases.
• Design document for mapping, which include details of field-to-field mapping between sources and target, Business (Transformation) Rules, Parameters, Processing flow and details of sessions, pre-dependencies, post-dependencies, and exception handling methodologies.
• Involved in ETL architecture meetings and any new tool implementations.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Used complex Informatica mappings to extract data from the source system to the Staging DB.
• Converted complex Oracle PL/SQL Packages to Informatica Mapping/Mapplets.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Used special transformations like Java transformation, Transaction control transformations, and SQL transformations.
• Involved in reading data from XML, Flat files, COBOL/VSAM files.
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Created shell/Perl scripts to run daily jobs and extract the files from remote location for data loads.
• Implemented various performance tuning activities related to Informatica, Databases and UNIX for complex loads. Resolved several ETL performances issues there by cutting the run time from several hours to minutes utilizing pipeline partitioning and push down optimization (PDO) features of informatica.
• Improved Informatica process creating index, used cache files and session level partitions in Informatica.
• Designed and developed complex mappings to load the Historical and Weekly data from different source systems.
• Worked closely on the major defects in QA and UAT Environment for Integration and User acceptance testing.
• Created Data Flow Diagrams using Microsoft Visio to depict the flow of the Mappings.
• Worked extensively on slowly changing dimensions (Type I and Type II).
• Coordinate with project management team and ensure accuracy on all deliverables and prepare summary reports.

Environment: Informatica Power Center 9.6.1/9.5.1, Power exchange 9.5.1, Oracle 11g, Teradata Client 13.11,UNIX Shell scripting, OBIEE 11.7.0, CA7 Scheduler, XML Files, Harvest version control, Endevor,Mainframe

Confidential, Chicago, IL

Sr. Informatica/ETL Developer

Responsibilities:

• Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts.
• Wrote and reviewed documents like Functional Specifications, Data Mapping Sheets and Technical Specification Documents.
• Prepared documents like Deployment Doc, Estimation Reports, Development tracking report and weekly status Reports .
• Established standard code migration process.
• Extracted data from a wide variety of sources like flat files, XML files, Relational Database (Oracle) and from the legacy mainframe systems by using Informatica Power Exchange.
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Stored procedure, XML and Sequence generator transformations.
• Worked extensively on look up transformation involving dynamic look up cache/persistent cache.
• Created User defined functions to reuse the logic in different mappings.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Creation of sessions and workflows according to the data load in to different systems.
• Data investigation in the analysis of incoming data from the various source systems, documenting the data anomalies and generating Data Quality reports.
• Involved in different phases of testing like Unit, Functional, Integration and System testing.
• Creation of Review documents for specification document and test cases.
• Performance tuning of targets, sources, mappings and sessions.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer.
• Worked and responsible for running the CA7 Jobs.

Environment: Informatica Power Center 9.1.1, Informatica Power Exchange, DB2, Oracle 11g/10g, Linux, Hyperion, Control-M, SQL Developer, Notepad ++, Beyond Compare, Perl Scripting, XML Files, COBOL Files.

Confidential, Newark, NJ

ETL Developer

Responsibilities:

• Requirement gathering from the Business Unit and end users of the proposed product
• Design and creation of detailed Technical Mapping document with information on implementation of business logic
• Used ERWIN to design Physical and Logical Data Modeling
• Design of ETL mappings for the CDC (change data capture)
• Worked with various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Worked with slowly changing dimension Type1, Type2.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Guided and Mentored the ETL team in Informatica.

  Worked with various tasks like Session, E-Mail, Workflows and Command.

• Worked with the Informatica Scheduler for scheduling the delta loads and master loads.
• Worked extensively with aggregate functions like Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Worked with various re-usable tasks, workflows, mapplets, and re-usable transformations.
• Employed various Lookup Caches like Static, Dynamic, Persistent, and Shared Caches.
• Used session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails.
• Responsible for the Promotion of Mappings, Workflows and other Informatica objects like sources, targets, and transformation between environments like DEV, INT, UAT and PRD.
• Extensively used Informatica Scheduler to test the scheduling in the Development Environment.
• Worked with the third party for Automation of job processing using Autosys scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager.
• Extensively worked with Versioning of objects in Informatica with Check in and Check out options.
• Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files.

Environment: Informatica Power Center 8.6/8.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Erwin 4.1, Business Objects, Oracle 9i, SQL Server 2008, UNIX, Windows XP

Confidential, Simsbury, CT

ETL Developer

Responsibilities:

• Study and analyze mapping document, the required source tables, data types, required transformations based on Business requirements and Technical specifications.
• Using Informatica Power Center, extracting data from SQL Server, XML files and Flat Files.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Used SQL over rides in Source Qualifier and Lookups to improve mapping performance.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Created Materialized views for summary tables for better query performance.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Providing extensive changes as a part of User acceptance testing and deployment of mappings at client place.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica 8.6.1, ORACLE, TOAD, SQL SERVER 2008, Control-M, Quality Center.