SUMMARY

• Around 7+ years of IT experience in Designing, Analysis, Development, Maintenance and Implementation of Data Warehousing Systems as ETL Developer.
• Experience in Data Warehouse requirements gathering, analysis, design, conversion of business requirements into high level functional specifications
• Written Technical Specification, test plans and test data to support ETL processes.
• Good at ETL mechanism using Informatica complex, high volume Data Warehousing projects in both Windows and UNIX environment.
• Extensively worked on Informatica power center tools - Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Maplet and Mapping Designer.
• Experienced in Installation, Configuration of Informatica Power Center Client & Server.
• Experienced in designing/developing complex mappings, from varied transformation logic like Unconnected and connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer.
• Strong experience in creating Stored Procedures, Indexes, Functions using PL/SQL.
• Involved in Informatica Power Center upgrade from 7.1/6.x to 8.5.1.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experienced in Performance Tuning including identifying and eliminating bottlenecks of sources, mappings, sessions and targets.
• Experienced in the integration of various data sources like Oracle, DB2, XML files, Flat Files, SQL Server.
• Excellent skills in retrieving the data by writing simple/complex SQL Queries.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in creating mappings, mapplets and reusable transformations.
• Good knowledge in Scheduling Tools like Tivoli, Tidal and Autosys.
• Experienced in Version Control by using CVS, VSS and Clear Case.
• Strong technical background, and possess excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 6.x/7.x/ 8.1/8.6.1/9.1.

OLAP/DSS Tools: Business Objects XI r2/6.5.1

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

Others: TOAD, PL/SQL Developer, SQL-Navigator, Test Director, Win Runner

Database Skills: Stored Procedures, Database Triggers and packages

Data Modeling Tools: Physical and Logical Data Modeling using ERWIN 3.5/4.5/7.x

Languages: C, C++, Java, UNIX shell scripts, XML, HTML

Operating Systems: Windows NT/ 2000/2003, LINUX, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Menomonee Falls, WI

ETL Developer

Responsibilities:

• Perform analysis and gathering requirement by coordinating with Business Users.
• Prepare High Level and Low Level Design Specifications.
• Prepare Source to Target mapping documents for ease of ETL implementation.
• Prepare specifications to create new Data model by coordinating with Data Architect and DBA.
• Created and reviewed Informatica mappings, sessions and workflows.
• Created test data, test scripts, perform testing and review test results.
• Extensively worked on created and reviewing SQL scripts and UNIX shell Scripts.
• Tuned embedded SQL in Informatica mappings.
• Extensively tuned Informatica mappings, sessions by following best practices to avoid unnecessary caching of records by the lookups.
• Created and used native SQL for performing updates where Informatica is taking more time on huge dataset tables.
• Purging old data using Post-SQL in Informatica mappings.
• Involved in development of Informatica interfaces.
• Involved in periodic team Meetings to get regular updates from the team.
• Involved in pulling data from XML files, flat Files, SQL Server into Data warehouse and then Data Mart.
• Participated in logical & physical and STAR Schema for designing the Data Marts.
• Wrote complex SQL scripts to avoid Informatica Joiners, Unions and Look-ups to improve the performance as the volume of the data was heavy.
• Provided requirements to the Business Objects development team to create reports.
• Involved in working with the Business Objects team to create required Universe measures to auto populate values at the report level.

Environment: Informatica Power Center 9.1, Windows XP/2003, UNIX, XML, Oracle 10g, IBM Mainframes, SQL server 2005, VISIO, SQL and PL/SQL.

Confidential, Richfield, OH

Informatica ETL Developer

Responsibilities:

• Perform analysis and gathering requirement by coordinating with Business Users.
• Prepare High Level and Low Level Design Specifications.
• Prepare Source to Target mapping documents for ease of ETL implementation.
• Prepare specifications to create new Data model by coordinating with Data Architect and DBA.
• Created and reviewed Informatica mappings, sessions and workflows.
• Created test data, test scripts, perform testing and review test results.
• Extensively worked on created and reviewing SQL scripts and UNIX shell Scripts.
• Tuned embedded SQL in Informatica mappings.
• Extensively tuned Informatica mappings, sessions by following best practices to avoid unnecessary caching of records by the lookups.
• Created and used native SQL for performing updates where Informatica is taking more time on huge dataset tables.
• Purging old data using Post-SQL in Informatica mappings.
• Involved in development of Informatica interfaces.
• Involved in periodic team Meetings to get regular updates from the team.
• Involved in pulling data from XML files, flat Files, SQL Server into Data warehouse and then Data Mart.
• Participated in logical & physical and STAR Schema for designing the Data Marts.
• Wrote complex SQL scripts to avoid Informatica Joiners, Unions and Look-ups to improve the performance as the volume of the data was heavy.

Environment: Informatica Power Center 8.6.0, Windows 7 Pro, UNIX, XML, Oracle, VISIO, SQL and PL/SQL, JIRA, AccuRev, Oracle SQL Developer.

Confidential, NJ

ETL/Informatica Developer

Responsibilities:

