SUMMARY

• Over 8 years of IT experience in developing full life cycle including requirement gathering, analysis, design, development, testing, implementation and maintenance of Data Warehousing and OLAP Applications using Informatica ETL tool.
• Expertise in design, development, testing of data warehousing applications against high volume data sources using Informatica (PowerCenter 6.x/7.x/8.6) and Oracle 8i/9i/10g.
• Strong expertise in Extraction, Transformation and Loading data from various source systems using Informatica Power Center Tools (PowerCenter 6.x/7.x/8.5), SQL, PL/SQL and Unix Shell scripting.
• Expertise in ETL processing using Informatica Power Center Mapping Designer, Workflow manager, Workflow monitor, Integration Services and Repository Services.
• Strong Knowledge of Data Warehousing and Data modeling Concepts like Dimensional Modeling, Star Schema and Snowflakes Schema.
• Strong Experience in writing Structured queries, Stored procedures, functions, triggers using SQL and PL/SQL.
• Strong experience in design (Logical & Physical) of databases, data warehouses and RDBMS development using Oracle 8i/9i/10g.
• Conversant wif quality procedures in executing teh projects. An enthusiastic and project - oriented Team player, wif excellent communication and analyzing skills to develop a creative solution for challenging business needs.
• Good noledge in various functional domains of Insurance, ERP and Retail.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x.

Languages: SQL, PL/SQL and UNIX Shell Scripting.

Databases: Oracle 10g/9i/8i.

GUI: Developer 2000 Forms and Reports.

Tools: and Utilities: Oracle SQL Developer, Toad, SQL*Loader.

Operating systems: Windows and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Andover, MA

Informatica ETL Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Flat files.
• Development of ETL using Informatica.
• Applied slowly changing dimensions like Type 1 and 2 TEMPeffectively to handle teh delta Loads.
• Prepared various mappings to load teh data into stages and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing teh Mapping.
• Developed Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored teh results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of teh existing mappings based on teh user requirements and maintained existing mappings, sessions and workflows.
• Tuned teh performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
• Prepared SQL Queries to validate teh data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures in Oracle.
• Worked extensively on SQL and PL/SQL as part of teh process to develop several scripts to handle different scenarios.
• Automated teh Informatica jobs using UNIX shell scripting.

Environment: Informatica Powercenter 9.5.1, Visio, WindowsXP, Unix, SQL, PL/SQL, SQL Developer and TOAD .

Confidential, Milwaukee

ETL Developer

Responsibilities:

• Involved in teh Data warehouse Data modeling based on teh client requirements
• Created Data Warehouse Data Modeling used by Erwin
• Coordinated wif teh client and gathering teh User requirements.
• Extensively worked wif teh dimensional data modeling methodology Star, Snow Flake data model based on teh business requirements
• Created teh Entity Relationship for teh Facts and Dimensions for teh Data Modeling Design.
• Created high-level process flow diagram using MS Visio.
• Creating Users, Folders and assigning teh privileges to them for teh Security also administration of repository.
• Based on teh Requirement created Cursors for applying teh transformation logics
• Used various Index techniques to improve teh query performance.
• Done Various Performance Tuning of SQL and worked wif DBA for table partitioning
• Created Materialized views for refreshing teh data
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into teh data mart.
• Used PMCMD command to start, stop and ping server from teh UNIX
• Used various debugging techniques to debug teh mappings
• Extensively used various active and passive Informatica transformations and created UNIX shell scripts and used as pre or post session command
• Used update strategy, expression, sequence generator and other transformations to implement slowly changing dimension (SCD) and extensively worked to tune performance on teh transformations like Lookup, Aggregator, Sorter, sequence generator, source qualifier
• Created UNIX shell scripts and called them as pre session and post session commands.
• Created reusable Mapplets and transformations in Informatica.
• Developed Informatica parameter files to filter teh daily data from teh source system
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
• Creating Test cases for Unit Test, System Integration Test and UAT to check teh data quality
• Migrating teh mappings and workflows from development server to Production Server.
• Automated teh ETL Process.
• Responsible for loading data into warehouse from different sources using SQL Loader to load millions of records.

Environment: Informatica Power Center 9.5, Oracle 9i,SQL Server 2000,Erwin, MS Visio, Toad, Windows 2000, UNIX,Shell Scripting, PL/SQL, SQL, SQL*Plus.

Confidential, CT

Informatica ETL Developer

Responsibilities:

