SUMMARY

• 8+years of diverse experience in the field of Information Technology with emphasis on Data warehousing and specifically InformaticaPowerCenter.
• Varied experience in Analysis, Design, Development of various business applications in different platforms InformaticaPowerCenter 9.5.1/9.1.0/8.5.1/8.1.1, Oracle 11g/10g/9i, SQL Server 2012/2008/2005, Teradata v13/12.
• Worked on various Source files like Flat files, XML files and COBOL files.
• Experience in Application Design, Data Extraction, Data Acquisition, Data Conversion, Development, Implementations and Testing of Data warehousing and Database business systems.
• Extracted data from multiple operational sources and loading into Staging Area, Data Warehouse and Data Marts using CDC using PowerExchange.
• Experience in interacting with Business users in analyzing the Business process requirements and transforming them into documenting, designing, and rolling out the deliverables.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Good working knowledge with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly growing target mappings, SCD (Type1/Type2/Type3) dimension mappings.
• Experience in Data Conversion of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files.
• Good understanding of Project Life Cycle and gathering requirements for ETL Development.
• Experience in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using InformaticaPowerCenter.
• Experience working on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Expression, Aggregator, Joiner, Update Strategy and etc.
• Experience on Workflow Manager Tools - Task Developer, Workflows &Worklet Designer
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessionsand scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Experience in Push-Down Optimization/Performance Tuning Informatica mappings.
• Strong knowledge in using SQL * loader, materialized views, Export and import utilities.
• Good Experience on Managing, Scheduling, and Monitoring of Informatica workflows.
• Worked with Stored Procedures, Views, Triggers, Cursors, and Indexesusing PL/SQL.
• Good experience with TLOAD, MLOAD, FASTLOAD, TPT, FASTEXPORT and BTEQ utilities of Teradata for faster loading and to improve the performance.
• Used Batch scripts, Shell scripts, SQL procedures for pre and post session management.
• Excellent communication skills, team player, ability to work individually and in a team.
• Worked as a part of a production support team and provided 24/7 support.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5.1/9.1.0/8.6.1/8.5/8.1. (Power Center), Power Exchange, Informatica Data Quality.

BI Tool: IBM Cognos 10.1.1., Business Objects.

Databases: Oracle 11g/10g/9i, SQL Server 2012/2008/2012, Netezza, andTeradata.

Interfaces: TOAD 11.5/10.1, SQL*Loader, MS SQL Server Management Studio.

Scheduling Tools: Autosys, Control -M

Modeling Tools: ERwin 9.5.2/7.2.3, MS Visio, TOAD Data Modeler.

Languages: PL/SQL, C, C++, Java, SQL, HTML, XML.

Environment: s: Windows 2000\NT\XP\7, UNIX, Linux.

Concepts: RDBMS, Data Warehousing, ETL.

Testing Tools: Rational Clear Quest, Application Lifecycle Management (ALM)

PROFESSIONAL EXPERIENCE

Confidential, Chattanooga, TN

Informatica Developer

Responsibilities:

• Analyze the Impacts of the upgraded Source Systems on the existing Interfaces and Cognos based Applications.
• Interact with the Business Analysts and System Architects for understanding the impacts on downstream Interfaces and Applications.
• Worked Informatica Power Center tools like Source Analyzer, Mapping Designer, Mapplet and transformations.
• Facilitated meetings with Business users to explain the impacts of the Source System upgrades and gathered requirements for any enhancements needed for the existing Interface and Cognos applications.
• AnalyzedMaterialized Views, which are basis for the Cognos cubes to find any discrepancies from the previous versions.
• Coordinate with the downstream application teams to make sure the enhancement work is in line with the source systems.
• Enhance the existing ETL to accommodate the upgraded changes and making sure it runs smoothly without affecting the overall process.
• Configuring the command tasks, session tasks and Worklets to accommodate the new changes.
• Tuning the existing mappings to avoid any source target and transformation bottlenecks.
• Making sure the Targets (Relational, Flat files, XML) are generated as per the user requirements and able to pick them from the Serverfor their processing.
• Responsible for unit testing the all the ETL code in DEV and migration of the code to upper UAT (Business Testing) and Production.
• Test the Cognos reports for functionality and the data set and also for specific scenarios provided by the Business.
• Document ETL design, Unit test results for the Informatica code and validated result set before moving to the upper environments.
• Responsible for documenting the Unit test cases with different testing scenarios to meet the business rules implemented in the ETL mappings.
• Provide post production support for the Interfaces and the Cognos Applications as an ongoing process and work on any CRs.
• Evaluate data validation discrepancies to find the root cause and fix any ETL issues causing the discrepancies.

Environment: InformaticaPowerCenter 9.5.1,Informatica Scheduler, Oracle 11g/10g,TOAD, UNIX Shell Script, SharePoint, HPALM,Cognos 10.1.1, ERwin 9.5.2.

Confidential, Auburn Hills, MI

