SUMMARY

• Over 9+ years’ Experience with Informatica 9.1x/8.6x/7.x/6.1 (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager).
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Modeling.
• Extensively worked with different data sources non - relational databases such as Flat files, XML files, and other relational sources such as Oracle, Teradata, Sql Server, DB2, and SAP R/3.
• Extensively worked with the files in HIPAA format and have good knowledge with serializers and parsers.
• Well adept in planning, building, and managing successful large-scale Data Warehouse and decision support systems.
• Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Informatica Power Center.
• Extensively worked in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Expertise in creating mappings, mapplets and reusable Transformations using Informatica Designer.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Good knowledge in tuning the performance of SQL queries and ETL process.
• Worked on UNIX-shell Scripting for Pre-Session, Post-Sessions tasks and also automated the scripts using a scheduling tool.
• Hands on experience in creating Indexes and partitioning tables for performance.
• Significant experience in Dimensional and Relational Data Modeling and Business Intelligence experience in Star Schema/Snowflake modeling, FACT & Dimensions tables, Cubes, Dash Boards, Physical & logical data modeling using ERWIN.
• Significant Experience in PL/SQL, Procedures/Functions, Triggers and Packages.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Familiar with Data modeling and worked with data modeling tool Erwin.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Languages: C/C++, HTML, XML, SQL, T-SQL, PL/SQL, Unix Shell Script, PERL

ETL: Informatica 9.1x/8.6x/7.x/6.x(Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Exchange, Power Connect, Power Exchange,B2B DTS 8.6/9.1), Informatica Cloud Services

Databases: Oracle 8i/9i/10g/11g, Sql Server 2008/2005, Teradata V2R6.2, Sybase 11.5, Mainframe DB2, SAP-R/3.

OLAP: Business objects XIR3/XIR2, BI Publisher, XML Publisher

Operating Systems: Windows 2000/ NT/ XP/ Vista/98/ 95, LINUX, UNIX, DOS, Windows 2003 server.

Tools: SalesForce.com, SQL Loader, SQL*Plus, TOAD, SQL Developer, Erwin

Reporting Tools: Microsoft Reporting Services, Crystal Reports 9/10.

Scheduling tools: UC4 and Tidal

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. ETL Developer

Responsibilities:

• Analyzed the Source and Target data and designed the Source to Target Data Map-ping document.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from SQL Server 2012 to Target system Sales Force and vice versa.
• Created mappings and loaded data from SQL Server 2012 to Target system Sales Force and vice versa using Informatica Cloud Services.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Java transformation.
• Work with support team to define methods for and potentially implement solutions for performance measuring and monitoring of all data movement technologies.
• Designed and developed Data Profiling in Informatica Designer to profile the Source data to meet business requirements.
• Created Data Profiles in Profile Manager using Auto Profile and Custom Profile options to validated documented business rules.
• Implemented performance tuning logic on Targets, sources, mappings and sessions to provide maximum efficiency and performance.
• Created deployment groups in Informatica to handle code migrations from DEV, QA and Prod.
• Developed Unit tests and separate User Acceptance test cases (UAT) to validate data against test scenarios.
• Scheduled Informatica jobs using Autosys job scheduler.

Environment: Informatica Power Center 9.5, Informatica Cloud Services, Oracle 11g, SQL Server 2008, Autosys, Toad, SAP Business Objects, SalesForce.com

Confidential

Sr. Informatica Developer

Responsibilities:

• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizer transformations.
• Developing several complex mappings in Informatica a variety of Power Center transformations and Mapping Parameters.
• Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment.
• Perform technical reviews of code and test plans created by team members.
• Participate in deployment, system testing, UAT.
• Engage in peer reviews during design, coding and testing.
• Ensure adherence to quality processes.
• Provide leadership and guidance to project team to ensure that all aspects of ETL design and implementation align with The Company's reference model.
• Set strategy and oversee design and development of EDW staging areas and target tables.
• Address and resolve technical design issues as they are appropriately escalated.
• Prepare implementation plans when moving a code to production.
• Perform system testing and monitoring.
• Optimize ETL design and tools to gain efficiency and functionality.
• Work with support team to define methods for and potentially implement solutions for.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g, SQL Server 2005, Autosys, SQL, T-SQL, PL/SQL.

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Extensive use of B2B Data Transformation for handling vendor data, where it is in EDI, Unstructured data and Complex structured data (XML Schemas).
• Extensively worked with structured and unstructured data.
• Worked with HIPAA 5010 for reduces risk and provides flexibility and complete bidirectional transaction crosswalk transactions.
• Involved in analysis, requirement gathering, and documenting functional and technical specifications.
• Involved in the preparation of the mapping document for 5010 by identifying the minor changes from 4010.
• Involved in the installation of B2B plug-ins in the machine.
• Designed the inbound mappings to load data from HIPAA, 270, 271 and 271U files into Database to healthcare industry standards.
• Created the outbound mappings to generate HIPAA, 271 and 270 files from the data in the data bases.
• Upgraded Informatica power center 8.1 to version 8.6 on servers.
• Hands-On experience in developing Transformations like Joiner, Aggregate, Expression, Lookup (connected and un connected), Filter, Union, Stored Procedures, Router, XML generator and parser, unstructured Data Transformation etc. using best practices.
• Configure the session so that power center server sends the e-mail when the session fails.
• Extensive use of flat files as sources and targets depending on the inbound and outbound processes.
• Deal with data files with lot of data (almost up to 6 million members in one file).
• Involved in the performance tuning of the maps to reduce the runtime for the big files.
• Extensively worked in the performance tuning of the programs, PL/SQL Procedures and processes.
• Cleansing data using Trillium, RTRIM and LTRIM.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Run the mappings using Tidal 3rd party tool and implemented the concurrent running of the workflow for different files at the same time.
• Fixed the minor issues in the parser and serializers (built in java codes).
• Build XML parser and serializer transformations with the xsd files.
• Involved in the resolution of the issues in the built in java codes along with the informatica people through GoToMeeting.
• Passed the parameters to work flow from the tool Tidal directly to run the map.

