PROFESSIONAL SUMMARY:

• ETL Developer having around 4.2 years of experience in Data warehousing with ETL tool - Informatica Power Center 8.6.1/9.1.0 , Oracle and Unix
• Extensively worked on Informatica designer components Source Analyzer, Target Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer
• Extensive experience in extraction, transformation and loading of data directly from different homogenous & heterogeneous source systems like flat files, Excel and Oracle
• Responsible for development, testing and implementation of Informatica mappings and workflows necessary to extract data Transform and Load the legacy data into Oracle Staging Area
• Hands on experience with complex mappings from varied transformation logics like Connected and unconnected Lookups
• Expression, Router, Aggregator, Joiner, Update Strategy and Reusable transformations etc
• Extensively worked on Informatica Workflow Manager and Monitor tools to load data
• Extensively worked on finding bugs after workflow run by using session log
• Strong Data modeling experience using Confidential /Snowflake schemas, Reengineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling, Visio
• Expertise in error handling, debugging and problem fixing in Informatica
• In-Depth knowledge of Development Life Cycle including Requirements gathering, Analysis, Design, Implementation and Maintenance of data warehouses and data marts
• Good experience in SQL and UNIX
• Ability to work well in both a team environment and individual environment

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6.0/9.1.0

Data Bases: Oracle 9i/10g/11g

Data Base Tools: TOAD, SQL Developer

Languages: C, C++, Java

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Technology: Informatica Power Center 9.1.0, Oracle 11g, SQL, TOAD, UNIX, Flat files

Responsibilities:

• Worked closely with Business Analyst and Data Architect in analyzing the source systems and preparation of ETL specifications for Data warehouse
• Specialized on analyzing the session logs from the WorkFlow Monitor, for error detection and correction. Performed error detection and rectification procedures to improve data accuracy
• Tuned the developed mappings, transformations and sessions based on performance bottlenecks and the session log analysis results, to optimize the performance during the transformation and loading phases
• Converted the Lookups to dynamic lookups to improve the performance based on the loads of mappings
• Worked on the production support team for monitoring the sessions, analyzing the failed sessions and generating status reports using Informatica Workflow manager
• Worked on Conversion and Analysis of data stored in the data warehouse
• Coordinated with source system owners for day-to-day ETL progress monitoring, data warehouse target schema design ( Confidential Schema) and maintenance
• Provided assistance by responding to inquiries regarding errors, problems or questions about the Informatica Mappings, Sessions
• Gained expertise in UNIX Shell scripting by implementing PMCMD utility, automating the Data Load processes to target Data Warehouse, creating post-session and pre-session shell scripts and mail-notifications
• Used Mapping Variables, Mapping Parameters and Session Parameters and passed the value of parameters from a parameter file to filter the data
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table
• Involved in unit testing, integration testing and system testing of the mappings and writing Unit and System Test Plan
• Improved development reusability by building reusable transformations and mapplets to use in multiple mappings
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was huge

Confidential

ETL Developer

Technology: Informatica Power Center 8.6.0/9.1.0 , Oracle 11g, SQL, TOAD, UNIX, Flat files

Responsibilities:

• Involved in the full life cycle development of the data warehousing project including design, development and testing
• Developed Informatica mappings, mapplets and worklets to load staging area and Data Marts and implemented Performance tuning of Informatica and databases
• Worked on issues with migration from development to testing
• Maintained warehouse metadata, naming standards and warehouse standards for future application development
• Developed a Global shared folder that consists of sources and targets that are used by various mappings in different folders
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications
• Used Parameter files to restore multiple DB connections to the sources and to share some arguments between the different transformations
• Created shared folders, local and global shortcuts to reuse metadata
• Improved the performance of the ETL by using session partitions, dynamic cache memory, and index cache
• Deployed the Type 2 SCD mappings into the repository, in response to the requirement for tracking historical sales data
• Applied partitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various Informatica mappings which process large volume of data
• Debugged maps using Debugger and Transformation’s data

Confidential

ETL Developer

Technology: Informatica Power Center 8.6.0, Oracle 10g, SQL, UNIX, flat files

Responsibilities:

• Implemented the ETL processes using Informatica Power Center to load data from flat files and Oracle into the target data warehouse, as per requirement documentation
• Used Source Analyzer and Target Designer to import the source and target database schemas into the Informatica Designer
• Converted Excel and Access source files containing historical sales transactions into delimited and fixed-width flat files, before importing their source schema into Power Center Designer
• Performed data transformations in Power Center Designer using Sequence generators, Filters, Aggregators, Expressions, Routers, Rankers and Source Qualifier
• Deployed the Type 2 Slowly Changing Dimension mappings into the repository, in response to the requirement for tracking historical sales data
• Used Mapping Variables and Mapping Parameters and passed the value of parameters from a parameter file to filter the data
• Created sessions using Informatica WorkFlow Manager to test/execute the mappings and for loading data to the target
• Designed and developed Oracle PL/SQL packages for Data Import/Export
• Used WorkFlow Monitor to monitor the running sessions and scheduling the sessions
• Checked workflow and session logs to trace and verify the session run, Informatica-generated SQL commands, rejected rows and read/write errors
• Scheduled workflows to run on daily and weekly basis, using Workflow Manager