SUMMARY:

• 6+years ofIT experience on Data Warehouse, Data Analysis, Application Development and Business Intelligence with ETL tools Informatica Power Center.
• Strong technical exposure with good degree of competence in business systems such as Financial, Banking, Insurance, Healthcare, Pharmaceutical, and Telecommunications.
• Responsible for Production Support to resolve the ongoing issues and troubleshoot the problems.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling, Erwin 7.2/4.x, Microsoft Visio 2003.
• Good flexibility in the design of strategies for ETL mechanism usingInformatica Power center that involves development of data warehouses, OLAP.
• Involved inActivities like Code Migration, Creating and Restoring Repository Backups
• Experience in Installation, Configuration and administration ofInformatica Power Center 8.x (server and Client) on windows 2003 server.
• Extensively worked on Power Center client (Repository, Designer, workflow manager and workflow Monitor) to extract, transform and load data.
• Designed mappings usingInformatica Union, Lookup (Connected, Unconnected, Persistence, Dynamic and Static), Unstructured Data Object (B2B), Update strategy, expression, Transaction Control to create dynamic file names, Aggregator, Joiner, Expression, Router, XML, and Normalizer Transformations.
• Developed common logic using Reusable transformations and mapplets.
• Developed and tested complex mappings for Slowly Changing Dimensions Type I, II (Flag and time stamp) and Change Data Capture based on requirements using Power Exchange 8x/9.01 HF3.
• Extensively usedInformatica to load data into ODS, Data Warehouse on integration of various sources that involve relational databases - Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000, DB2 UDB 8.1, flat files, XLS and XML system.
• Efficient in troubleshooting bottlenecks, performance tuning of mappings, Debugging, System Testing and Optimization of ETL.
• Experience in Task Automation of Pre-Session and Post-Session UNIX scripts (Korn) using Control-M schedulers and Performed data migration from development to QA, Test Process, Move to PROD and maintain ETL process in coordination with supervisor, team members and users.
• Proficient in parameterizing DB connections, file paths, error handling and interacted with Informatica server from command mode using PMCMD command.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, coming up with data load strategies, designing and developing various mappings, unit testing, integration testing, regression testing and UAT in development.
• An Energetic, flexible, well organized, self-motivated fast learner with minimal supervision, good listener, independent and team-oriented, process focused professional in various team sizes performing cross functional roles in a fun filled, challenging environment.
• Excellent analytical, problem solving, communication and interpersonal skills, with an ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Power Center 9.5/9.0/8.6/7. x/6.x andInformatica Server, ETL, Power Exchange 8.0,Power Mart4.7.2/5.1 andPower Connect.

Data Modeling: Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Cardinality, ER Diagrams, ERWIN 7/4.0/3.0, MS VISIO 2000.

Databases: Teradata V2R12/V2R6/V2R5, Oracle 11g/10g/9i, MS SQL server 2000/2005/2008, DB2 UDB 8.1, MS Access

Programming: SQL, PL/SQL, Unix & Shell Scripting, SQL Tuning/Optimization, C, C++

Tools: TOAD, SSIS/DTS, SQL *Plus, SQL* LOADER, Clear View, Excel, Word, PowerPoint, Autosys, Control-M, ERWin 3.5.2/4.0, IBM Tivoli Workload

Operating System: Sun Solaris, Linux, MS-DOS, Windows 7/95/98/NT/2000/2003/XP/Vista/Server.

PROFESSIONAL EXPERIENCE:

Confidential - Austin, TX

Informatica Developer

Responsibilities:

• Involved in Requirement Gathering, Design & Development, Testing and Documentation.
• Worked with Business Analyst and Architect to analyze data and document Functional aspects.
• Participated in scrum meetings to discuss the status of the everyday development.
• Designed and created Mappings, Sessions and Workflows usingInformatica Power Center Toolsto load the data from Sources such as DB2/400, Oracle, XML, EDI and Flat Files into various targets.
• Developer the ETL processes to handle complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Union etc.
• Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
• Used Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation etc for better performance.
• Defined and used Mapping Parameters and Parameter files to provide values dynamically at session run time.
• Defined and used Mapping Variables to capture changed data from the source tables.
• Created sessions to use pre & post session SQL commands to drop & create indexes on tables for better performance.
• Used Event wait Task, Control Task, Email Tasks, Command Tasks and Link conditions in workflows.
• Write PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition, rename the tables etc.
• Used Oracle SQL Loader utility to Bulk Load data from flat files into database tables.
• Created & modified Unix Shell scripts.
• Provided data loads for QA testing and worked on resolving the defects.
• PerformedInformatica code migrations.
• Created Technical Design documents, Test Cases documents and Application work books.

Environment: Informatica Power Center 9.5.1/9.0.1, SQL Server 2008 express,Oracle SQL Developer, Flat files, XML Files, MS Visio, Toad 7.0, Windows 2000, Putty, Power Exchange 9.0.1., 9.5.1

