SUMMARY

• Enthusiastic and highly skilled with over 7 years of software development experience in the field of Data Warehousing using the Informatica ETL tool, possessing superior analytical skills and the ability to meet deadlines. Enjoy sharing technical expertise and coordinating projects with team members.
• Professional skills and competencies include the following:
• Knowledge of working in all phases of the Data Warehouse Development Life Cycle
• Comprehensive knowledge of Dimensional Data Modeling like Star Schema, Snowflake Schemas, Facts and Dimension Tables, Physical and Logical Data Models and knowledge in designing tools like Erwin.
• Strong ETL experience using Informatica Power Center with various versions 9.x/8.x/7.x. Client tools - Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Server tools - Informatica Server, Repository Server manager and Power Mart
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11g/10g/9i, SQL Server 2008/2005, IBM DB2 .
• Hands on experience with managing Slowly Changing Dimensions (SCD) such as Type I, II, III and Cleansing, Profiling, Conversion, Aggregation, and Performance Optimization and setting up Change Data Capture (CDC) mechanisms.
• Strong Experience in creating Transformations such as Aggregation, Expression, Update Strategy, Lookup, Joiner, Rank, Router and Source Qualifier Transformations etc. in the Informatica Designer.
• Experience in Requirement Gathering and Analysis, System Design and Development phases of Software Development Life Cycle (SDLC), Agile and waterfall methodologies.
• Demonstrated proficiency in improving re-usability, automation of data loads, performance tuning in Informatica by identifying bottlenecks in Source, Targets or on Database level and de-bugging/rectification of data load errors.
• Development strategies for Extraction, Transformation and Loading (ETL) of data from various sources into Data Marts and Data Warehouses using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Strong experience in designing and developing complex mappings to extract data from diverse sources including Flat files, RDBMS tables, legacy system files, XML files, Applications Sources.
• Experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Very good understanding of issues involved with Performance Tuning of mappings, transformations, sources and targets.
• Designed and developed various tools involving Extraction Transformation Loading (ETL), ROLAP and MOLAP concepts.
• Good knowledge and understanding of scheduling tool like AutoSys, Control M.
• Experience in UNIX Shell Scripting.
• Ability to work independently as well as in a team, fun-filled and challenging environment.
• Maintain outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Active team player with excellent communication, organization and Interpersonal skills, self-motivated and quick learner.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.x/8.x/7.x,RepositoryManager, Designer,Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, mappings, re-usable transformations, Mapplets, Shortcuts, sessions, and workflows, OLAP, OLTP, ETL, Autosys, Data Analysis, Data Cleansing, Data Profiling.

Data Modeling: Dimensional Modeling, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Erwin

Databases: Oracle 11g/10g/9i, SQL, PL/SQL, MS SQL Server, DB2.

Programming languages: SQL, PL/SQL, T-SQL.

Operating Systems: UNIX, LINUX, Windows.

Utilities and Tools: SQL Loader, TOAD 9.5, SQL Developer.

Others: Microsoft Word, Microsoft Excel

PROFESSIONAL EXPERIENCE

Sr. ETL Informatica Developer

Responsibilities:

