SUMMARY:

• Around 8 years of total work experience in Data Warehousing, Database Design, and ETL process
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Highly proficient in Development, Implementation and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Exposure to reporting in Actuate
• Expertise in developing Informatica Mappings/ Mapplets using various Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, etc. between Source and Target using Informatica Power Center Designer.
• Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star schema, Snowflake schema and Dimensional modeling.
• Strong skills in SQL development
• Experience as onsite coordinator and offshore Project lead
• Experience in interacting with Business users, Architecting requirements and design documents.
• Expertise in production support and handling production issues. 
• Team player and self-starter with good communication skills and ability to work independently.
• Experience in mentoring new joiners

TECHNICAL SKILLS:

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

Databases: Oracle 12c/11g/10g, MS-SQL Server

Languages: SQL

Database Tools: SQL Developer

Operating Systems: Windows and Linux

PROFESSIONAL EXPERIENCE:

Confidential

ETL developer

Responsibilities:

• Preparation of ETL Architecture Document. Preparation of High Level Design Document & Detailed ETL Design Document.
• Developed Data Flow diagrams to create Mappings and Test plans. These data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Designed and developed Informatica Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Connected and Unconnected Lookup, Normalizer, Update Strategy etc.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, SQL Server, Flat files and loaded into target.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping enhanced Performance for Informatica sessions using large data files by using partitions.
• Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Batch (DOS) scripting
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Validate the data in source and target systems using PL/SQL queries.
• Involved in migration of mappings and sessions from development repository to production repository.
• Installed and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica, Oracle 11g, SQL Developer, Windows NT, LINUX.

Confidential, Houston, TX

ETL Informatica developer

Responsibilities:

• Extensively worked on Informatica  Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica  Power Exchange. 
• Worked with Data modeler, according to changes in the model worked on changes in the Informatica . 
• Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica  power exchange in the source analyzer. 
• Imported the Target definitions into Target Designer from oracle and for DB2, VSAM files used Informatica  power exchange in the Target Designer. 
• Working with Business Analyst, Translating Business requirements into Functional requirements. 
• Developed and Tested new mappings. Created and configured the sessions for work flow. 
• Created and maintained parameter files for workflows in the UNIX and CVS. 
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier. 
• Implemented slowly changing dimensions - Type I, II &III in different mappings as per the requirements. 
• Created connections for relational, Non-relational and applications in the workflow manager. Created mappings using Reusable Transformations. 
• Migrating mappings, workflows and parameter files from development to production. 
• Developed PL/SQL scripts line packages and store procedures for data updates. 

Environment: Informatica  PowerCenter 8.6, Oracle 11g, DB2 Mainframe, Flat files, UNIX, shell scripting, SQL Developer, Oracle 11g, Windows XP

Confidential, Washington, DC

ETL Developer

Responsibilities:

• End-to-end ETL development of the Premium Module Data Mart. 
• Maintained warehouse metadata, naming standards and warehouse standards for future application development. 
• Parsing high-level design spec to simple ETL coding and mapping standards. 
• Worked on Informatica  Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. 
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting. 
• Understand the business needs and implement the same into a functional database design. 
• ETL Migration process from legacy scripts to Informatica  Power Center. 
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs. 
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) 
• Data Quality Analysis to determine cleansing requirements. 
• Involved in dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. 
• Designed and developed Informatica  mappings for data loads. 
• Extensively used Erwin for data modeling and Dimensional Data Modeling. 
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. 
• Extracted data from Sales department to flat files and load the data to the target database. 
• Tuning Informatica  Mappings and Sessions for optimum performance. 
• Created and maintained several custom reports for the client using Business Objects. 
• Generated reports using BO tools querying database. 
• Created standard and Ad hoc reports using Business Objects. 

Environment: Informatica  PowerCenter 7.3.1, Teradata, Business Objects XI/6.5, Erwin 3.5, PL/SQL, Oracle 9i, DB2