Informatica Developer

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.
• Responsible for the timely and quality delivery of the ETL code and all related documents for Confidential .
• Collected Business Analysis and Requirements by working with the business end users.
• Designed ETL Detailed Design document, which is a guideline to ETL Coding.
• Passed higher-level model/design into Informatica ETL code.
• Involved in designing an error handling strategy for data validation, error reporting.
• Experience in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for the Application.
• Populated data into staging tables from flat files, XML sources, Cobol Copybooks and Relational Sources and applied business logic on transformation mapping for inserting and updating records.
• Used Informatica Power Center to Create Mappings, Mapplets, Workflows, Worklets, Sessions and Tasks.
• Worked with DTD’s (document type definition), which are the source definitions for the XML.
• Involved in optimizing very large data loads.
• Using Informatica Designer designed Mappings that populated the Data into the Target Star Schema on Oracle 10g Instance.
• Conducted SQL testing for DB sources for Insert and Update timestamps, Counts, Data definitions, Control, and Error logic for Facts and Reference tables.
• Involved in Performance Tuning of the Mappings, SQL statements, Query optimization, and Explain Plan utilities for Optimum Performance and used Informatica Debugger.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Applied appropriate field level validations like date validations, Applying Default values for cleansing the data.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Prepared Unit Test Plans and Performed Negative testing, positive testing and field to field data validations.
• Log, track and solve the issues after moving the code to QA and Production.
• Helped the production support team in solving complex technical issues.
• Implemented the Slowly Changing Dimension strategy for the Warehouse.

Environment: Informatica Power Center 9.1.0, Oracle 10g,Toad, PL/SQL, UNIX Shell Script, Business Objects, ClearCase, ERwin 7.3, Sun Solaris 2.7.

Confidential, Woonsocet, RI

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to gather and analyze the Business Requirements.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Worked on Dimension/Fact tables to implement the business rules and get required results.
• Used Informatica designer for developing various mappings.
• Designed and developed ETL Mappings using Informatica to extract data from various sources like Teradata, Oracle and to load the data into the target database.
• Imported SAS dataset as a source qualifier and loaded in the target.
• Created reusable transformations in transformation developer/ Mapplets in Mapplet designer.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions, Union, Normalizer, Sequence generator and Aggregator transformations to pipeline the data to Database.
• Used Informatica Power Center to Create Mappings, Mapplets, Workflows, Worklets, Sessions and Tasks.
• Created Sessions, Workflows, Link Tasks and Command Tasks using Workflow Manager and monitored the workflows/sessions using Workflow Monitor.
• Worked with events such as Timer, Event Wait, Event Rise, Control and Decision.
• Used debugger to test mapping and fix the bugs.
• Extracted data from various sources like SQL server, Oracle, Teradata and relational databases.
• Integrated workflow and created Autosys jobs for scheduling.
• Involved in migration of the mappings, Sessions and other Objects from Development and to Production environment.
• Rational Clear case is used to Controlling versions of all files & Folders (Check-out, Check-in).
• Defect Tracking and reports are done by Rational Clear Quest.

Environment: Informatica 9.1.1, Oracle 10g, Flat files, UNIX shell scripting, Autosys, Oracle SQL Developer, Rational Clear case, Rational Clear Quest.

Confidential, New York

Informatica Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Understood the Business point of view to implement coding using Informatica power center designer.
• Migrated historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer.
• Developed mappings to extract data from various source systems like SQL Server, Flat files, XML and load into Data warehouse.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.

Environment: Informatica Power Center 9.1.0, Business Objects, Windows XP, SQL Server 2008, ERwin 7.3, Cognos 8.4.

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Involved in designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
• Designed the procedures for getting the data from many source systems to Data Warehouse.
• Developed mappings using Mapplets& various sources involving flat files, XML files and Relational tables.
• Extensively used ETL to load Flat files, XML files, Oracle as sources and Oracle, Flat files as targets.
• Worked extensively with complex mappings using expressions, aggregators, filters, joiners and lookups.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Involved in writing procedures, functions in PL/SQL.
• Designed and developed UNIX Shell scripts to report job failure alerts.
• Worked with Data Quality group to identify and research data quality issues.
• Coding, Debugging and sorting the time-to-time technical problems.
• Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• ScheduledInformatica Jobs throughAutosysschedulingtools.
• Involved in designing the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) in Oracle as per business requirements using ERWIN.
• Worked with NZLOAD, NZSQL utilities of Netezza for faster loading and to improve the performance.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Supporting daily loads and work with business users to handle rejected data.
• Used shell scripts to pre-process data in UNIX.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.

Environment: Informatica Power Center 9.1, Power Exchange, Oracle 11g, Autosys, Oracle SQL developer, Netezza, Flat Files, ERWIN, UNIX shell script.

Confidential, Memphis, TN

Informatica Developer

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
• Worked on Informatica8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in design and development of complex ETL mappings.
• Performed Unit testing of the mappings developed & also created Low Level Designs for the mappings.
• Implemented partitioning and bulk loads for loading large volume of data..
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Performance tuning by session partitions, dynamic cache memory, and index cache.
• DevelopedInformaticaSCD type-I, Type-II mappings Extensively used almost all of the transformations ofInformaticaincluding complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Created UNIX Shell scripts to automate the process.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows)
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts.
• Played a key role in all the testing phases and responsible for production support as well. Involved in development of the Code and executed Unit Test Cases.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: InformaticaPower Center 8.6.1/8.1.1, Oracle 10g, Flat Files, ERWIN, UNIX scripting, Autosys.

Confidential

Software Developer

Responsibilities:

• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed Mappletsfor faster development, standardization and reusability purposes.
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server and Flat files and load to Oracle database as per business requirements.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Performed unit testing to validate mappings and populate the database.
• Monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Worked with QA Team and provided production support by monitoring the processes.
• Documented the process for further maintenance and production support.
• Used Autosys to schedule the jobs.

Environment: Informatica Power Center 8.1, Erwin, SQL Server, Oracle 10g, UNIX Shell Scripting.