SUMMARY

• More than 7 years of IT experience
• Over 6 years’ experience in Data Warehousing technology in Informatica.
• 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.
• 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 TOADQuest Software Extensive.
• Reference Data Management Testing experiencewith 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 PowerCenter 9.1/8.x, Informatica PowerExchange 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

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

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

Other Tools: SQL*Plus, MS-Office, Toad WinSCP, Putty, SCM.

PROFESSIONAL EXPERIENCE

Sr. ETL developer

Confidential, IL

Responsibilities:

• Worked on MDM and Data sync projects loading large volumes of current and historical data into datamarts.
• Volume of daily data was 3-4 million.
• Participated at all levels of SDLC by attending meeting s and requirement gathering.
• Created complex mappings using various transformations like Lookup, Aggregator, Stored Procedures etc.
• Loaded files from Siperian tables and VSAMfiles, XML and flat files into target databases.
• Created Datamarts and used various transformations to load files into higher levels for further analysis.
• Worked on large databases.
• Extensively used SCD1 and SCD2 to create mappings.
• Used Autosys to start Unix scripts to call Infromatica workflows.
• Worked in Development, provided support in QA and Production environment.
• Optimized the mapping by testing and using SQL queries and performance tuning.

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

Sr. ETL developer

Confidential, IL

Responsibilities:

• The main objective of the project was to create a data warehouse to maintain the mortgage transactions. We collected daily transactions like home purchase, refinance, bankruptcy, foreclosure and validate them and apply business logic based on the transaction type or code. The volume of transactions large .
• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing equirements.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 OLAPapplication 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 9.1, Informatica PowerExchange 9.1, OLAP, Oracle 11g, Teradata 13. MS SQL Server 2008, IBM DB2/400, Sybase, MS Excel 97, Flat files, PL/SQL, SQL, SQL*Loader, Erwin 7.1, Toad 7.0, Windows 2007, HP-UX, and Unix Shell Scripting.

ETL developer

Confidential, 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, NJ

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.