SUMMARY:

• Result - driven IT Professional with 9+ years of experience in the Business Analysis, Design, Data Modeling, Coding, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems.
• Strong expertise in migrating various Informatica sessions and mappings from one version to another.
• Well versed with Informatica 8.1, 8.6, 9.1, 9.5, 9.6 64 bit.
• Experience in working with all the transformations in Informatica and applying the logic with the requirement.
• Strong experience in using Informatica PowerCenter … Informatica Power Exchange 8.1 and extracting data from Db2, Oracle, MS SQL Server, MS Access and AS400.
• Extensive experience on Data Quality by creating checks to know the Quality of Data in AmeriCredit project.
• Sound knowledge on Informatica Data Quality concepts and IDQ tool.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Knowledge on reporting tool Business Objects.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and file formats like flat-files, CSV files, COBOL files and XML files.
• Sound knowledge of Oracle … MS SQL Server 2000, MS Access 2000, PL/SQL, SQL*Plus, DB2 8.0.
• Good knowledge of Data warehouse concepts and principles (Ralph Kimball / Inman), Star Schema, Snowflake, SCD.
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server, IBM DB2 and XML files and worked on integrating data from flat files like fixed width and delimited.
• Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization/ Denormalization strategies.
• Experience in database performance tuning.
• Good experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.6, 8.x, Informatica Master Data Management 9.5/9.1 B2B DX, Data stage(11.x,9.x), DT, Informatica IOD, IDQ(IDQ 8.6.1), IDE, Cognos, Pentaho, Data Mart, SAP HANA Studio, OLAP, OLTP

Databases: Oracle 10g/9i/8i/8.0/7.0, Sybase IQ 11.0/12.0,MS SQL Server 6.5/7.0/2000/2005, Netezza,Teradata5.0/6.0,DB2UDB,MSAccess7.0/ 97/2000.MYSQL,POSTGRESSQL,Teradata 14.0, TalenD

Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, TOAD, C, C++, UNIX Shell Scripting

Environment: Windows 200/ XP/ 98, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential,Greensboro, NC

Sr. Informatica, ETL Developer

• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Worked on converting technical specifications into Informatica Mappings.
• Loaded data from different source systems like Flat files, Excel, Oracle, .txt files.
• Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side.
• Worked on Informatica tuning at mapping and sessions level.
• Extensively used Informatica PowerCenter 8.6/9.5 and created mappings using transformations like SourceQualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator.
• Used NORMALIZER Transformation heavily to convert the data in flat file RDBMS structures.
• Used Mapplets, Parameters and Variables to facilitate the reusability of code.
• Worked on Pre and Post SQL queries on target.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Created scripts which are reviewed by DBA's and checked in SVN tool Tortoise.
• Created unit test cases and checked them in HP lifecycle management tool which will be accessed by QA team for testing.
• Performed many comparisons between source data and staging data through excel for the QA.
• Worked in Agile model projects.
• Worked on various UAT and PROD incidents raised by users and which require timely response for L3 support.
• Solved many production tickets as part of PRODUCTION L3 SUPPORT.
• Involved in Unit testing, User Acceptance testing, Stress Integration testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Implemented many technical JIRA's and released it to production with proper user sign offs.
• Documented the various development JIRA's I have worked on and created TDD (technical design document) incorporating the changes done.
• Responsible for Regression testing ETL jobs before test to production migration.
• Created scripts based on existing procedures according to the user requirements.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Troubleshoot the data and performance issues raised by user community, designed, developed and deployed the code to fix them.

Environment: Informatica PowerCenter 8.6/9.5/9.6, PL/SQL Developer, JIRA, Unix-Putty, Oracle, Tortoise, HP lifecycle management tool, SVN Commit Tool

Confidential,Scottsdale, AZ

Sr. Informatica, ETL Developer

