PROFESSIONAL SUMMARY:

• Almost 9+ years of Experience in Designing, Development and Implementation of Data Warehouses & Data marts with Informatica Power Center 9.x/8.x/7.x as an ETL tool
• Expertise in Dimensional and Relational Physical & logical data modeling using Erwin and ER/Studio.
• Extensive experience in implementing CDC using Informatica Power Exchange 8.x/9.x.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Extensively worked on Informatica tools Repository manager, Designer, Workflow manager, Workflow monitor.
• Expertise in Data warehousing, Data migration
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Experience in debugging mappings Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / DE normalization strategies.
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like DB2, Oracle, Flat files, and XML files, XML, and SQL server targets.
• Experience with Informatica Data Exchange and Data transformation Center
• 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
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/9.0, 8.5/8.1.2/8.1.1/7.1.1, Repository Manager, Designer, Workflow manager, Work flow Monitor, SourceAnalyzer, Powe Analyzaer, Informatica PowerMart, Warehouse Designer, TransformationDeveloper.

Databases: Oracle 11g/10g/9i/8i/, Toad,MS SQL server 2008/2005,DB2,MS Access, MySQL, SQL,PLSQL.

Data Modeling: Logical data Modeling, Physical Modeling, Dimensional Data Modeling, Relational Modeling, Star Schema, Snow Flake schema, Fact Table, Dimension Table, Normalization, De - Normalization, Erwin 4.0/3.5.5/ER/Studio.

Programming Skills: Shell Scripting, K-Shell, C-Shell, SQL, PL/SQL

Scheduling Tools: Tidal,Control-M

Others: Microsoft word, Microsoft Excel, Outlook,XML, Agile Universe, ScrumGathering.

Health Care tools: Facets, Health Rules

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Responsible for Requirements gathering, Analysis and End User Meetings.
• Responsible for converting Functional Requirements into Technical specifications and updating them in Analytix.
• Extensive experience in writing functional specifications, translating business requirements to technical Specifications, created/maintained/modified data base design document with detailed description of logical Entities and physical tables.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting Requirements are met for the business.
• Worked with active transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, Java and Update Strategy transformations.
• Extensively worked with various passive transformations like Expression, Sequence Generator, Sorter, and Lookup transformations (connected and Unconnected).
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, NVL, TO DATE, Decode, Substr and IIF functions in Expression Transformation.
• Depends on the requirement by using the lookup tables to perform search and replace functions within an Item or category and for items, categories, locations, import or export files, and lookup tables.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer Join In the Joiner transformation.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Responsible for governance of testing methods and the maintenance and support of the ETL environment.
• Reviewed and tested Informatica ETL code and wrote test plans.
• Responsible for month end data consistency checks and fixes using shell scripts and stored Procedures.
• Also responsible for tuning stored procedures.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental
• Loading Strategy using the concepts of Change Data Capture (CDC).
• Responsible for 24/7 Informatica production support.
• Assist in creating new standards and procedures related to end user and internal interface development.

Environment: Informatica Power Center 9.1(Repository Manager,Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), PL\SQL, DB2, UNIX

Confidential, NY

Sr.ETL Informatica Developer

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 9.
• Designed the ETL processes using Informatica to load data from SQL Server, Flat Files, and XML Files And Excel files to target Oracle database.
• Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, UnionExpression and Update Transformations also implementing CDC using Informatica Power Exchange 8.x/9.x.
• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Router, Lookup, Sequence Generator, Stored Procedure, Expression, Filter, Rank and XML Transformations.
• Extensively used Change data capture concept in Informatica as well as in the Oracle Database 10g to capture the changes to the data mart. Change data capture enabled us to reduce the time Taken to load the data into the data mart by allowing only the changed data.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to the Relational database.
• Written SQL overrides in source Qualifier according to business requirements.
• Implemented variables and parameters in the mappings.
• Created workflows and worklets for designed mappings.
• Generated UNIX shell scripts for automating daily load processes.
• Scheduled and unscheduled workflows and used UNIX command tasks to automate the entire Process of fetching the source file from a different path and FTP it onto the server.
• Generated completion messages and status reports using workflow manager.
• Involved in writing ETL specifications and unit test plans for the mappings.
• Performed Developer testing, Functional testing, Unit testing for the Informatica mappings.
• Redesigned some of the mappings in the system to meet new functionality.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process.
• Involved in writing procedures, functions in PL/SQL.
• Customized WSDLs as per the Business and project requirements.
• Involved in maintaining and granting the privileges for read and write operations.
• Worked on PL/SQL, Functions and Procedures
• Train, mentor and work with offshore development teams.
• Migrated mappings from Dev to Test and Test to Production.

Environment: Informatica Power Center 9.5/9.1, Oracle 10g/11g, DB2, SQL Server, Erwin, Windows XP, UNIX.

Confidential, MI

