SUMMARY

• Over 8+ years of total IT experience with Informatica PowerCenter experience.
• Strong experience in Data Warehousing, Data Analysis, ETL, Data Modeling, development, Testing methodologies and Support.
• Extensively worked with Informatica Tools - Repository Manager, Warehouse Designer, Workflow Manager, Workflow Monitor and Transformation Developer.
• Experience in OLTP/OLAP System Study, Analysis and E-R modeling, Kalido modeling, developing Database Schemas like Star schema and Snowflake schema, which are used in relational, dimensional modeling.
• Hands on experience developing Scripts and Procedures for Cleansing, Extracting, Transformation and Loading the data into Data Warehouse.
• Extensive experience in Database Performance Tuning, Informatica Mapping and Session tuning, SQL *Loader, Imports and Exports.
• Extensive knowledge of project management methodologies and SDLC.
• Strong technical skills in Oracle, SQL, DB2, PL/SQL, T-SQL, Toad, SAP R/3 and Teradata.
• Experience with VLDB (very large database) environments approx (~ 10 Terabyte).
• Excellent analytical, written, programming and communication skills to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.X/8.x/7.x/6.x/5.x.

RDBMS: Oracle 11g/10g/9i/8i, Teradata, Toad, SQ Developer, MS SQL Server 2008/05/00/7. x/6.x Sybase 12.x, MS Access 2000/97, DB2 8.x/7x.

Operating System: Windows 7/Vista/XP/2000/NT/98, UNIX, IBM AIX, Solaris 10/5.x/2.x, HP -UX, Linux-Suse 10.

Languages: SQL, PL/SQL, SQL Plus, T-SQL, SQL *Loader, Toad 10.x/8.x, C, C++, Java, Cobol, UNIX Scripting (Bourne, Korn Shell), Perl Scripting.

Web Technologies: VB Script, HTML and XML.

Reporting Tools: Business Objects Boxi.3.1, Cognos 8.x, OBIEE 10.x, Micro Strategy 9.x/7.x

Data Modeling: Star Schema, Snowflake Modeling, Fact and Dimension tables using Erwin 4.x, Microsoft Visio and Kalido.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr ETL Developer

Responsibilities:

• Actively involved and interacted with Business Analyst while preparing technical design document and ensure that it is sync with Functional Design Specification.
• Analyze and profile Source data to identify data cleansing requirement.
• Prepared Source to Target mapping document with ETL specification.
• Created Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Expression, Lookup (connected / unconnected), Filter, Router, Rank, Update Strategy.
• Create UNIX scripts and Parameter files for proper execution of Informatica Workflows in different environment.
• Performed code reviews / code walk through.
• Participated in code deployment into QA and Prod environments with level 2 support and support documentation.
• Extensively worked with BA, QA and DBA for any issues.

Environment: Informatica PowerCenter 9.1, Microstrategy 9.2, Oracle 11g, PL/SQL, DB2, Linux, Flat files, Toad 9.5, Sql Server 2005.

Confidential, CA

Sr. ETL Consultant

Responsibilities:

• Actively involved and interacted with Business Analyst while preparing technical design document and ensure that it is sync with Functional Design Specification.
• Analyze and profile Source data to identify data cleansing requirement.
• Prepared Source to Target mapping document with ETL specification.
• Created Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Expression, Lookup (connected / unconnected), Filter, Router, Rank, Update Strategy.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, daily, monthly, and yearly loading of data.
• Debugged the mapping for defect analysis and fixing the defects.
• Manage and track implementation of fixes/enhancement through change control process.
• Create UNIX scripts and Parameter files for proper execution of Informatica Workflows in different environment.
• Migrated existing Mappings to Testing and Production environment and provided support.
• Performance tuning for Informatica Transformations, Mappings and Session to reduce Batch jobs.
• Performed code reviews / code walk through.
• Improved performance of the jobs using various performance tuning techniques.
• Maintained off shore team to work on multiple projects.
• Performed data validation between various systems and drive changes that ensure the integrity of data, along with creation and consolidation of reports.
• Provided weekly status to the corresponding Project Managers and Program Mangers.
• Extensively worked with QA and DBA's for any issues.

