PROFESSIONAL SUMMARY:

• 7+ years of professional experience with expertise in design, analysis, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle, MS SQL server databases on windows and UNIX platforms.
• Extensive knowledge in Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.5/9.1.1/8.6/8.1/7.1.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Experience in Designing, Installing & Configuring core InformaticaMDM Hub components, Informatica MDMHub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and IDD & Data Modeling
• Configured different Source Systems of MDMtables in MDM Hub: Landing tables, Base Objects, Staging Tables, and Relationships Base Objects
• Strong expertise in Relational data base systems like Oracle, SQL Server design and database development using SQL, PL/SQL, SQL PLUS, TOAD.
• Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Worked as a Technical Team Lead to help my team members resolving issues related to performance tuning in developing Informatica mappings and workflows.
• Proficient in designing and developing complex standard and re - usable mappings and mapplets using various transformation logics by utilizing the expression, filter, joiner, lookup, router, rank, normalizer, aggregator.
• Expert level experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center / Power Mart 7.x/8.x/9.x (Source Analyzer, Warehouse Designer, Mapping/ Mapplet Designer, Sessions/tasks, Worklets / Workflow Manager).
• Extensive experience in analyzing the Dimensional Data modeling, Star Schema/Snowflake Schema, modeling, FACT & Dimensions tables, Physical & logical data.
• Extensive work with PL/SQL, performance tuning of Oracle.
• Experienced with Informatica Power Exchange (5.x/8.x/9.x) for Loading/Retrieving data from mainframe systems.
• Good experience with configuring Data Warehouse Administration Console (DAC) for creating execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Worked with Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
• Experience in working with the Heterogeneous data sources like Oracle, My SQL, Flat files, XML files, Web services.
• Configured different Source Systems of MDMtables in MDM Hub: Landing tables, Base Objects, Staging Tables, and Relationships Base Objects.
• Proficient in reporting tools as Tableau and SQL Server reporting services (SSRS).
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy and COBOL Sources.
• Experience in Performance Tuning of source, target, mappings, transformations and sessions.
• Complete knowledge of data ware house methodologies, ODS, EDW and Metadata repository.
• Strong SQL knowledge and the ability to write the complex SQL queries.
• Expertise in developing Extract and Transformation mappings with various ETL tools.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement Experience working with Onside-Offshore model.
• Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6.1.1/7.1.2/6.2/6.1/5.1, Power Mart 5.0/4.7, Dataware House Builder, Abinitio.

Operating Systems: Windows XP/2000/NT/98/95, Windows 2003 server, MSDOS

RDBMS: Oracle 11g,10g/9i/8i/8.0, MS-SQL Server 2008/ 2005/2000/7.0/6.5

Data Modeling: Star Schema Modelling, Snow-Flake Modelling, Erwin 4.1.4/3.5.2

Data Base Tools: SQL Loader, MS Visio, MS Access

Reporting Tools: Tableau, SSRS, Web Intelligence, Business Objects XI/6.x/5.x, OBIEE 10.x/9.x

Web Technology: Web Technology HTML, CSS, Java script

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

Scheduling Tools: Unix Scheduler, Informatica Scheduler, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, MN

Sr. ETL Developer

Responsibilities:

• Interacted with Business Analysts to understand the requirements
• Analyzed the requirements and prepared optimize design.
• Involved in ETL designing and coding. Extensively used ETL to load data from Oracle database, SQL server, and Flat files to Teradata Data Warehouse.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Involved in production support for the Data Warehouse Informatica jobs.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Created robust and complex Workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/workflows
• 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 Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings to extract data from ODS to Data Mart, and monitored Daily, Weekly and Monthly Loads.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing
• Developed some scripts to take weekly backups of certain tables using korn shell and import/export utilities.
• Worked on tuning some individual mappings and oracle queries that causes performance bottlenecks.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Implemented Complex business rules by creating re-usable transformations, workflows/ worklets and Mappings / Mapplets
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Worked with mapping variables, Mapping parameters and variable functions like set variable, Count Variable, Setminvariable and Setmaxvariable.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
• Involved in MDM Service Integration Framework (SIF) for cleaning Base Objects, applying change lists, Validating ORS, executing Batch groups etc.,

Environment: Informatica Power Center 9.5/9.1, Teradata 13 1, SQL Server 2008, Tidal, OBIEE 10g, Mercury Quality Centre 10.1, DAC, PL/SQL, Toad, MDM, UNIX Shell Scripts.

Confidential, Chester brook, PA

Sr. ETL Developer

Responsibilities:

• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created shell scripts to kick off Informatica workflow/s and PL/SQL procedures.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Extensively used UNIX scripts for automation of ETL process.
• Extensively worked on tuning mappings and reducing processing times.
• Worked with DBA to identify source and target bottle necks.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Involved in production support for the data warehouse Informatica jobs.
• Involved in bug fixing. Debugged the issues during QA level.
• Provided subject matter expertise on Master Data Management and ETL Concepts
• Responsible for driving project management through technical decisions related to master data management

Environment: Informatica Power Center 9.5, MDM, SQL, Sybase 15.x, CA Scheduling, UNIX Shell Scripting, Tortoise SVN, Putty, Toad, OBIEE.

Confidential, Minneapolis, MN

Sr. DW ETL Informatica Consultant

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installed, and Documented the Informatica Power Center setup on multiple environments.
• Provided guidance for all Master Data Management (MDM) aspects involved in the development of EDW
• Responsible for understanding all development in the area of MDM and ETL

Environment: Informatica Power Center 9.5 Work Flow Manager/Monitor, Oracle 11g/10g, SQL, PL/SQL, MDM,TOAD, SQL * Loader

Confidential, Indianapolis, IN

Informatica Developer

Responsibilities:

• Used ETL process to Extract, Transform and Load different source data into stage area and data warehouse.
• Designed and developed complex mappings, from varied transformations logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Designed and developed Stored Procedure, and Sequence Generator and created mappings.
• Experience in creating mappings, sessions, workflows, reusable mapplets, worklets, scheduling and debugging the mappings.
• Involved in creating templates in Word and Excel for status sheets, for capturing requirements and for various other purposes.
• Having extensive experience in writing ETL technical documentation and testing documents and maintain the source control
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat file and databases and loaded into Oracle target database.
• Performed unit testing to check if data loaded correctly from source to target tables
• Good Knowledge in Data warehousing concepts like Star Schema, snowflake schema, Dimensions and Fact tables.
• Optimizing Informatica Mappings and Sessions to improve the performance.
• Worked as a liaison between developer andend-usersto resolve defects.
• Tuning the reports for better performance.
• Used to writing queries using Toad and SQL Developer tool.
• Extensively used SQL, PL/SQL to write stored procedures, functions, package and triggers.
• Involved in Review and Quality checking of other team members Code.
• Troubleshooting and Analysis of Defects and providing recommendations to the customer and actively participated in resolving the issues.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.

Environment: Informatica Power Center 8.6.1, ODI 11g, SQL, Oracle 10g/11g, BI Publisher, SQL Server2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Cognos 8.4.

Confidential

Informatica Consultant

Responsibilities:

• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Responsible for identifying reusable logic to build several Mapplets, developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Involved in documentation of the project activity all along the course of the project along with Failure Recovery plans.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling jobs.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled workflows to extract, transform and load data into warehouse as per Business requirements.
• Improved the session performance by pipeline partitioning.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Developed Procedures and Functions in PL/SQL for ETL.

Environment: Informatica Power Center/Power Mart 8.6, XML, DB2, Informatica Power Connect, Workflow Monitor,, Windows 2000, Oracle 9i, PL/SQL Developer, SQL Server2000,Toad, Microsoft Excel.

Confidential

ETL/Informatica Developer

Responsibilities:

• Analyzed the existing business model.
• Created mappings using transformations such as source qualifier, aggregator, expression, lookup, and router, filter and update strategy.
• Responsible for tuning the Performance of Informatica ETL mappings.
• Implemented procedures/functions in PL/SQL for stored Procedure Transformations
• Interacted with business users on weekly basis in finalizing high-level business requirements.
• Prepared detail-level design documents based on the discussions to get sign-off from business.
• Analyzed the impact and provided estimations in PD's to Client whenever there was a change in client requirements.
• CreatedInformatica jobs to extract data from different external sources and populate into Data Warehouse tables/flat files by transforming the data as per business requirements.
• Involved in Unit testing and Integration testing of Informatica workflows.
• Analyzing the impact and providing the Estimations to Client in PD's whenever there is a change in the requirement.
• Provided the warranty support by interacting with production support teams.

Environment: Informatica 8.1, MS SQL Server 2005/2000, Win 2000, Flat Files, Oracle 8i, DB2, SQL, PL/SQL.

Confidential

ETL Analyst

Responsibilities:

• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Involved in production support for the data warehouse Informatica jobs.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Automated Reports and generated documents using Scheduler.
• Created robust and complex workflow and worklets using Informatica workflow manager and troubleshoot data load problems.
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/workflows
• 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 Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.

Environment: Informatica Power Center 8.1, Oracle 9i, PL/SQL, OBIEE, Toad, DAC, Windows.