SUMMARY

• Over 7+ years of strong data processing experience in designing and implementing Data Mart applications, mainly Transformation processes using ETL tool Informatica Power center.
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snowflake Schemas.
• Extensive experience in Working with Informatica Power Center involving Warehouse Designer, Workflow Manager, Work flow Monitor, Repository Manager, Source Analyzer and developed Source and Target layout, Mappings, Mapplets, Worklets and Transformations.
• Strong experience in programming using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages.
• Good knowledge of OLAP reporting tool Business Objects - Supervisor, Designer and Business Objects for building Enterprise reports.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Excellent knowledge and experience of Project Planning, Architecture and Development.
• Team and Independent Player with excellent Organizational and Interpersonal skills.
• Excellent written and oral communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5.1/8.x/7.x/6.x/5.x (Power Center/Power Mart/Power Exchange) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Star Schema Modeling, Snow Flake Modeling, Rational Rose Suite (UML)

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

Reporting Tools: Cognos 7.0/6.0, OBIEE Business

Languages: PL/SQL, T-SQL, Unix Shell Script, Visual Basic, XML, Java and ASP.

DB Tools: Toad, SQL* Loader, Auto sys, DB Visualizer, SQL Navigator

Operating Systems: Windows 7/ Vista,2003/2000/NT, AIX, Sun Solaris, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Worked with Business analysts for requirements gathering, business analysis and designing of data marts.
• Implemented Star Schema for the data warehouse.
• Worked on Informatica Power Center Designer-Source Analyzer, Warehouse designer, Mapping Designer & Mapplet designer and Transformation Developer.
• Designed and developed ETL(Extract, Transformation & Load) strategy to populate the Data- Warehouse from the various source systems such as Oracle, Flat files, SQL Server.
• Developed mappings using various transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and captured the deleted records from the source systems.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Used the update strategy to effectively load data from source to target.
• Standardized parameter files to define session parameters such as database connection for sources, targets, last updated dates for Incremental loads and many default values of fact tables.
• Used Target Load Order and Constraint based loading.
• Configured tasks and workflows using workflow manager.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration testing of Informatica sessions, Batches and the Target Data.
• Tuned the sessions for better performance by eliminating various performance bottlenecks.

Environment: Informatica Power Center 8.1, DB2, SQL Server 2005, PL/SQL Developer, SQLUNIX, Windows 7, Cognos.

Confidential, Sunnyvale, CA

ETL/Informatica Developer

Responsibilities:

• Attended business user meetings along with development team.
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow manager.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches, Target Data.
• Validation of Data using SQL queries.
• Managing all the documents in SharePoint repository.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Used Flat files, DB2 and Oracle for sources.
• Build complex SQL queries using Oracle Toad for data validation.
• Creating new Tables, Summary tables and Views as per the requirements of the report specifications or for the mapping and fixed the bugs.
• Developed mappings using Informatica power center Designer to load the data from the staging database to the presentation database.
• Good experience in Agile Environment, Daily Standup meetings, Sprint Planning meetings and Retrospective meetings.
• Coordinated with offshore team on deliverables.

Environment: Informatica Power Center 8.1, Oracle 9i/10g, PL/SQL, TOAD 9.0, UNIX Shell Scripts, OBIEE, MS-Office, Windows XP, IBM AIX.

Confidential, Deerfield, IL

ETL Developer

Responsibilities:

• Involved in Dimensional modeling (Star Schema) of the Data warehouse and designed the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated the Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Extensively migrated data from different relational and file source system to ODS, Data marts and Data warehouse.
• Designed and developed ETL load strategy to populate the Data Warehouse from Oracle.
• Standardized parameter files to define session parameters such as database connection for sources, targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance. Involved in Unit, Integration, system, and performance testing levels.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Monitor and troubleshoots batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Extensively used SQL* Loader to load data from flat files to the database tables in Oracle.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developed UNIX shell scripts for running batch jobs and scheduling them.

Environment: Informatica Power Center 8.1, Oracle 9i/10g, PL/SQL, TOAD 9.0, UNIX Shell Scripts, OBIEE, MS-Office, Windows XP, IBM AIX.

Confidential

Database Developer

Responsibilities:

• Creating Database objects including Tables, Views, Synonyms, Indexes, Clusters and Sequences.
• Performance monitoring and tuning of Oracle database servers. Identifying integrity constraints for tables
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Creation of logins and user ids and setting up privileges and procedures for protection of data.
• Job responsibilities include developing on-line screens using SQL Forms 4.5, creating database objects like tables, indexes, views etc. using SQL Plus, import and export of data using SQL Loader.
• Reports were developed using Oracle Reports 2.5.

Environment: Oracle 7.x, Developer 2000, SQL Forms 4.5, SQL Plus, SQL Loader, Oracle Reports 2.5, Designer2000, PL/SQL, J2EE, UNIX, Win NT, Visual Basic.