SUMMARY

• 8 Years of IT industry experience including analysis, design, development, testing, and defect tracking of Data Warehousing and Client Server Applications.
• Highly proficient in Data Warehousing ETL using Informatica Power Center 6.1./7.1/8.1/8.6/9.1/9.5 , Oracle 10g/9i/8.x/7.x.
• Expertise in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inman Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling using Erwin 4.2/4.0/3.5.5/3.5.2 , Microsoft Visio.
• Extensive integration experience in working on different databases like Oracle, MS Sql, SAS, flat files.
• Extensive experience in implementing SCD Type 2 using Informatica Power Center 9.X/8.x/7.x.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Power Center.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, unit testing, integration testing, regression testing and UAT in development.
• Actively involved in Performance Tuning targets, mappings and sessions, Error handling Product support on various Platforms.
• Excellent knowledge of studying the data dependencies using Metadata stored in the Informatica Repository and preparing batches for the existing sessions to facilitate scheduling of multiple sessions.
• Experienced in various data sources like SQL Server, Oracle, Fixed Width and Delimited Flat Files.
• Expert in Unix Shell Scripting
• Excellent Analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Ability to function both in a team environment as well as individual capacity.

TECHNICAL SKILLS

Languages: SQL, SQL*PLUS, PL/SQL, Shell Programming.

Operating System: Windows 2000, Windows XP/NT 4.0/98/95, SUN Solaris 2.6/8, UNIX and DOS.

RDBMS and Tools: Oracle 10g/9i/8i/7.x, SQL Server 2005/2008/2012.

ETL: Informatica Power Center 6.1/7.1/8.1.1/8.6/9.1/9.5

Package/Tool: TOAD and SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field user and support for production environment
• Extensively Designed, Developed, Tested Informatica mappings, mapplets and Reusable Transformations to load data from various sources
• Extensively Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Created workflow design document, mapping design document, Integration test plan document, Unit test plan document etc.
• Extensive experience in loading the data from multiple sources like flat files, other RDBMS databases.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Used the update strategy to effectively flag the data from source to target.
• Used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created, Configured and Scheduled the Sessions and Batches for different mappings using workflow Manager and UNIX Scripts.
• Integrated various sources into the Staging area in Data warehouse.
• Created necessary Repositories to handle the Metadata in the ETL process.
• Created the Source and Target Definitions in Informatica Power Center Designer.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Provide production support as needed.

Environment: Informatica Power Center 9.1/9.5, Power Connect, Oracle 11g,, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, RDBMS, Teradata, Power Connect, Tidal, Power Center, Sql server 2012, UNIX Shell Scripting.

Confidential, NJ

Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows - involving several Tasks.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, and Union.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Mappings, Mapplets and Sessions for data loads and data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica PowerCenter.
• Involving in extracting the data from Oracle and Flat files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Experience in analyzing business specification documents, developing test plans defining test cases, developing and XML test scripts.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica Power Center 9.1,Power Exchange, Oracle 11g,PLSQL, DB2, MS SQL Server 2008/2005,SQL* PLUS,MS Excel, UNIX(AIX), UNIX Shell, Autosys

Confidential, Charleston, SC

ETL-Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files and XML files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Developed PL/SQL procedures/packages to kick off the SQL Loader control files/procedures to load the data into Oracle 9i.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Prepared the data flow of the entire Informatica objects created, to accomplish Integration testing.
• Scheduled the jobs in Dev, and Testing environment using Informatica Scheduler.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Created Folders and placed all the tested ETL, Oracle and UNIX scripts in the Staging path for production movement.
• Created UNIX shell scripting and automation of ETL processes.

Environment: Informatica Power Center 8.6/9.1, Oracle 9i, Db2, MS SQL Server 2005, UNIX, PL/SQL and SQL.

Confidential, Kansas city, MO

ETL Developer

Responsibilities:

• Worked within a team to contribute to the successful delivery of a Data Warehouse from the ground up.
• Worked on Informatica tools -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations Developer.
• Used Source Analyzer and Warehouse Designer to import the source and target database Schema's, and the mapping designer to map source to the target.
• Worked with Different sources such as Relational Databases like Oracle, SQL server, Flat Files for Extraction using Source Qualifier and Joiner.
• Created Mappings through various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy etc.
• Worked on Informatica Mapping Designer & Mapplets Designer, and Transformation Developer.
• Tested individual mappings in Workflow Manager.
• Prepared Unit Test Plans.
• Scheduled the workflows as per requirement of user.
• Supported user queries against availability of data from Data Warehouse.
• Performed troubleshooting for non-uniform ness.

Environment: Informatica Power Center 8.1, 8.6.1, DB2, SQL Server 2005, Oracle PL/SQL, SQL and Windows NT/2000.

Confidential

Informatica Developer

Responsibilities:

• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Implemented efficient and effective performance tuning procedures.
• Fixed invalid Mapping’s, tested Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Workflows and Target Data.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Created Sessions, reusable Worklets in Workflow Manager and scheduled the sessions to run at a specified frequency.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Worked on UNIX shell scripts.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.

Environment: Informatica PowerCenter 7.1.3, DB2 v8.0, SQL, Windows 2000, UNIX, SQL Server 2000, Oracle 9i, Flat files, SQL *Plus, Control- M.