• Analysis of functional requirements to create technical specifications.
• Used Informatica for extraction from legacy and Oracle based sources, and workflow monitor to oversee teh work flows and get teh session properties and session logs.
• Analyze and profile Source data to identify data cleansing requirements.
• Developed Informatica Mappings and Workflows to load data from Source systems.
• Create Transformations like Lookup, Aggregation, Expression, Source Qualifier,Updatestratagy transformation and others in teh Informatica PowerCenter Designer.
• Create reusable transformations.
• Use Teradata MultiLoad to load data into target tables.
• Implement Dimensional Data Modeling using Star Schema - to create Fact and Dimension tables for teh Data Warehouse.
• Create extensive documentation on Data Analysis, ETL design, development, historical loads and daily loads.
• Test Informatica Mappings and Workflows.
• Use Informatica Debugger to troubleshoot mappings.
• Coordinate deployments wif teh Database and Informatica Deployment teams.
• Create Labels, Queries and Deployment groups using Informatica Repository Manager
• Monitor Workflows in Production Environment and debug/resolve issues.
• Performance tuning of Informatica Transformations, Mappings and Sessions to reduce runtime of batch jobs.
• Created UNIX Shell scripts to automate teh generation of parameter files for teh various mappings and sessions, execute various SQL/PLSQL scripts.

Environment: Informatica9.1, Oracle 9i, Erwin, Unix, SQL, PL/SQL, SQL Developer and TOAD.

Confidential, CA

Responsibilities:

• Involved in teh Data warehouse Data modeling based on teh client requirements
• Created Data Warehouse Data Modeling used by Erwin
• Coordinated wif teh client and gathering teh User requirements.
• Extensively worked wif teh dimensional data modeling methodology Star, Snow Flake or hybrid data model based on teh business requirements
• Created teh Entity Relationship for teh Facts and Dimensions for teh Data Modeling Design
• Used various Index techniques to improve teh query performance.
• Done Various Performance Tuning of SQL and worked wif DBA for table partitioning
• Created Materialized views for refreshing teh data
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into teh data mart.
• Used PMCMD command to start, stop and ping server from teh UNIX
• Used various debugging techniques to debug teh mappings
• Extensively used various active and passive Informatica transformations and created UNIX shell scripts and used as pre or post session command
• Used update strategy, expression, sequence generator and other transformations to implement slowly changing dimension (SCD) and extensively worked to tune performance on teh transformations like Lookup, Aggregator, Sorter, sequence generator, source qualifier
• Created UNIX shell scripts and called them as pre session and post session commands.
• Created reusable Mapplets and transformations in Informatica
• Developed Informatica parameter files to filter teh daily data from teh source system
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
• Creating Test cases for Unit Test, System Integration Test and UAT to check teh data quality
• Migrating teh mappings and workflows from development server to Production Server.
• Responsible for loading data into warehouse from different sources using SQL Loader to load millions of records.

Environment: Informatica Power Center 9.0, Business Objects XI, Flat files. Oracle 9i,SQL Server 2000,Erwin, MS Visio, Toad, Windows 2000, UNIX Shell Scripting, PL/SQL, SQL, SQL*Plus

Confidential, CA

Informatica ETL Developer

Responsibilities:

• Coordinated wif teh client and gathering teh user requirements.
• Involved in teh Data warehouse Data modeling based on teh client requirements
• Designed and developed ETL process using Informatica tool.
• Generated teh data warehouse objects DDL scripts using Data modeling tool Erwin
• Created teh Shell Script in UNIX to keep 24 months of data in teh table.
• Performance tuning of sources, targets, mappings and SQL queries in teh transformations.
• Created reusable transformations and used in various mappings.
• Used various debugging techniques to debug teh mappings.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed informatica parameter files to filter teh daily source data.
• Responsible for loading data into warehouse using Oracle Loader.
• Created views for summary tables for better query performance.
• Used various Index techniques to improve teh query performance.
• Created Test cases for Unit Test, System Integration Test and UAT to check teh data quality.

Environment: Informatica Power Center 8.6, PowerConnect, Oracle 9i,SQL Server 2000, Erwin, MS Visio, Windows 2000, UNIX .

Confidential, CA

ETL Developer

Responsibilities:

• Involved in teh Data warehouse Data modeling based on teh client requirements
• Designed and developed ETL process using Informatica tool.
• Created teh Shell Script in UNIX for scheduling jobs.
• Performance tuning of sources, targets, mappings and SQL queries in teh transformations.
• Created reusable transformations and used in various mappings.
• Used various debugging techniques to debug teh mappings.
• Developed mapping to implement type 2 slowly changing dimensions.
• Developed informatica parameter files to filter teh daily source data.
• Responsible for loading data into warehouse using Oracle Loader.
• Created views for summary tables for better query performance.
• Used various Index techniques to improve teh query performance.

Environment: Informatica Power Center 8.5, Oracle 9i, SQL Server 2000, Erwin,, Windows 2000 and UNIX .