ETL Informatica Developer, Data quality project

Responsibilities:

• Analyze the Data Quality issue and find the root cause for the problem and designing the solution for the problem with the Business peoples approval .Presenting the cases which are analyzed as tickets for the developers to develop the new requests and working as one among them.
• Analysis of the downstream flow on any changes to the Enterprise Data warehouse.
• Used to work with the Business Analysts involving in analyzing the issues in the given ticket and finding the proper solution to fix the issue. Involved in doing the Data model changes and other changes in the Transformation logic in the existing Mappings according to the Business requirements for the Incremental Fixes
• Worked extensively with Informatica tools like Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer.
• Created various Transformations like Expression, Joiner, Lookups, Filters, Routers, and Update Strategy etc.
• Involved in the Development of different mappings and tuned for better performance.
• Extensively used ETL to load data from multiple sources as flat files into as target database.
• Code walkthrough and Review of documents which are prepared by other team members.
• Prepared UTP (Unit Test Plan) and Test with different unit test conditions, fixing of defects if any are found during System Testing.
• Migration of Informatica maps extensively involved in migration from Dev to SIT and UAT to Production environment.
• Worked on preparing a full-fledged documents called BIDR
• Worked in developing the Downstream Data marts like CDM, IDM and BDR which are used for the Reporting. Data is extracted from the EDW and loaded in to these Data marts according to the Business requirements.
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager
• Worked extensively on different types of transformations like source qualifier, SQL transformation (Both Query and Script modes), Normalize, expression, filter, aggregator, rank, update strategy, lookup (connected & unconnected lookups), stored procedure, sequence generator and joiner. Used Telnet and WINSCP tool to create and view the parameter files and other source files in Unix in DEV, Testing and Production Environments
• Used UNIX Shell Scripting to invoke Sessions in the workflow manager.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.

Environment: Informatica Power Center 8.1/8.5/8.6,DB2 Power exchange 8.1, TOAD, PL/SQL, Oracle 11i/10g/9i, Flat Files, Business objects.

Confidential, MO

ETL Informatica Developer

Responsibilities:

• Extensively worked in full Software development life cycle.
• Worked closely with business users on gathering the requirements and prepared Technical Design and Mapping documents.
• Created Folders and deployment groups using Repository manager.
• Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Created source and Target Definitions, Reusable transformations, mapplets and worklets.
• Created Mappings and extensively used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator and Sequence Generator, Web services Consumer.
• Developed Source to Staging and Staging to Dimension mappings.
• Developed Source to Staging and Staging to Fact mappings
• Used Workflow Manager to create sessions, worklets workflows.
• Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Manage all technical aspects of the ETL mapping process with other Sprint team members.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data
• Created mappings to load Slowly Changing Dimension tables based on the amount of historical dimension data.
• Involved in migration of mappings and sessions from development repository to test and production repository.
• Designed and developed UNIX shell scripts to handle error handling and automatic email generation.
• Involved in production support and done knowledge transfer to team members.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved.

Environment: Informatica Power Center 8.6.1,9.1, Informatica Data Quality 9.1 MS SQL server 2005, Erwin, Windows XP, UNIX.

Confidential, New York, NY

ETL Developer

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.
• Analyzed the business requirement document and created functional requirement document mapping all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Extensively involved in Data Extraction from Mainframe source (VSAM), Oracle using Power Exchange when there was change in the source data sets.
• Worked on SQL optimization. Identified bottlenecks and performance tuned the Informatica mappings/sessions.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Developed Informatica mappings, sessions and workflows for all mappings.
• Design and implement business objects universe, create reports, and implement reporting interface with Business Objects Tool Suite (Reporter, Designer, Supervisor, Web, Info View, and BCA) with Migration Experience.
• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Involved in developing test plans and test scripts to test the data based on the business requirements. Used Agile methodology named SCRUM for all the work performed.

Environment: Informatica Power Center 8.1/8.5/8.6, DB2 Power exchange 8.1, Erwin, TOAD, PL/SQL, Oracle 11i/10g/9i, Linux, XML, Unix Maestro, Flat Files, Business objects.

Confidential

Informatica Developer

Responsibilities:

• Translated business requirements into data warehouse design.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin
• Extracted Erwin physical models into repository manager using Informatica Power plug.
• Used Star Schema approach for designing of Data Warehouse.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracle,
• SQL Server, MS-Access and Loaded data into Oracle using Informatica.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations,
• Mapplets using Informatica Designer tool which includes Source Analyzer, Warehouse Designer,
• Transformation Developer, Mapping Designer and Mapplet Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, and sequence generator, joiner Transformation.
• Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.

Environment: Informatica Power Center 6.2/7.1, Cognos Impromptu 6.0, Impromptu web reports (IWR 6.0), UNIX, IIS 4.0, PL/SQL, Oracle 8.0/8i and Win NT.