PROFESSIONAL SUMMARY

• Over 7 years of experience in Information Technology with a strong background in Database development and Data warehousing
• 7 years of extensive hands on experience with Informatica client tools like designer, workflow manager, workflow monitor and repository manager.
• Excellent Knowledge on Slowly Changing Dimensions, Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT Dimensions tables, Physical Logical data modeling.
• Worked in different phases of the projects involving Requirements Gathering, Design, Development, Deployment and Project Closure
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle SDLC .
• Developed complex Mappings, used transformations such as lookups, Router, Filter, Expression, Aggregator, Joiner, and Update Strategy and more.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling and reporting and monitoring capabilities of IDQ 9.5.1.
• Worked with wide variety of sources like Relational Databases, Flat Files, VSAM and MQ Series and Scheduling tools like Control-M and Informatica Scheduler.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Hands on experience working in LINUX, UNIX and Windows environments.
• Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse.
• Very good exposure to Oracle 10g, 9i, 8.x, MS SQL Server 2000/2005, IBM DB2, Teradata databases.
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

Technical Skills

PROFESSIONAL EXPERIENCE

Confidential

Role: ETL Developer

Description: Confidential corporation which designs, manufactures, markets and sells machinery and engines and sells financial products and insurance to customers via a worldwide dealer network. Caterpillar has grown to be the world's largest maker of construction and mining equipment, diesel and natural gas engines, and industrial gas turbines.

Responsibilities:

• Analyzed the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.

• Worked extensively on various transformations like Normalizer, Expression, Union, Joiner, Filter, Aggregator, Router, Update Strategy, Lookup, Stored Procedure, and Sequence Generator and created mappings.
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database.
• Created workflows and worklets for Designed Mappings.
• Implemented logic for Slowly Changing Dimensions.
• Worked with Informatica Data Quality 9.5.1 IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.
• Wrote Stored Procedures Functions to do Data Transformations and integrate them with Informatica programs and the existing applications.
• Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
• Also extensively worked on SQL coding for overriding for generated SQL query in Informatica.
• Involved in Unit testing for the validity of the data from different data sources.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions.
• Worked on Parameterize of all variables, connections at all levels in Window XP.
• Involved in migrating the ETL application from development environment to testing environment.
• Performed data validation in the target tables using complex SQLs to make sure all the modules are integrated correctly.
• Analyzed Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Created UNIX shell scripts for Informatica pre/post session operations.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

Environment: Informatica 9.5.x, IDQ,Oracle 11g, MS SQL Server 2008, Power Exchange 8.6.1, flat files, Windows XP, UNIX.

Confidential

Role: ETL Developer

Description Confidential insurance company. The company continues to operate as a wholly owned subsidiary of Manulife and its headquarters remains in Boston, Massachusetts. The Insurance DW project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. Claims, Premium, Loss and Contracts were some of the modules to deal with.

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Complex mappings using Unconnected and connected Lookups, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup.
• Created events and tasks in the work flows using workflow manager.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Daily production supports for the scheduled job and provide the resolution related to failed job and fixed them.
• Performance tuning of the workflow which are taking time.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Creation of technical documents.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in migration of the code from IDQ to power center.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Environment: Informatica Power Center 9.1, Power Exchange, PL/SQL, Oracle 10g/9i, SQL Server 2005/2000, Windows Server 2003, UNIX, Toad, Visual Source Safe VSS .

Confidential

ETL Informatica Developer

Description: Confidential is a large telecommunications carrier. Quest Communications provides long-distance services and broadband data, as well as voice and video communications globally. This project includes developing Data warehouse from different data feeds and other operational data sources.

Responsibilities:

• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Involved in design phase of logical and physical data model using Erwin 4.0.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer.
• Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
• Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator,
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Prepared low level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans System Test cases.
• Creating new and enhancing the existing stored procedure SQL used for semantic views and load procedures for materialized views.
• Created BTEQ scripts to extract data from EDW to the Business reporting layer.
• Developed BTEQ scripts for validation testing of the sessions, data integrity between source and target databases and for report generation.
• Worked on import and export of data from sources to Staging and Target using Teradata MLOAD, Fast Export, TPUMP and BTEQ.
• Addressed many performance issues on ETL jobs, semantic views, stored procedures, Reporting and Ad-hoc SQL.
• Analyzed and designed USI and NUSI based on the columns used in join during data retrieval.
• Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Tuned Informatica mappings to improve the execution time by applying suitable Partitioning mechanisms and tuning individual transformations inside the mapping.

Environment: Informatica Power Center 9.1, IDQ Toolkit, Informatica Power Exchange, Oracle 11g, PL/SQL, SQL Server, DB2, Teradata 13.10, Clear Case, Erwin, Business Objects Info view, Windows, UNIX.

Confidential

Informatica Developer

Description: v customers and businesses worldwide with a broad portfolio of transportation, e-commerce and business services. They offer integrated business applications through operating companies competing collectively and managed collaboratively, under the respected FedEx brand.

Responsibilities:

• Design, Development and Documentation of the ETL Extract, Transformation Load strategy to populate the Data Warehouse from the various source systems.
• Worked on Informatica 8.6.1 client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in design and development of complex ETL mappings.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Mappings, transformations and sessions to optimize session performance.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets,
• Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Implemented partitioning and bulk loads for loading large volume of data.
• Performance tuning by session partitions, dynamic cache memory, and index cache.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Created Stored Procedures in PL/SQL.
• Created UNIX Shell scripts to automate the process.
• Developed Documentation for all the routines Mappings, Sessions and Workflows .
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts.
• Played a key role in all the testing phases and responsible for production support as well.

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g, TOAD 10.1 for Oracle, DB2, Flat Files, PL/SQL, ERWIN 7.3, Windows 2000, UNIX PERL scripting, Autosys

Confidential

Role: Informatica ETL Developer

Description: InfoTech enterprises Limited are a global engineering services and solutions company. It has 11,000 employees across 38 global locations as of November 2013. InfoTech Enterprises is among the top 100 outsourcing companies in the world.

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed and developed complex aggregate, join, look up transformation rules business rules to generate consolidated fact/summary data identified by dimensions using Informatica Power Center 8.5.x tool.
• Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
• Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
• Design of ETL Mappings and Workflows using powercenter designer and workflow manager.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.
• Used Shell Scripting to automate the loading process.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Used command line program pmcmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed processes to extract, transform, and load data to the Data Mart.
• Performed impact analysis, remedial actions and documented on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Environment: Informatica PowerCenter 8.5.x, ETL, Oracle 8i, SQL Server2000, MS Access, SQL, PL/SQL, Windows NT.