SUMMARY:

• Over 7+ Years of IT experience in Data modeling, Data integration, Data Migration in designing, implementation, development, testing and maintaining the ETL components in building Data Warehouse & Data marts across Health Care, Manufacturing, Retail, Finance, Insurance, and Banking. 
• Experienced in all stages of the software lifecycle architecture (Waterfall model, Agile Model) for building a Data warehouse. 
• Well acquired on Informatica PowerCenter 9.x/8.x Designer Tools (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Workflow Manager Tools (Task Developer, Worklet and Workflow Designer) and Repository Manager & Admin console. 
• Involved in troubleshooting data warehouse bottlenecks, performance tuning - session and mapping tuning, session partitioning & implementing pushdown optimization. 
• Extensively worked on various transformations like Lookup, Joiner, Router, Rank, Sorter, Aggregator, Expression, etc. 
• Strong understanding to Data Warehousing, Data Architecture, Data Modeling, Data Analysis, SDLC Methods and GUI applications. 
• Good Understanding with experience in Ralph Kimball Methodology, Bill Inmon Methodology, creating entity-relational and dimensional-relational table modeling using Data Modeling (Dimensional & Relational) concepts like Star Schema Modeling and Snowflake schema modeling. 
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management 
• Extensive experience with Data Extraction, Transformation, and Loading(ETL) from heterogeneous Data sources of Multiple Relational Databases like Oracle, Netezza, Teradata, DB2, SQL Server, MS Access and worked on integrating data from flat files like fixed width and delimited, CSV, XML into a common reporting and analytical Data Model using Informatica. 
• Experienced with Teradata utilities like Fast load, Fast export, Multi load, TPUMP & TPT, and BTEQ scripts.
• Experience on Oracle utilities like SQL Loader, TOAD. 
• Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers. 
• Experience in using the Informatica command line utilities like PMCMD and PMREQ to execute workflows in Unix environment.
• Good programming skills in SQL, PLSQL, TSQL 
• Used CA7 and ClearCase for automation of workflows and Subversion for versioning. 
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment, Normalization & Denormalization, Cleansing, Performance
• Optimization along with the CDC (Change Data Capture). 
• Good Experience in UNIX Shell scripting & Windows Batch Scripting for Parsing Files & Automation of batch ETL jobs. 
• Strong knowledge in RDBMS concepts and extensive experience in creation and maintenance of Tables, Views, Materialized Views, Stored Procedures, Packages, Synonyms, Indexes, Triggers, Bulk Load and PL/SQL programming. 
• Versatile team player with excellent analytical, communication and presentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center 9. X /8. X/7. X)

Database: Oracle, SQL,

Programming Languages: PL/SQL, SQL, UNIX shell scripting.

Job Scheduling: Informatica Scheduler, Autosys, Tivoli

Database Tools: SQL Navigator, SQL Loader

Applications: MS Word, MS Excel, MS PowerPoint, MS Outlook

Operating Systems: Windows2010, 2008/2003/2000/ XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Senior ETL Developer

Responsibilities:

• Participated in requirement gathering, business analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Created ER diagram of the data model using Erwin data modeler to transform business rules into logical model.
• Used Informatica Power Center 9.x/8.x for extraction, loading and transformation (ETL) of data in the data warehouse, from source flat files and RDBMS tables to target tables.
• Created reusable transformations and mapplets and used them in mappings.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, transformations.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Involved in client interaction, analyzing issues with the existing requirements, proposing solutions and implementing the same.
• Optimized the performance of the mappings by various tests on sources, targets and transformations by identifying the Bottlenecks, removing them and implementing performance tuning logic on targets, sources, mapping, sessions with Pipeline Partitioning and increased block size, data cache size, sequence buffer length, and target based commit interval to provide maximum efficiency and performance.
• Was also involved in production support for monitoring the jobs and fixing it without missing the SLA. 
• Debugging code, testing and validated data after processes are run in development/testing according to business rules.
• Prepared unit test plans and maintained defect logs to resolve issues. Worked with the QA team to determine the data validation and performed the data validating at the source and the target database level.
• Hands on experience as an Administrator involving Maintaining the Repository Manager for creating repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environment.
• Working on data request tickets and assisting business users (non-technical) to understand the quality of the data.