• Proficient in interactingwith Business Analyststoclearly understand business requirements.
• As an active member of warehouse design team, assisted in creatingfactanddimensiontables as per requirement.
• Design of the Data Warehousing tables was carried out in STAR schemamethodology.
• Extensively used Informatica Power Center to create data maps for extracting the data fromvariousRelational systemsand loading intoOracleStaging tables.
• PerformedData cleansingusing external tools likeName Parser andDataFlux.
• Extensively usedInformaticaclient toolsSource Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Implemented various integrity constraints for data integrity likeReferential Integrity, usingPrimary keyandForeign keysrelationships.
• Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
• Designed and created complex source to targetmapping using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control).
• OptimizedQuery Performance, Session Performance and Reliability.
• Configured the mappings to handle the updates to preserve the existing records usingUpdate Strategy Transformation(Slowly Changing DimensionsSCD Type-2).
• Implemented stored procedures, functions, views, triggers, packages inPL/SQL.
• UsedSource Pre-Load,Source Post-Load,Target Pre-Load,Target Post-Loadfunctionality of Stored Procedure Transformation.
• PerformedPerformance tuningof targets, sources, mappings and session.
• Involved inPartitionsofPipelinesto improve performance.
• Created very usefulUNIX shell scriptswhile writing cron jobs for batch processing.Excellent experience using Tivoli job scheduler.
• UsedTest Directorto log thedefectsand coordinated with Test teamfor a timely resolution.
• ProvidedProduction Supportat the end of every release.
• GeneratedOLAPreports usingBusinessObjects from Oracle target database.
• Created Multi-Dimensional analysis usingSlice/Dice and Drill methodsto organize the data along a combination of “Dimension” and “Hierarchies”.
• Documented Technical specifications, business requirements and functional specifications for the InformaticaExtraction, Transformation and Loading (ETL) mappings.

Environment: Informatica Power Center 8.1/7.1, Oracle 10g/9i, UNIX, SQL SERVER, PL/SQL, SQL*Loader, Business Objects, Windows NT/2000.

Confidential, San Jose, CA

ETL/Informatica Developer

Responsibilities:

• Coordinated the meetings with Architects and Business analysts for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.
• Involved with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design (star schema) and maintenance.
• Worked with Team Lead and Data Modeler to design data model using Erwin 7.1
• Extensively worked on multiple sources like Oracle 10g, DB2, MS SQL server, XML and delimited flat files to staging database and from staging to the target XML and Oracle Data Warehouse database.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica powercenter 8.6.1/7.1.4.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations were used like the Source qualifier, Router, Aggregators, Connected & Unconnected Lookups, Unions, Filters & Sequence.
• Worked on requirement gathering for B2B XML’s feed(Customer and Product).
• Developed XML’s using XML parser Transformation for large scale data transmission.
• Developed functional and Technical design documents for implementing Informatica web services.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Used SQL tools like TOAD 9.6.1 to run SQL queries and validate the data in warehouse.
• Used Unix Shell Scripts for automation of ETL Batch Jobs.
• Involved Bulk data loading used J2EE Web Service to FTP XML’s Feed (Customer & Product) to B2B.
• Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporting.
• Conducted interviews and organized sessions with Business and SMEs located at various theaters across the globe to obtain domain level information and conduct analysis.
• Involved in preparing Test script documentation for Load Testing and involved in ping tests conducted on servers from different theaters across the globe
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements

Environment: Informatica Power Center 7.1.4/8.6.1 , Oracle 10g/9i, Linux, XML, SQL SERVER, PL/SQL, TOAD 9.6.1, Unix, Business Objects XI, Shell Scripts, SQL Navigator.

Confidential, Memphis, TN

ETL, SQL Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into datamart.
• Converted functional specifications into technical specifications (design of mapping documents).
• Involved in Designing logical and physical ER data Models by using Erwin tool
• Developed complex mappings to load data from multiple source systems like Oracle 10g, Teradata, DB2, flat files and XML files to datamart in Oracle database.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Wrote complex SQL scripts to avoid Informatica Joiners, Unions and Look-ups to improve the performance as the volume of the data was heavy.
• Loaded data from flat files to temporary tables in Oracle database using SQL*Loader.
• Used Global temporary tables for processing DML operations on huge data from GUI at one time.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Fine Tuned SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans and Trace sessions with Cost and Rule based optimization.
• Used KORN Shell scripts to automate Oracle script execution.
• Extensively used Scheduling ETL Jobs tools like Tidal.
• Coordinated with DBA’s in resolving the database issues that lead to production job failures.
• Involved extensively in Unit testing, integration testing, system testing and UAT.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements

Environment: Oracle 10g/9i, PL/SQL, SQL* Loader, TOAD 9.5, Sybase, Informatica Power Center 8.1/7.1.4, Reports 9i, Crystal reports, ERWIN 7.x, MS Visio, UNIX

Confidential

ETL/Database Developer

Responsibilities:

• Extracted source definitions from various databases like oracle, DB2 and SQL Server into the Informatica Power Center repository.
• Worked on Dimensional modeling to Design and develop STAR Schemas, used ER-win, identifying Fact and Dimension Tables.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Worked with different Operation Data Sources such as Oracle, SQL Server and Legacy Systems, Excel, Flat files.
• Used Informatica to extract data into Data Warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Sever manager for session management, database connection management and scheduling of jobs to be run in the batch process
• Created dimensions model star schemas using Kimball methodology.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for different Health Plan Systems to facilitate Daily, Monthly and Yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data
• Written documentation to describe program development, logic, coding, testing, changes and corrections
• Arrived at the dimension model of the OLAP data marts in Erwin.
• Recover the failed Sessions.
• Optimized the mappings by changing the logic and reduced running time.
• Finished the tasks within the allocated time for every release, always we are on Time and on Target.

Environment: Informatica Power Center 7.1.4, Oracle 8i, SQL, PL/SQL Procedures, SUN OS, Business Objects 5.1, UNIX Shell Scripting.