SUMMARY

• Over 9 years of extensive experience in Design, Development, and Implementation of ETL processes using Informatica PowerCenter and development of standards and procedures using Informatica best practices.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Extensive experience in ETL of data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter (Repository Manager, Designer, Workflow manager, Workflow Monitor).
• Hands on experience in data warehousing techniques such as data cleansing, Surrogate key assignment, Slowly Changing Dimensions SCD TYPE 1, SCD TYPE 2 and Change Data Capture (CDC)
• Knowledge, understanding, and experience in Entity Relationship, Multidimensional - Star and Snowflake schema model, Conceptual, Logical, and Physical Data Modeling using ERwin and Power Designer.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Expertise in creating Transformations, Mapplets, and Mappings using Informatica Designer and Workflows, Worklets, and Tasks using Workflow Manager to move data from multiple sources into targets.
• Adept in Business Intelligence and Teradata. Demonstrated skills in dimensional data marts and end user reports.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008, Teradata 13/12/V2R5 and MS Access.
• Experience in working on Microsoft Business Intelligence - SSIS, SSAS and SSRS. Used SSAS to build Cubes by slicing and dicing data from the data warehouse.
• Experience in UNIX shell scripting to support the ETL process.
• Experience working with PL/SQL Procedures, Packages, Functions and Triggers.
• Worked with different data sources like Flat Files, Cobol Sources, Salesforce.com (SFDC) and relational sources like Teradata, Oracle and SQL Server.
• Expertise in doing performance tuning. Using pushdown optimization techniques to optimize transformations and improve performance.
• Good knowledge of Validation testing procedures and processes, Software Development Life Cycle (SDLC) and QA Life Cycles and Agile environment.
• Thorough knowledge of all facets of testing - Unit, Smoke, Functional, System Integration, White Box, Black Box, Regression, User Acceptance Testing, Load, Stress and Volume testing.
• Efficiently interacted with developers and product analysts regarding testing status and Defect Tracking.
• Excellent communication skills with keen analytical ability. A highly motivated professional with proven success in leading Data warehousing projects.

TECHNICAL SKILLS

Operating Systems: Windows XP/vista. UNIX, Linux.

ETL Tools: Informatica Power Center 8.6/9.1,9.5.1, SSIS

Databases: Oracle 8i/9i/10g/11i, DB2, DB2 UDB, MS-SQL Server 2000/2005/2008 , Sybase 10,Teradata,My SQL and MS-Access

Languages: C, C++, C#.Net, ASP .NET, UNIX Shell Scripting, PL/SQL, T-SQL

Reporting Tools: Siebel Analytics 7.3(OBIEE), Business Objects, SSRS

Tools: SSAS,TOAD, MS VISUAL STUDIO, MS VISIO, SQL *PLUS, SQL Loader

Modeling: ERWIN 4.1/4.0/3.5.2 , Power Designer 6.0, Oracle Designer 2000

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

ETL Informatica Developer

Responsibilities:

• Interacting with business users, business analysts and Solution Architects in analyzing business requirements and translating requirements into functional and technical design specification.
• Worked with Data Architects during design stages.
• Designed the Source to Target (Mapping document) mappings and involved in designing other documents as per company standards.
• Developed complex mappings using various transformations in Informatica.
• Used transformations such as Lookup (Connected/ Unconnected), Filter, Router, Joiner, Update Strategy, Aggregator, Sorter, Expression and Sequence Generator.
• Involved in unit testing and documentation of the ETL Process.
• Performance tuning of Informatica Mappings by optimizing the source, optimizing the target, optimizing the transformations and optimizing the sessions.
• Worked with DBA for partitioning and creating indexes on tables used in Source Qualifier queries to improve performance.
• Involved in performance tuning of Oracle Queries. Generation/ interpretation of explain plans and tuning SQL to improve performance.
• Support migration process of Informatica code.
• Used debugger to test the mappings and fixed the bugs.
• Developed ETL mappings from staging area to 12 different report tables.
• Created sessions and workflows to populate the report tables.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy.

Environment: Informatica 9.x, Oracle 11g, Flat files, Control-M Scheduler, Informatica DVO.

Confidential, Greensboro, NC

ETL Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Worked with lead Business analyst to identify the source systems.
• Used Talend Data profiler to do the data profiling.
• Worked with the Data Modeler during the designing of Logical and physical models.
• Worked with client team while designing requirements document.
• Performed Data cleansing and data scrubbing on the source systems.
• Implemented transformations on the source systems as per requirements and loaded them into a Landing zone.
• Extensively used ETL Tool Informatica to load data from Flat Files to landing tables in SQL server.
• Worked with the client to perform extensive validation of landing tables.
• Implemented Star schema for this Data Warehouse.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/9.5.1 to load the data from landing tables to Dimension tables.
• Implemented Slowly Changing Dimensions (SCD-2) for loading the dimension tables.
• Developed mappings to load the data into Fact Tables.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping
• Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy.
• Created events and tasks in the work flows using workflow manager.
• Created sessions and arranged them in various workflows in the workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process.
• Worked on SSAS to build cubes for reporting purpose.

Environment: Informatica - PowerCenter 9.1.0/9.5.1 , SQL Server 2008 R2, Talend Data Profiler, SQL Server Business Intelligence Development Studio.

Confidential, Richmond Virginia