• Created Model Repository, Profiling Warehouse Repository and Content Manager Database
• Create folders, grant user access to Informatica Repository
• Applied Informatica Patches to the Informatica servers
• Worked with Informatica Cloud to create Source /Target connections, monitor, and synchronize the data in salesforce.
• Participated in data governance processes, author data transformation scripts, perform data cleansing actions, and execute data integration/consolidation processes as part of the Unified Registration System data migration effort.
• Responsibilities also include providing feedback and refinement of the Enterprise Logical Data Model (ELDM), data mapping workbooks, and ETL load logic and selection criteria.
• Transformed and modernized legacy software systems through the re-engineering of business processes to meet futuristic customer demands.
• Data Migration activities include data profiling, data
• Worked with Informatica cloud for creating source and target objects, developed source to target mappings.
• Involved in analyzing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects.
• Involved in extracting, transforming and loading data Accounts, Contracts, Reservations, Owner interactions tables from various source systems to Salesforce.com and reverse data feed from Salesforce for CRM telesales.
• Act as liaison with business for troubleshooting: investigate, analyze, and solve integration problems and map business requirements, processes and objectives; develop necessary product modifications or coordinate with ARIBA and IT development team.
• Designed and implemented various Validation Rules with the ARIBA Support team that helped business in reducing the daily Integration failures.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expressions and Aggregator transformations.
• Developed Slowly Changing Dimension for Type 2 SCD
• Performed daily incremental load (CDC) all Vehicle sale, Customer update and Dealer records that are added since last run will be selected.
• Implemented Change Data Capture CDC where Last update date greater than or equal to the last successful workflow run time and less than current workflow run time from audit table.
• Used Mapplets for use in mappings thereby saving valuable design time and effort

Environment: Informatica PowerCenter 10.x/9.x, IDQ, Metadata Manager, Power Exchange, Oracle 11g and 10g, SQL, IBM AIX, UNIX Shell Scripts, Remedy, Control-M, Toad, MS Visual Source

Confidential,Charlotte, NC

Sr. ETL Developer

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Worked with different sources such as SQL, Flat files and XML sources.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Implemented two projects on SAP HANA.
• Involved in business and Architecture discussions.
• Worked closely with SAP Technical team on implementing the First Customer's project on HANA.
• Involved in installation of SAP HANA 1.0.17 in two environments.
• Involved in installation and configuration of SAP Business Objects Data Services 4.0.
• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica PowerCenter 9.6Designer.
• Worked on BI Modeling/Report Authoring using Cognos 8 Suite, Cognos ReportNet 1.1, and Cognos EP Series …
• Architecting and implementing enterprise BI solutions.
• Defining, designing, developing & optimizing ETL processes for enterprise data warehouse.
• Established and oversight of data governance, data standards and release policies.
• Worked on Dimensional Data Modeling creating New Models and updates of existing models
• Involved in Analysis by querying to tweak performance of code and output
• Worked with Business Objects team to migrate existing reports to update data models.
• Involved in design of double mile stoning of the data in all data marts, which help bank users to provide the data in different snapshots.
• Worked with BI team to remodel BI Portal where all the business objects report render data.
• Worked with Composite tool to provide different data services and web services to other development team.
• Worked on ETL workflows to update the new data marts with data from old data marts.
• Defined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Worked on reporting using Cognos 8.4 Report Studio.
• Developed Framework Manager models (Layers Architecture, security, IQDS - Sources of Transformer, Packages.

Environment: Informatica Power Center 9.6, 8.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, Netezza, XML, MS SQL, Oracle 10g, DB2, TOAD, HPSM, OBIEE, Windows 2000, Linux, and AIX UNIX

Confidential,Piscataway, NJ

ETL Developer, JNJ ASP - BI Application Support

• Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition participating in requirement gathering, Analyzed the requirements.
• Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues.
• Developed mappings using various transformations like Update strategy, Lookup, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Expression, SQL transformation.
• Worked with different sources such as Oracle, Flat files and XML sources.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs.
• Responsible for writing complex SQL queries in Informatica Mapping and developing stored procedures using PL/SQL.
• Development of work breakdown structures, charts, tables, graphs, major milestone calendars and diagrams to assist in analyzing problems and making recommendations.
• Worked closely with the DBA team for Production and Opps team to schedule the maintenance activities for better results in production.
• Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
• Responsible in fixing issues with complex mappings.
• ETL Design and preparing Technical specifications for the Informatica mappings.
• Design and implement the error handling process for the existing data warehouse.

Environment: Informatica Power Center 8.6 (IDQ, B2B (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, Oracle 10g, XML, MS SQL Server, DB2, TOAD, Cognos, Windows 2000, and Linux

Confidential,Detroit, MI

ETL Developer

• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Marketable Security & Derivative Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, Aggregator, Expression, SQL transformation, Transaction Control transformation.
• Worked with different sources such as Oracle, flat files and XML sources.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed Mappings for the Category, Specification, Code, Type areas.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Modifying the existing Informatica code to accomplish the change requests for Dimension, Fact & Aggregate Tables.
• Mappings were designed to the utmost performance by optimizing transformations logic.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.1, DB2, Oracle 9i, Windows 2000, and UNIX