SUMMARY:

• A Certified Informatica and BI developer with 9 years of IT experience in analysis, design, development, testing, maintenance and user of data warehousing and ETL process using Informatica Power Center 9.6/9.1/8.x/7.x/6.x
• Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing in a corporate wide ETL Solution using Informatica Power Center.
• Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experience in integration of various data sources as Flat Files, Oracle, SQL Server, XML and Excel into staging area.
• Designed and developed complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more
• Involved in all phases and complete life cycle of teh Datawarehouse /ETL project me.e. Logical and Physical Data modeling, Designing ETL strategies, Development, Testing, Validation of test ETL scripts, Implementation, Production Support.
• Having sound knowledge in OLAP & Multi-Dimensional Data Modeling. Designing star-schema / snowflake schemas, Data Marts, Data Mining, Data quality Analysis, Data Integration, Slowly Changing Dimensions (SCD) and Creating job flow diagram
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Extensively worked on transformations, creation of Worklets, Mapplets, reusable transformations, Push down optimization, usage of parameter files, edit rules and validation of business rules
• Experience in automating of teh ETL processes for migration and patching Informatica objects
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER.
• Extensive experience in sourcing data from Relational Databases like Oracle, SQL Server, MS Access and flat files into a common reporting and analytical Data Model using Informatica.
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
• Extensive experience in designing and working with Oracle 11g/10g/9i/8i and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, bulk collect. Database Objects using PL/SQL and possess good understanding of oracle data dictionary.
• Experience in SQL performance tuning.
• Experience in maintaining Data Concurrency, Replication of data.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Experience in using Sql developer, SQL*Plus, Procedures/Functions and Performance tuning
• Practical understanding of teh Database schemas like Star Schema and Snow Flake Schema used in relational and dimensional modeling.
• Good experience in writing Shell Scripts to automate file manipulation and data loading procedures.
• Exposure to teh entire process of Software Development Life Cycle.
• Maintain and support programs/tools for internal and external clients
• Designed Applications according to teh customer requirements and specifications.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and part of teh team.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x

Operating Systems: MS Windows, UNIX.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000, MS Access SQL Server, DB2

Data Modeling: Star Schema and Snow-Flake Modeling, FACT and Dimensions Tables, Physical, Logical and Relational Data Modeling

Scheduling Tools: Control- M and Tidal Software, Data warehouse Administrative Console (DAC)

Programmig: Shell Scripting, SQL

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of teh project.
• Interact with teh requirements team and designers to get a brief knowledge of business logics.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier
• Analyzing, designing and implementing complex SQL stored procedures, ETL processes and informatica mappings.
• Implemented SCD2 type maps to capture new changes and to maintain teh historic data
• Providing technical assistance during production phase of project development.
• Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.
• Designed and written teh scripts required to extract, transform, load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store.
• Created new mappings and enhancements to teh old mappings according to changes or additions to teh Business logic.
• Worked on SQL and DB2 databases.
• Worked extensively on Unit Testing teh ETL mappings and preparing efficient unit test documentation for teh developed code to make sure teh test results match with teh client requirement.
• Provided enterprise data warehousing solutions, including design and development of ETL processes, mappings and workflows using Informatica Power Center. by CouponDropDown">Participate din design workshops, providing technical insight and knowledge.

Environment: Informatica Power Center 9.6.1, UNIX, DB2, SQL*PLUS, Control M, Flat Files, Cognos, WinSQL, Mainframe.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Worked with Informatica PowerMart client tools like Source Analyzer, Warehouse Designer, and Mapping.
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extracted data from Flat files loaded them into EDW.
• Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.
• Involved and Worked with DBA to build Dimension Tables and Fact Tables.
• Created source and target mappings, transformation logic and processes to reflect teh changing business environment over time.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into teh data warehouse.
• Extensively participated in functional and technical meetings for designing teh architecture of ETL load process
• Involved in designing teh Data mart and entire data warehousing life cycle.
• Mainly involved in developing Star Schema (Facts and dimensions based on future requirements).
• Developed source to target mappings and scheduling Informatica sessions.

Environment: Informatica Power Center 9.0.1, Oracle 10G, WLM, UNIX AIX, DB2, Flat files, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripting, Autosys, Erwin 4.2.

Confidential

Informatica Developer

Responsibilities:

• Interacted with teh users in collecting teh business requirements.
• Designed ETL process as per teh IDW (Institutional Data warehouse) Framework and documented ETL process using MS VISIO.
• Demonstrated teh ETL process Design with Business Analyst and Data Warehousing Architect.
• Implemented multi-level product packaging hierarchy for home entertainment sale and return data.
• Responsible for implementing promotion attribution and product classification for a product based on its hierarchy
• Implemented teh logical Informatica connections across teh different databases.
• Developed korn shell scripts for loading teh data from teh operational data store (ODS) into teh various datamarts in teh warehouse.
• Developed a generic way to load data for teh General Ledger User Extension (GLUE) into teh Sales Planning Mart.
• Performed Source System Analysis. Analyzed teh Source and Target Data elements. Analyzed Source Data granularity. Developed Mapping document and Unit & System Test Plan.
• Extensively worked with Source Analyzer, Warehouse Designer to define teh Source and Target objects in Informatica Repository. Extracted Source Data using Informatica tools and Stored procedures from Source systems.
• Used Informatica Transformations, Mapping Designer, Mapplets to Develop ETL programs (Source Staging IDW Datamart) and to implement business rules. Developed and Configured Sessions and Batches/ Work flow to run teh ETL programs.
• Designed and implemented Meta Data repository and reusable components to capture ETL Meta Data.
• Developed and Complex ETL programs to implement Multilevel hierarchy in dimensional tables to facilitate teh Slicing / Dicing of Data. Implemented de-duping process while loading teh IDW Tables.
• Defined and created facts, metrics, attributes, filters, prompts and consolidation objects in MicroStrategy
• Developed Data Audit Control programs to Audit teh Data in Staging, IDW and Data Mart. Audit Control programs are developed using Shell Scripts, Stored Procedures, and Informatica capabilities.
• Extensively used almost all teh transformations, which includes (Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier). Extensively used all teh capabilities of Power Center / Power mart Capabilities such Target override, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data. Participated in UAT (User Acceptance Testing).
• Seamlessly migrated teh code from Development Testing UAT Production.
• Scheduled batch jobs in Control M. Coordinated with System Operators to Schedule teh batch jobs in control M.
• Extensively involved in Fine tuning teh Informatica Code (mappings and Sessions), Stored Procedures, SQL to obtain optimal performance and throughput

Environment: Informatica Power center 7.1, IBM DB2 UDB 7.x, Microsoft SQL Server, Flat Files, VISIO, Erwin 4.0, Windows 2000, UNIX, Microstrategy 7.2 and DB ARTISAN.

Confidential

ETL Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Created mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and DB2
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning mappings for better performance and efficiency.
• Migrated mappings from Dev to Test and Test to Production repositories.
• Created sessions and workflows to run with teh logic embedded in teh mappings using Power center Designer.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.
• Responsible for testing and validating teh Informatica mappings against teh pre-defined ETL design standards.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 7.1, Oracle 8, Windows 2000, TOAD, Erwin 4.0