Informatica Developer

Responsibilities:

• Studied the process, subject areas and data flow for current datawarehouse and analyzed the data flow Re-Point to the Staging area.
• Accumulated the details of all 10 processes, integrated the modules and designed single data flow diagram that includes all processes for IHUB as well as DSH.
• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of load processes and Data transformation processes.
• Created Technical Specification documents using MSVisio and maintained Technical specification documents throughout development lifecycle.
• Extensively used ETL processes to load data from source systems SQL Server into target systems in different database, by applying business logic on transformation mapping for inserting and updating records when loaded.
• Worked with mappings that moved data by the Slowly Changing Dimensions (SCD-2). Hence worked on movement of the new and updated data.
• Used Expression, Filter, Joiner, Normalizer, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Loaded data into Teradata database as per the specifications.
• Wrote Teradata BTEQ scripts to extract data from base tables to intermediate working database.
• Involved in loading of data from flat files using complex MLOAD scripts and FASTLOAD scripts.
• Created mappings in Informatica 9.x to pull data from Teradata and load into Oracle Data warehouse.
• Written PL/SQL procedures to perform data base activities like index creation, dropping and updating database tables.
• Built mappings that now move data through staging area DSH instead of the earlier IHUB.
• Developed SQL scripts as per the business requirements.
• Changed the metadata framework, maintained framework documents for all 10 processes. Created new process IDs and related parameters. Moved in the metadata pertaining to DSH by executing the SQL generator.
• Changed and validated session properties and connections such that they now point the data to DSH.
• Created folders for all processes in the HMC portal and uploaded the configuration file and ini file.
• Performed Unit testing for all 10 processes and maintained the unit test logs.
• Used tidal scheduler to insert the process jobs and implemented them successfully after checking for all errors.
• Created artifacts list to migrated changes to SIT (System Integration Testing) and then to production. Artifacts list consists of changes to database objects, Informatica objects, flat files, sandbox scripts, frame work, job scheduler and Meta data migration scripts.
• Worked with SIT team to create test data for SIT purpose and supported them in migration to production.
• Provided all the documentation for DDM project by uploading them into MS Visual Source Safe and maintained them by creating appropriate folders and versions.
• Provided primary on-call production support for all enterprise Informatica environments.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 8.6.1, MS SQL Server 2008, MS Visual Source Safe, Tidal Scheduler, Windows XP, Teradata 13, MS Visio.

Confidential, Denver, Colorado

Informatica Developer

Responsibilities:

• Interacted with various business team members (JAD sessions) to gather the requirements and documented requirements.
• Developed and maintained the technical design documents of ETL process.
• Performed data analysis and worked with System owners to resolve source data issues.
• Designed and built ETL processes to extract and load high volume of data from different source systems such as Mainframe, RDBMS, SFDC, Web Services, XML, and Flat Files.
• Having a thorough understanding of these current and potential requirements and helped the Data Architect and Project Manager to design a flexible and scalable solution that meets the needs of the business.
• Designed logical and physical data models for CIS and PMS data marts to be fed from legacy systems using Erwin r7.1.
• Developed reusable transformations, mapplets and shortcut to prevent redundancy.
• Created Deployment Group and performed objects migration.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Effectively balance and prioritize multiple projects concurrently
• Developed SQL queries, T-SQL, and PL/SQL programs for complex data requests.
• Wrote shell scripts to perform Repository backup, logs cleanup, on regular basis and automated the daily load process across the systems.
• Created and executed unit tests on all solutions, worked with Data analysts and QA team to ensure solutions are well tested, production ready and well documented.
• Provided primary on-call production support for all enterprise Informatica environments.
• Trained internal employees on Informatica and got them to the pace of development.

Environment: Informatica PowerCenter7.1/8.6, PowerExchange, SalesForce.com, Relational Junction for SalesForce, DB2, Oracle10g, SQLServer2005, TSQL, Web Services, Mainframe, Cobol, UC4, PL/SQL, Erwin7.1, Unix Shell Script, QualityCenter9.2, WSDL, and XML.

Confidential

Junior Data warehouse/ Informatica Developer

Responsibilities:

• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of load processes and Data transformation processes.
• Created Technical Specification documents using MS Visio and maintained Technical specification documents throughout development lifecycle.
• Extensively used ETL processes to load data from various source systems such as PeopleSoft, Oracle, DB2, COBOL and Flat Files into target systems Oracle, Siebel, DB2 and Flat files, by applying business logic on transformation mapping for inserting and updating records when loaded.
• Extensively used the Designer to import source and target definitions into the repository and to build mappings.
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows, tasks and sessions.
• Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Developed SQL/Perl scripts for the daily flat file extraction.
• Experience in using FirstLogic to standardized names, addresses, and deduping process.
• Applied Performance Tuning logic at mapping and session level.
• Developed PL/SQL stored Procedures and Functions to enhance backend functionality.
• Wrote Shell scripts to schedule the jobs.
• Provided primary on-call production support for all enterprise Informatica environments.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter, PowerExchange, PowerChannel, Oracle, Sunopsis Data Integrator,DB2, Peoplesoft 8.8, Siebel, MS Access, FirstLogic, PL/SQL,, Shell Script, Perl, Cobol, Toad7.2, QMF8.1, Windows2000, Mainframe, MS Visio