Environment: Informatica PowerCenter 7.x/8.x/9.x, OBIEE 10.x, Oracle 10g, SQL Developer, Solaris 10, HP QC, MS Visio and Flat files.

Confidential, GA

Sr. ETL Consultant

Responsibilities:

• Developed mappings to load data in slowly changing dimensions type 1 and 2.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, daily, monthly, and yearly loading of data.
• Debugged the mapping for defect analysis and fixing the defects.
• Create Unix scripts and invoke them from Informatica PowerCenter session ( as pre, post session commands).
• Manage and track implementation of fixes/enhancement through change control process.
• Ability to maintain and work on the huge volumes of data (~Terabyte).
• Performed Unit test, Functional Test and Integration Test for all mappings.
• Migrated existing Mappings to Testing and Production environment and provided support.
• Extensively involved in performing Data validation process.
• Participating in problem solving and troubleshooting for the applications implemented with ODI.
• Performance tuning of Informatica Transformations, Mappings and Session to reduce of Batch jobs.

Environment: Informatica PowerCenter 8.6.x, BO XI, Oracle 10g, Toad 10.x, UC4, IBM AIX and Flat files.

Confidential, San Ramon, CA

Sr.ETL Consultant

Responsibilities:

• Performed data analysis of the source data coming from different databases like Oracle, Access and flat files.
• Used Power Exchange for extracting the data from SAP.
• Created macros in Access to convert the source table into flat files. Writing FTP scripts to extract the source files from different machines.
• Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.
• Developed the mappings and mapplets to populate the fact, dimension and lookup tables in the data mart from the staging area, which would be used for ad-hoc reports using Cognos.
• ETL Design and Development, Data Integration, Data Migration, Data Quality, Data Profiling.
• Developed scripts to perform both Unit and System integration testing of the data mart.
• Participated in code deployment into testing and production environments with provided support.

Environment: Informatica PowerCenter 8.6.x/8.1.x, Power Exchange 8.6.x/8.1.x, Cognos 8.x, Oracle 10g, PL/SQL, SAP R/3, Solaris 10, Flat files.

Confidential, Redwood City, CA

Sr. ETL Consultant

Responsibilities:

• Worked with the business analysts for requirement gathering and created technical design document.
• Designed and developed standard re-usable mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Created DTS packages to maintain central repository.
• Wrote SQL Queries, UNIX Shell Scripts, Triggers, and PL/SQL Procedures to apply and maintain the Business rules.
• Providing level 2 support and resolving the failures as per Service Level agreement.
• Used Autosys scheduler to schedule jobs for weekly and history data loads.

Environment: Informatica PowerCenter 7.x, Oracle 9i, Erwin, UNIX Shell Scripts, SQL *loader, Solaris 5, VSAM, MS SQL Server 2005, PL/SQL, Db2, Business Object 6.x.

Confidential, IL

Data Warehouse Developer

Responsibilities:

• Data modeling using Star Schema, Dimension and fact table using Erwin.
• Developed Incremental and Updateable loading through Mappings.
• Debug, and resolve the loading failure by verifying the log files.
• Created Power Play Cubes using Transformer ( Power Play).
• Generated reports using Cognos Impromptu tools querying database.

Environment: Informatica Power Mart6.x, PL/SQL, DB2, Oracle8, Cognos Impromptu 5.x, Impromptu Web reports (IWR) Power Play, Erwin 4.x, TOAD, UNIX Shell Scripting, HP Unix.

Confidential

Database Developer

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Involved in developing interactive forms and customization of screen using form 4.x.
• Involved in building, debugging and running forms.
• Involved in data loading and extracting functions using SQL*Loader.

Environment: Forms 4.x, Oracle, SQL *Loader, PL/SQL.