• Interacted with source system owners to get a strong understanding of how each source system works.
• Involved in transforming the Functional Specification, Business requirement document and Business metrics into High level designs, Test Case documents and providing end-to-end approach.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively Used Informatica Power Exchange to load data from OLTP Source systems and databases Oracle and Flat files.
• Involved in Implementation of Change Data Capture (CDC's) frequently from the source systems using the Power Exchange Utility.
• Extensively worked on real time batch processing with CDC logic.
• Actively involved in Database designs, Identifying the Fact tables and Type 2 & 3 slowly changing dimensional tables for the warehouse.
• Used Informatica Client Tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Extensively worked on transformations like Filter, Aggregator, Expression, Router, connected and unconnected Lookup, Update Strategy, Rank, SQL, XML and Joiner.
• Mapplets and Reusable transformations were extensively used wherever required.
• Good knowledge in IDQ Informatica Data Quality, Data Quality Analysis perspective provides subset of data, attributes details which gives what is wrong and what is being used.
• IDQ is used for capability to generate various levels of reports/graphs based on data
• Identified Process Bottlenecks and optimized the code in different areas for better performance involving various performance tuning techniques.
• Involved in performance tuning for efficient loading of data from various sources.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Performed Unit Creating test cases User Acceptance End to End testing of different Subject Areas.
• Customer Involved in developing test plans and test cases based on high-level and detailed designs
• Extensively involved with end user training for long term support.
• Logical database design, physical database design, data modeling with Erwin.

Environment: Informatica Power Center 9.5.1 (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 11g,Power Exchange, PL/SQL, SQL Developer, Testing, UNIX, XML, Windows, MS Office 2013.

Confidential, Durham, NC

Sr.ETL Informatica Developer

Responsibilities:

• Used Informatica Manager for managing Informatica repository define custom routines & transforms, import and export items between different Informatica systems or exchange metadata with other data warehousing tools
• Dealt extensively with the data from Oracle 11g, SQL Server.
• Used Informatica Monitor and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components
• Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Datamarts.
• Configured File for Parallel extender as per number of processors available to process the data by using Informatica Manager.
• Used Informatica Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data warehouse
• Generating of unique keys for composite attributes while loading the data into Data warehouse.
• Develop and debug complex SQL's, UNIX scripts and stored procedures to resolve production issues and in the processing of new source feeds.
• Performed Web LogicServer administration tasks such as installing, configuring, monitoring and performance tuning on Linux Environment.
• Configured, maintained, deployed and trouble shoot of Web Logicon multiple platforms.
• Extensively used various Transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Analyzed the session logs, bad files and error tables for Troubleshooting mappings and sessions
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Provides training in creation of test cases for Manual and Automated testing.
• Used Informatica Administrator to assign privileges to users or user groups to control purging of Repository and Informatica client applications or jobs they run, move, and rename projects
• Using ERWIN 4.5 as leading data modeling tool for Logical and physical data model
• Developed postscripts and pre scripts for downloading and uploading data as before and after job routines using shell and SQL.
• Used Constraint Based loading & target load ordering to load data into the tables with maintaining the PK-FK relation in the same mapping.
• Involved in the creation of Oracle Tables, Views, Materialized views and PL/SQL stored procedures and functions.
• Used Debugger to create break points, run the mapping till the break points, find out the cause/error and modify the data and debug the mapping in the transformations.
• Expertise in Performance Tuning by identifying the Bottlenecks at sources, targets, databases, Power Center transformations and sessions using techniques like Explain plan, Oracle hints, partitioning, re-designing the mappings.
• Developed UNIX/Linux Shell scripts for the command tasks in the workflow and Stored Procedures for partitions of the tables.

Environment: Informatica Power Center 9.1.1/8.6.1 (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager),Web Logic Server Control M, Oracle 11g, PL/SQL, SQL Developer, IBM DB2, UNIX, Linux, Windows, MS Office.

Confidential, Los Angeles, CA

ETL Informatica Developer

Responsibilities:

• Responsible for preparing the technical specifications from the business requirements.
• Analyzed the requirements and work out with the solution. Develop and maintain the detailed projectdocumentation.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the Mappings between sources (external files and databases) to operational staging targets.
• Used Informatica Power Center to create Mappings, Sessions and Workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Utilized InformaticaIDQto complete initialdata profiling and matching/removing duplicate data.
• Designed and developed mappings using Expression, Filter, Router, Aggregator, Joiner, Normalizer, Rank, Sequence Generator, Update Strategy, Union, etc.
• Involved in the process of creating the data model using Erwin.
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Used Debugger to create break points, run the mapping till the break points, intermittently modify the data and debug the mapping in the transformations.
• Setup and configure Power Center domain, grid and services.
• Expertise in Performance Tuning by identifying the Bottlenecks at sources, targets, databases, Power Center transformations and sessions using techniques like Explain plan, Oracle hints, partitioning, using indexes, re-designing the mappings.
• Extracted data from XML files and loaded into the oracle tables using Informatica.
• Managed production issues and delivered all assignments/projects within specified time lines.
• Developed UNIX shell scripts for regular maintenance and production support to load the history and incremental data into warehouse.

Environment: Informatica Power Center 8.6.1, Oracle 10g, AutoSys, SQL Developer, UNIX, Erwin, Windows, XML.

Confidential, Cary, NC

ETL Analyst/Developer

Responsibilities:

• Used ETL tool Power Center 8.x for extracting data from Oracle, SQL Server, and DB2, which is collected from upstream databases and loaded into target Oracle database.
• Performed code reviews and handled change requests.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy Transformations
• Performance tuning of mappings, sessions and workflow.
• Implemented performance issues on mappings to increase the efficiency of loading the data from various metrics to the target database.
• Wrote SQL, PL/SQL, T-SQL, stored procedures for implementing business rules and transformations.
• Used Informatica Workflow Manager and server to read data from sources to write to target databases, manage sessions/tasks and to monitor server ETL Implemented for Oracle, SQL Server
• Tuned performance of Informatica sessions by changing data cache size, buffer length, target based commit interval and SQL overrides.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Created multiple unit test cases for the purpose of unit testing the various mappings.
• Populated error tables as part of the ETL process for the records that failed the migration.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing
• Created sessions and workflows to run with the logic embedded in the mapping using workflow manager.

Environment: Informatica Power center 8.1.1, Informatica Power Connect, Informatica Power Exchange, Oracle 10g, PL/SQL, SQL,T-SQL, Oracle, SQL Loader, MS SQL Server, Mainframes, Windows, UNIX Shell Scripting .

Confidential

ETL Informatica Developer

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Designed and developed Informatica Mappings, Workflows to load the data into Oracle DB, SQL server.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign User Privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations. .
• Performingmanualtesting by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Involved in Performance Tuning of Sessions and Mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Wrote Test Cases for ETL to compare Source and Target database systems.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, SQL Plus, Testing, MS Access, Windows XP.