SUMMARY:

• 8+ years of experience on Data stage(11.x,9.x), Informatica Powercenter, Informatica PowerExchange/ Power Connect in all phases of Analysis, Administration, Design, Development, Implementation and support of Data warehousing applications using Informatica Power Center 9.x & 8.x, SQL, PL/SQL, MS SQL, Teradata, DB2, Oracle, and Unix.
• Full life - cycle project delivery experience from product definition to implementation including: requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis, quality assurance, and release into a production environment.
• Expertise knowledge in domains like Telecom, Finance, Health Care, Pharma, Manufacture Systems.
• Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition participating in requirement gathering, Analysed the requirements.
• Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e. Star Schema and Snowflake Schema.
• Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session and Pre/Post commands
• Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
• Knowledge in Data Analyzer tools like data stage,Informatica PowerExchange (PowerConnect), Informatica B2B, Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE).
• Experience in Informatica change management like migration from Informatica 7.x to Informatica 8.x and 8.x to 9.x and Version control to track the modification in Informatica Power Center.
• Experience in pulling data from ERP systems i.e. SAP from different modules like HR, SD, MM through Informatica R3 power connect connection establishment and extracted Data sources for Attribute & Text tables for SD, MM, FI & CO modules.
• Well acquainted with session partitioning and Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings. Troubleshooting and problem solving applications with Informatica Debugger.
• Excellent working ethics to meet deadlines in fast-paced environment and function under high-pressures with extremely short deadlines. Collaborate on multi-disciplinary (e.g. business and technical) teams.
• Solid Organizational skill and ability to work without supervision to achieve project goals.

TECHNICAL SKILLS:

ETL: Data stage(11.x,9.x),Informatica PowerCenter 9.x, 8.x, B2B DX, DT, Informatica IOD, IDQ(IDQ 8.6.1), IDE,cognos, Data Mart, OLAP, OLTP

Databases: Oracle 11g/ 10g/ 9i, MS SQL Server, DB2, Teradata and MS Access

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

PROFESSIONAL EXPERIENCE:

Confidential, Detroit

Senior ETL Developer

Responsibilities:

• Worked with different sources such as SQL, Flat files and XML sources.
• Created and Imported/Exported various Sources, Targets, and Transformations using Data Stage(11.x,9.x) Designer.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of data stage Sessions, Batches and the Target Data.
• ETL Design and preparing Technical specifications for the Data stage mappings.
• Performance tuning of targets, sources, mappings and sessions using various components like parameter file, variables and partitioning concepts.
• Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files, etc.
• Responsible in fixing issues with complex mappings.
• Design and implement the error handling process for the existing data warehouse.
• Worked closely with the DBA team for production and apps team to schedule the maintenance activities for better results in production.
• Experience in Create, backup, restore for Data stage Repositories.
• Setup and maintain ETL administration best practices and procedures.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitors and tunes ETL repository and system for performance improvements
• Ability to perform root cause analysis, performance monitoring and application related issues
• Write Repository Queries in support of developments and Production statistics
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Data stage, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
• Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
• Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
• Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Data stage Sessions/ Batches.

Environment: Data stage 11.x,9.x, (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, XML, MS SQL, Oracle 10g, DB2, TOAD, HPSM, OBIEE, Windows 2000, Linux, and AIX UNIX.

Confidential, Philadelphia, PA

Senior ETL Developer

Responsibilities:

• 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.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail
• Co-ordination with client side IT Team and business users.
• Creating the Technical design specifications based on Client functional specs.
• Design data mappings to extract Data from SAP using ABAP, IDOC, BAPI’s & set up Business Content mappings i.e. Listener, Send Request, Processing & Cleanup to load into EWD for upstream Cognos Reporting System.
• Identified, activated, created Processing Mappings for BCI’s and extracted Data sources for Attribute & Text tables for SD, MM, FI & CO modules.
• Outage Handling (Escalation Procedure, Running metadata queries and procedures, checking database, creating outage log)
• Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues.
• Involved in migration of Informatica objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
• Regular monitoring of the informatica server environment on AIX UNIX Server.
• Experience in Applying Informatica Latest Hot fixes/Patches.
• Developed IDQ work benches by using Data sources, Operational Components and Data Sinks.
• Developed the IDQ Plans for Profile Demo data, Pre-Standardization Scorecard, Standardize Generic Data and Standardize Name, Address Data.
• 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.
• Performance tuning of targets, sources, mappings and sessions using various components like parameter file, variables and partitioning concepts.
• Worked closely with the DBA team for production and apps team to schedule the maintenance activities for better results in production.
• Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
• Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files, etc.
• 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 9.x, 8.x (IOD, B2B, IDQ, IDA (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation Developer) SQL, PL/SQL, XML, MS SQL, Oracle 10g, DB2, TOAD, HPSM, OBIEE, Windows 2000, Linux, and AIX UNIX.

Confidential, NJ

BI Application Support, Senior ETL Developer

Responsibilities:

• 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.
• Ensures proper configuration of the Power Center Domain components.
• Experience in Grids, nodes, Repository services and Integration services.
• Ensures proper application of the licensing files.
• Involved in Informatica server and Server Administration such as Installing, Creating and configuring Repository, Folders, Users and User Groups and ODBC in Informatica Power Center 8.6.
• Outage Handling (Escalation Procedure, Running metadata queries and procedures, checking database, creating outage log)
• Involved in migration of Informatica objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
• Regular monitoring of the informatica server environment on AIX UNIX Server.
• Experience in Applying Informatica Latest Hot fixes/Patches.
• Developed IDQ work benches by using Data sources, Operational Components and Data Sinks.
• Developed the IDQ Plans for Profile Demo data, Pre-Standardization Scorecard, Standardize Generic Data and Standardize Name, Address Data.
• Generated Data profile (SWOT) Reports by using IDE.
• 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

ETL Developer

Responsibilities:

• 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.

Confidential

ETL Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Created ER Diagram representation including existing source systems by using Ervin Tool.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Experience in Create, backup, restore for Informatica Repositories.
• Setup and maintain ETL administration best practices and procedures.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitors and tunes ETL repository and system for performance improvements
• Ability to perform root cause analysis, performance monitoring and application related issues
• Handle user access/ security role requests for new developers and projects
• Write Repository Queries in support of developments and Production statistics
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
• Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
• Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
• Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/ Batches.

Environment: Informatica Power Center 8/ 7.1, Oracle 9i, TOAD, SQL, PL/SQL, and UNIX.