SUMMARY

• 8+ years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for various domains.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production support.
• Extensive experience in Informatica (9.0.1, 8.6, 8.1, 7.1.3) applications. Designed and developed the Workflows, Worklets, Mappings and Sessions.
• 2.5 years of experience in CDC using Informatica PowerExchange.
• Experience in Testing Informatica Mappings.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked on documentation of Design requirements, Test data, Data movement schema and Mapping between applications.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Extensively used Slowly Changing Dimension (SCD) technique in banking application.
• Conducted Unit tests, Integration tests and Customer Acceptance tests.
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling.
• Developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using SQL, PL/SQL, SQL PLUS and TOAD Quest Software Extensive.
• Reference Data Management Testing experience with HP Quality Center with full SDLC, STLC understanding.
• Production support experience. Extensive understanding of Production issues and Data issues.
• Excellent communication skills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.
• Working experience in Agile and Waterfall methodologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.x/7.1, Informatica Power Exchange 9.1/8.6

Databases: Oracle 11g/10g/9i, MS SQL Server 2000/7.0/2008 , MS Access 7.0/ 97/ 2000, Sybase, Teradata 13/12, DB2

BI Tools: Business Objects XI R2

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, Demoralization

Programming: Java, Unix Shell Scripting, SQL, PL/SQL, HTML.

Environment: Windows XP/2000/98, Win NT 4.0, UNIX (Sun Solaris, AIX, Linux), MS-DOS

Other Tools: SQL*Plus, MS-Office, Toad, Putty, SCM, VB 5.0

PROFESSIONAL EXPERIENCE

Sr. ETL developer

Confidential, Lombard, IL

Responsibilities:

• Used Power Center to design multiple mappings with embedded business logic.
• Used Power Exchange for CDC
• Worked on different source systems (oracle 10g, and flat files) by incorporating business rules into the
• Incorporated business rules into the mappings using various transformations.
• Designed several complex mappings.
• Implemented mapping for slowly changing dimensions (SCD 1 & 2) to maintain current data as well as historical data
• Extensively worked on Oracle databases.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for ETL process under development, test and production environments.
• Developing stored procedures, views, and adding/changing tables for data load, transformation and data extraction.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Loaded Dimensions and fact tables.
• Developed large data warehouse for real estate transactions by gathering data from various source systems.
• Worked on performance tuning the transformations and mappings.
• Performed Unit Testing and fixed bugs in existing mappings.

Environment: Informatica Power Center 8.1, Power Center 9.1 OLAP, Oracle 11g, Teradata 13. MS SQL Server 2008, IBM DB2/400, Sybase, MS Excel 97, Flat files, QL, PL/SQL, SQL, SQL*Loader, Erwin 7.1, Toad 7.0, Windows 2007, HP-UX, and Unix Shell Scripting

ETL Developer

Confidential, Skokie, IL

Responsibilities:

• Developed data warehouse for healthcare research by gathering data for various diseases.
• Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Implemented Slowly Changing Dimensions - Type I and Type II in different mappings as per the requirements.
• Involved in gathering requirements and created design documents and mapping documents.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner
• Fine-tuned existing Informatica maps for performance optimization.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Involved in the Unit testing and System testing.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Using Informatica PowerCenter Designer analysed the source data to Extract & Transform from various source systems (oracle 10g, and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Hands on experience in writing test scripts, performed black box and white box testing on Informatica Mappings
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).

Environment: Informatica Power center 9.0, Oracle 9i, OLAP, Oracle 11g, MS Excel 97, Flat files, Erwin 7.5, Toad 7.0, Windows 2007, HP-UX, and Unix Shell Scripting.

Sr. ETL developer

Confidential, Lake Forest, IL

Responsibilities:

• Involved in requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Loaded data from tables, DB2, VSAM files, XML and flat files into target databases.
• Extensively worked on Oracle databases.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Worked with Metadata Manger to extract data and manage metadata.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Connected, Unconnected Lookup, Joiner, Sorter, Aggregator, newly changed dynamic Lookup, Rank, Normalizer, SQLT, Sequence generator, Update strategy and Router transformations for populating target table in efficient manner.
• Implemented mapping for slowly changing dimensions (SCD 1 & 2) to maintain current data as well as historical data
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Used shell scripts for automating the execution of maps in Autosys.
• Designed and developed Oracle QL and PL/SQL scripts for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the batch processes using Unix Shell Scripts.
• Performed Manual, Unit and Integrated Testing.
• Designed, developed and tested complex mappings.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Worked on archiving data.

Environment: Informatica Power Center 9.1, Informatica PowerExchange 9.1, OLAP, Oracle 11g, Teradata 13. MS SQL Server 2008, IBM DB2/400, Sybase, MS Excel 97, VSAM files, Flat files, QL, PL/SQL, SQL, SQL*Loader, Erwin 7.5, Toad 7.0, Windows 2007, HP-UX, and Unix Shell Scripting.

Sr. ETL developer

Confidential, IL

Responsibilities:

• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Developed PL/SQL procedures/packages to load the data into Oracle 9i. Tuning Informatica Mappings and Sessions for optimum performance
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for ETL process under development, test and production environments.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.

Environment: Informatica Power Center 8.1, Power Center 9.1 OLAP, Oracle 11g, Teradata 13. MS SQL Server 2008, IBM DB2/400, Sybase, MS Excel 97, Flat files, QL, PL/SQL, SQL, SQL*Loader, Erwin 7.1, Toad 7.0, Windows 2007, HP-UX, and Unix Shell Scripting.

ETL developer

Confidential, Bethlehem, PA

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Extracting data from various heterogeneous sources like Teradata, SQL server and Flat file, performed complex joiner, aggregate, lookup and filter transformations to extract transform and load data.
• Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Develop ETL mappings to maintain history for Customer, loan dimensions.
• Created Mapplets and Work lets using set of transformations for Reusability.
• Used Informatica user defined functions to reduce the code dependency.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Provided production support by running the jobs and fixing the bugs.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.1, Unix Shell scripting, Oracle 10g, SQL, PLSQL, flat files, LINUX, WinSCP, DB2.

Informatica Developer

Confidential, IL

Responsibilities:

• Migration of Informatica folders from Non-vault environment to vault environment.
• Created specification and mapping design documents based on the data models and data available in source systems.
• Developing Mappings as per the Design Document with proper naming Conventions for Transformations and Mapping Variables.
• Coordinate with offshore development team in Infrastructure and Integration Projects.
• Migrated ETL objects to QA, UAT and Production environments.
• Migrated from SQL server 2005 to SQL server 2008 R2 performed manual testing and data validated.
• Performed data load from various customers as part of production activity.
• Created and executed SQL Server Integration Service packages to populate data from Text files to Staging Data and then to Datamart.
• Responsible for applying business logic and data cleansing in staging data.
• Used Analytical services processing to process cube after Datamart refresh.
• Automated the ETL process the cube automatically after loading the data.
• Involved in extracting the data using Informatica 9.0.1 from OLTP to OLAP
• Performed data consistency check and Performance tuning.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, views, and adding/changing tables for data load, transformation and data extraction.
• Involved in optimizing code and improving efficiency in databases including re-indexing and performing other maintenance tasks.

Environment: Informatica Power center 7.1, Oracle 9i, SQL Server 2000, UNIX, HP Quality Center.