Environment: Informatica Power Center 10.1/9.5.1/9.6 , Informatica power exchange, Oracle 11g, SQL Server 2005/2008, IBM Mainframe, TSQL, MS Excel, CA Scheduler.

Confidential, New York, NY

ETL Developer

Responsibilities: 

• Responsible for requirement definition and analysis in support of Data Warehousing efforts. 
• Developed ETL mappings, transformations using Informatica Power Center 9. 
• Extensively used Informatica client tools Source Analyzer, Target Designer, Mapping Designer, Mapplet designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager. 
• Extensively used ETL tool Informatica to load data from Flat Files, Oracle and DB2.
• Developed data mappings between Source systems and Target systems using Mapping Designer. 
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor. 
• Developed and tested all the Informatica mappings and update processes. 
• Worked extensively on different transformations such as source qualifier, Expression, Filter, Aggregator, Router, Update strategy, lookup, Normalizer, Stored procedure, Mapping Variables and Sequence generator. 
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads. 
• Experience in writing Shell scripts to automate the Pre-Session and Post-Sessions Processes. 
• Used Tivoli for auto scheduling Informatica jobs. 
• Extensively optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas, and debugging some existing mappings using the Debugger to test and fix the mappings. 
• Involved in Informatica upgrade 8.x to 9.x
• Coordinated migration of mappings, sessions, and workflows from Development to Testing and then to Production environments. 
• Used pmcmd and pmreq commands in UNIX environment to start, stop and abort the sessions. 
• Worked closely with the testing team helping them in fixing the bugs. 
• Supported the daily load batch process and worked on post production issues. 

Environment: Informatica PowerCenter 9.x/8.x, Power Exchange 9.0.1, Oracle 11g, DB2, TOAD, PL/SQL Developer, SQL Loader, Erwin, SQL, PL/SQL, UNIX Shell Scripts, AIX, Teradata, Tivoli.

Confidential, Evansville, IN

ETL Developer 

Responsibilities:

• Especially worked on the benefits subject area of PDI project
• Staged Data from Legacy Proclaim IMS system into Oracle 11g Master Tables which involved extracting data from proclaim mainframe JCL and Cobol
• Performed CDC capture registrations.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Developed mappings that perform Extraction, Transformation and Load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Created High Level Design document and Low Level Design document for the projects worked on.
• Worked on code enhancements for the assigned projects.
• Slowly Changing Dimension Type 2 is implemented to maintain last 3 years of historical data.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Used tasks like Command, Decision, Event Wait, Event Raise, Assignment and Timer in the workflows and worklets to meet business requirements logic effectively.
• Created promotion packages in harvest for the code deployment to higher environments.

Environment: Informatica PowerCenter 8.x, Power Exchange 9.1.0, Oracle 11g, Toad, HP Quality Center, Tera Data,DB2, 13.X/12.X, Control M Scheduler.

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Research Sources and identify necessary Business Components for Analysis.
• Coordinating with source system owners, day-to-day ETL progress monitoring Data warehouse
• Target, Schema Design (Star Schema) and maintenance.
• Created Informatica mappings as per technical specifications.
• Created different transformations for loading the data into target database.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Developed Unix Shell Scripts and Stored Procedures to run from the Informatica pre and post sessions to create and drop the indexes to improve the speed of session execution
• Worked on issues with migration from development to testing.
• Carried out ETL Testing using Informatica and PL/SQL.
• Used SQL, PL/SQL to validate the Data going in to the Data Warehouse.

Environment: Oracle 8i, 9i, 10g, Informatica 8.X, Erwin, Windows, UNIX.