SUMMARY

• Over 8 years of IT experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.x/ 8.x/7.x.
• Experience in data warehousing and business intelligence using various ETL tools Informatica, and Business Objects.
• Extensive knowledge with Relational & dimensional data modeling, star schema/snowflakes schema, Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator and Update Strategy from varied transformation logics in Informatica.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc.
• Experience in working withbuilding DW and OLTP systems and applying ETL
• Extensively worked with PL/SQL, performance tuning of Oracle using Tkprof, SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
• Experience in working withbusiness analysts to study and understandrequirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creatingHigh Level Design and Detailed Designin the Design phase.
• Expertise in Business Model development withDimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in Data warehouse using Informatica and ORACLE OLTP Database management 8i/9i databases. Made substantial contributions in simplifying the development and maintenance of ETL by creating re - usable objects for source, target, and Transformation objects.
• Support of Data Warehousing and Data Integration Solutions using Informatica Power center.
• Extensively worked on theETL mappings, analysis and documentation ofOLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts, Java& Sybase.
• Experienced in working with tools like TOAD,SQL Server Management studio and SQL plus for development and customization
• Well versed inOLTP Data Modeling, Data warehousing concepts.
• Strong knowledge ofEntity-Relationship concept, Facts and dimensions tables, slowly changing dimensionsandDimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources likeOracle, DB2, Sybase, SQL server and MS access andnon-relational sources likeflat filesinto staging area.
• Exposure in overall SDLC including requirement gathering, data modeling, development, testing, debugging, deployment, documentation, production support.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) andMappings usingInformatica Designerand processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Experience in creatingReusable Tasks(Sessions, Command, Email) andNon-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Work let, Control).
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced inUNIXwork environment,file transfers,job schedulingand error handling.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Worked onPerformance Tuning,identifyingandresolving performance bottlenecksin various levels like sources, targets, mappings and sessions.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Created Tables, Views, Macros in Teradata
• Used various Teradata Index techniques to improve the query performance.
• Extensive functional and technical exposure. Experience working on high-visibility projects
• Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.1/8.x/7.X/6.X (Repository Administration Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Informatica DVO 9.5, Informatica MDM Multi-domain

Data Modeling: ERWIN 4.0.1 (Logical Modeling, Physical Modeling), Dimensional Modeling (Star Schema, Snow-Flake), ER Diagrams (Entities, Attributes, Cardinality),Microsoft Visio.

Databases: Oracle 11g/10g/9i/8i, ParAccel, MS SQL Server 2005/2000, MS Access, MS Excel, Sybase .

DB Tools: Oracle SQL developer, Toad, SQL* Loader, Rapid SQL, PSQL, Sql Plus

Reporting Tools: Business Objects 6.x, Cognos

Version control: PVCS

Unix Tools: Putty tool.

Issue Tracker: HPALM

Operating systems: Windows 7/xp/2003/2000/NT, UNIX, Linux AIX

Scheduling Tools: Autosys, Tivoli

Languages: UNIX Shell Scripting, SQL, PL/SQL, C, C++

PROFESSIONAL EXPERIENCE:

Confidential, Miamisburg, OH

Sr. ETL/Informatica Developer

Responsibilities:

• Creating INFORMATICA mappings for the History tables with Slowly changing Dimensions Type2.
• Working on a set of table provided in BRS in a Iteration.
• Working on DMC’s (Data movement Control’s) from Oracle to ParAccel.
• Working with DB2, Oracle, Flat File Source data to ParAccel Target.
• Worked on Migration of Code from Informatica 8.6.1 to 9.1.
• Upgraded to Informatica 9.1 for the ParAccel Support of Informatica.
• Worked closely with the Testing Team in Resolving the issues in Quality Center.
• Creating Mapping for checking the DDL’ mismatches in Source and target tables before start of Actual development.
• Using Putty to create Shell Scripts for running the workflows.
• Unit Testing using Test cases and creating a Unit Test document and uploading in Share point site allotted for the VERO’s, CDW legacy tables and SFCDM tables.
• Working on History table’s, Current Table’s, Dimension table’s, Code table’s and Fact table’s present in our DATA mart system.
• Supporting SIT and UAT Team in resolving Issues.
• Working on re-work of mapping with changing BRS, Re-Unit testing and updating Documents.
• Creating Jil Scripts for the Autosys Automated Job Running in allotted time for a Data Mart.
• Actively participated in Deployment of code into SIT environment and UAT environment after the completion of development for a Set of table’s an Iteration.
• Worked on creating view in IBM Clear Case for the Backup of all the developed mappings.
• Worked with the Integrating Team and raising request for the deployment of developed code in SIT and UAT environment.
• Worked closely with Performance Team in creating Scripts for improved performance.

Environment: Informatica 8.6.1, 9.1, DB2, Oracle, Flat Files, ParAccel, Rapid SQL, PSQL, SQL plus, Putty Tool, HP ALM(QC), Autosys, IBM Clear Case, Windows 7, Unix, WinSCP, BeyondCompare.

Confidential, Atlanta, GA

Sr. ETL/Informatica Developer

Responsibilities:

• Involved in all phases of software development life cycle.
• Involved in requirements gathering and analysis to define functional specifications.
• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing the Informatica Mappings.
• Worked with the Business analysts for requirements gathering, business analysis, testing, and metrics and project coordination.
• Created and analyzed Process Work Flows, Scope & Functional Specifications, and was responsible for preparing Software Requirement Specifications (SRS) and Functional Specification Documents (FSD). .
• Extracted data from wide variety of data Sources like Flat files and Relational Databases (Oracle& SQL Server).
• Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Extensively used various Data Cleansing and Data Conversion functions like Ltrim, Rtrim, Isnull, Isdate,To Date, Decode, Substr, Instr, and IIF functions in Expression Transformation.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Extensively used Pre-Session and Post-Session Success commands to merge the different files to a single file.
• Created and tested Informatica mappings and workflows to automate Job scheduling..
• Worked on Performance tuning to increase the throughput of the data load (like read the data from flat file & write the data into target flat files to identify the bottlenecks).
• Worked on SQL Server Integration Services (SSIS) to integrate and analyse data from multiple heterogeneous information sources (Oracle & Sybase)
• Worked with T-SQL to create tables, views and triggers and stored procedures.
• Written database triggers in T-SQL to check the referential integrity of the database.
• Created packages in SSIS with error handling.
• Written various Unit and Integration test cases and executed.
• Provided knowledge transfer to the end users and created extensive documentation on the design, implementation, daily loads and process flows of the mappings.

Environment: Informatica Power Center 8.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) SQL Query Analyzer 8.0, Oracle 9i/10g, Toad, SQL Developer 1.1.2, DB2.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations
• to implement the business logic and to load the data incrementally
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Updatestrategy.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process using Control M auto scheduling tool.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Created multiple Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing both date based and flag based versioning logic.
• Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Given Production support to resolve the issues.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performance related issues.
• Developed UNIX shell scripts to move source files to archive directory.
• Used Informatica power connect to connect external Data bases.
• Involved in Unit, Integration, system, and performance testing levels
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Created various data marts from data warehouse and generated reports using Cognos
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Created Query prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
• Good knowledge in Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio.

Environment: Informatica Power Center 9.1/ 8.6(Designer, Workflow Manager, Workflow Monitor) Cognos 10 BI, Oracle10g/11g, SQL Server 2008, SQL, Erwin 4.0, TOAD 9.5, Star Schema, UNIX Shell Scripts, AS/400,Cognos8.x, Flat files, Windows XP, and MS-Office tools.

Confidential, Flower Mound, TX

ETL Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.
• 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.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting
• Requirements and project plan for intranet applications for Fixed Income and Equities.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 7.1.2, MS SQL 2000, Oracle 9i, SQL, PL/SQL, ERwin, UNIX Shell Scripting, Windows XP and 2000, Tivoli.

Confidential

Database/ETL Developer

Responsibilities:

• Involved in analyzing and development of the Data Warehouse.
• Translation of Business Processes into Informatica mappings for building Data Marts.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Involved in designing the procedures for getting the data from Flat files, Databases to Data Warehousing system.
• Created mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Creating and running sessions and batches to load the data into the Target Database.

Environnent: Windows, Oracle 8i, Informatica 5.1.