Environment: Informatica Power Center 9.1/8.6, Data Transformation Studio, Oracle 10g, SQL Server 2005, Tidal, SQL, T-SQL, PL/SQL.

Confidential, Shoreview, MN

Sr. ETL Developer

Responsibilities:

• Involved closely with the team implementing logical and physical data modeling with STAR schema techniques using Erwin in Data warehouse as well as in Data Mart.
• Involved in the Administration and maintenance of the Informatica Repository.
• Extracted data from flat files, SQL Server 05, XML Files data using Informatica Power Connect and performed massive data cleansing applying all the business rules prior to loading them into Oracle staging tables.
• Extensively used Informatica to load data from MS SQL Server, SAP- R/3 and DB2, into the target Oracle.
• Implemented data load from different type of source like Flat File, Relational Database, Oracle Logs using Informatica Power Exchange.
• Performed Data Profiling and created User Defined Functions (UDF) /process to handle null fields with default values for string, date and number.
• Created packages using SSIS as ETL tools to transfer and integration of data from databases.
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
• Created Data Breakpoints & Error Breakpoints for debugging the mappings using Debugger.
• Implemented Slowly Change Dimension Type I & II to capture history and created process flow chart for insert/update using effective end date while loading data into the data marts.
• Developed shell scripts, PL/SQL scripts, T-SQL scripts, Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Actions.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Performed Bulk Load of large volume of data by creating pre- and post-load scripts to drop indexes and key constraints before session and rebuild those indexes and key constraints after the session completes.
• Developed BI Publisher reports as per the User requirements.
• Familiar with batch scheduling using Autosys.

Environment: Informatica Power Center 8.1/8.5/8.6, Informatica Power Exchange 8.1, Informatica Power Connect, Oracle 10g, Teradata, DB2, SSIS, SQL Server 05, Autosys, Toad 9.0.1, Erwin 4.2, Unix, Siebel CRM, SQL Developer, SQL, T-SQL, PL/SQL.

Confidential, Morris Plains, NJ

Sr.Informatica ETL Developer

Responsibilities:

• Designed and Developed mappings needed for enhancement of project.
• Worked with Informatica Power center 8.6 Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Exported and Imported mappings between different Informatica folders and also Repositories.
• Responsible for Administration of Informatica Environment. Created users and groups, configured profiles and privileges.
• Informatica Debugger is used to test the mappings and fixed bugs.
• Provided Production Support for IDS DSS and created Unix Shell Scripts to delete data that is older than 3 years from fact tables.
• Created Stored Procedures and SSIS (DTS) packages for the ETL process.
• Developed UNIX shell scripts to get data from external systems flat files to EDW stage area, and to schedule various workflows to load the data into target system.
• Familiar with Data Warehouse Architecture, design methodologies and Best practices.
• Experience with server log files, editing UNIX scripts, FTP files and checking space on server.
• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Scheduled Informatica sessions and workflows using Informatica Scheduler.
• Performance and fine tuning of Informatica mappings.
• Loaded data into Datamarts on a daily basis.
• Created new repositories and new folders within the repositories using Repository Manager.

Environment: Informatica Power Center 8.1, Oracle 9i Windows Server 2003, PL/SQL, SQL*Plus, XML, PL/SQL Developer, SSIS, Teradata, DB2, Erwin 4.1, AppWorx 5.1.1, Windows NT/2000.

Confidential

Informatica/SQL Developer

Responsibilities:

• Defined Source and Targets in Informatica for ETL and created source to target mappings.
• Created reusable Transformations for modifying data before loading into target tables.
• Created mapplets in the Informatica Designer which are generalized and useful to any number of mappings for ETL jobs.
• Created Transformations using the SQL script to modify the data before loading into tables.
• Used Informatica Power center to load the data into data warehouse.
• Created and used mapping parameters, mapping variables using Informatica mapping designer to simplify the mappings.
• Used the Business objects features Slice and Dice and Drill Down for multi dimensional analysis.
• Inserted Objects, Conditions, classes, subclasses and user objects according to client’s requirement.

Environment: Windows NT, Oracle 8i, Informatica Power mart 5.1, Informatica power center 5.1, Business Objects 5.x, Business Objects SDK.