Confidential - Dublin, Ohio

Informatica Developer

Responsibilities:

• Prepared ETL Architecture/Process flow Diagrams based on requirements and adheres to ETL Architectural guideline.
• Identify, recommend and implement ETL process and architecture improvements.
• Detailed analysis of the user’s requirements, Comprehensive data analysis to fulfill the user requirement. Interact with BSAs and Data modeler to understand the data mapping between source-systems and data-model.
• During thisproject tenure,involved inArchitecture Design,development,Integration Testing,QA, UAT andproduction support phases.
• Prepareworkestimates and track the development of the ETL phases.
• Created ETL Process Flow/Architecture diagrams and prepared ETL Technical Specification document.
• Developed mappings inInformatica to extract the data fromdata file sent by Data sources, like ACXIOM, ENVISION, Confidential, ORI and Metadata, which transforms data as per business requirement using variousInformatica transformations and loaded into Data marts for report generation.
• Data Validations,Error Handlingand Reconciliation methodologies have been included as part ofInformatica code as per business need and for business notification.
• End-to-End Integration testingsupport forETL-process from source-system to target data mart.
• Provide UAT and post-production support.
• Leadbuild phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
• Optimizing / tuning mappings for better performance and efficiency.Source team sends data file of 100 million sometimes, hence, performance ofInformatica code has been crucial, hence, included many performance techniques for efficient run. Major performance improvements have been achieved using Push down Optimization (PDO) techniques, Teradata Parallel Transporter (TPT) Loaders and Dynamic partitioning techniques.
• Job scheduling usingControl-M. This is a new learning experience, involved in creation and configuration of Control-M jobs for scheduled and automaticInformatica job stream runs.

Environment: ETL Tool & Databases,Informatica Power Center 9.1, Teradata Platform, Windows, UNIXScheduling ToolControl-M

Confidential - Dallas, TX

ETLInformatica Developer

Responsibilities:

• Responsible for gathering suit of business requirements, prepare source to target mapping specifications and transformation rules.
• Responsible for creating and maintaining ETL processes using Oracle PL/SQL to populate an Oracle database.
• Worked with a team in a very demanding, fast-paced, and dynamic health care environment.
• Created source to target mapping specification document.
• Involved in system study, analyze the requirements by meeting the client and designing the system.
• Developed mappings/reusable objects/ transformation mapplets by using mapping designer, transformation developer and mapplet designer inInformatica Power Center.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact summary) data identified by dimensions using Informatica ETL tool.
• Used the update strategy transformation to update the target dimension tables.
• Created connected and unconnected lookup transformation to look up the data from the source and target tables.
• Support reduction of data redundancy and fragmentation, elimination of unnecessary movement of data, and improve data quality.
• Used PL/SQL and UNIX shell scripts for scheduling the sessions inInformatica.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings on the development server.
• Created test cases and completed unit, integration and system tests for data warehouse.
• Participate and facilitate functional and technical designs of systems to ensure sound decisions are being made with current and future business and strategies and opportunities.
• Creates guidelines and standards in terms of ETL environment.

Environment: Informatica Power Center/Connect 9.0, Oracle 11g, PL/SQL, Unix Shell Scripts, Unix Server, SQL Developer, FileZilla, Putty, MS Excel 2010.

Confidential - Costa Mesa, CA

Informatica Developer

Responsibilities:

• Analyzing Requirement, WritingTest Cases, WritingTest Scenariosand Scripts for the components.
• Worked in all the phases of a Software Development Project - starting from Requirement Gathering, Development, Testing and Implementation andPost Implementation activities.
• Extracted, scrubbed and transformed data fromFixed-Width Flat Files, Delimited Flat Files,XML Filesand loadedstagingtablesusingInformatica.
• Designed and developed the data transformations for source system data extraction, data staging, movement and aggregation, information and analytics delivery,data qualityhandling,system testing, performance tuning.
• CreatedInformatica Mappings to implement business rules while loading data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Worked onPipelinepartitioning ofInformatica sessions to load large chunk of data.
• Created various batch Scripts forschedulingvariousdata cleansingscripts and loading process.
• Extensively worked onMappingVariables, Mapping Parameters andSession Parameters.
• CreatedData BreakpointsandError Breakpointsfor debugging the mappings usingDebuggerWizard.
• Created SeveralStored Proceduresto update several tables and insert audit tables as part of the process.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Created Unit test plan and architecture Review documents.
• Preparation of Integration Test andUser Acceptance TestDocumentation.
• Involved in unit testing.
• Interaction with various other teams for setting up of servers and databases.
• Customer Presentation and approval.
• Developed shell scripts for running batch jobs and scheduling them.

Environment: Informatica Power Center 8.6, Windows XP,UNIX, Oracle 10g, SQL Developer, TOAD